Re: [libreoffice-users] linking a calc chart into a writer document

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: users+help@global.libreoffice.org
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