Hi Chaps, 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 all .... Re. Migel's more detailed suggestion: *(A) Menu/Insert/Ole Object - Create new **(spreadsheet object)**.* Yes *- 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 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=39118 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. Cheers! -- *Dave Edwards,* SOMNIUM Technologies Limited +44 78 08 400 376 -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
