Thanks for the support again!
Re. Cor's query about edit/link - yes it is active, and all the linked
cells used in *tables* appear and are shown as auto update.
The linked cells used in the hidden table *DO NOT APPEAR* in this dialog at
Re. Migel's more detailed suggestion:
*(A) Menu/Insert/Ole Object - Create new **(spreadsheet object)**.*
*- Open the new object (double click), and paste the area from the *
*original spreadsheet **including the data and the graph**. *
This *has* to be paste-special as the cells refer to the other spreadsheet
and convert to REF.
The Graph pastes in fine.
*- Paste in (A). *
Not sure what you mean here, I presume you mean select the chart within the
"new" OLE spreadsheet into the writer document.
This fails to draw the graph - it appears that the problem I suspected
earlier whereby the cells get converted into text and thus the values
aren't parsable as graph values is the problem.
When googling for details on anchoring a chart to a cell I found this
i.e. charts anchored to cells don't update problem, evidently fixed in 4.5.
Thus it looks like a solution will occur later in the year.
Thanks for all your help, I really appreciate it and will make a donation.
SOMNIUM Technologies Limited
+44 78 08 400 376
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy