El 06/01/12 18:45, David Edwards escribió:
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). *
Sorry, this is a duplicate instruction not needed.
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.
- In writer Menu/Insert/Ole Object-Create new (spreadsheet object) (A).
- Copy the area from the original spreadsheet (B) including the data and
- Open the new object (A) (double click), and paste.
- Copy only the data area in (B).
- In (A) Paste special-link, overwritten the data area.
The graph in (A) is linked to data in (A)
and the data in (A) is linked to the external spreadsheet.
At least save once the external spreadsheet (B) is mandatory to get the
The data are update when a double click in (A).
To get an updated data in (A) without save (B) before, introduce with
Ctrl+Shift+Enter a DDE link overwritten the data area.
Always to get (A) updated, double click.
* Inglés - detectado
For unsubscribe instructions e-mail to: email@example.com
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