Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

El 06/01/12 18:45, David Edwards escribió:
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)**.*


*- 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 the graph.
- 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 link working.
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.
=DDE("soffice";"C:\YourPath\Untitled 2.ods";"Sheet1.A1:B4")
Always to get (A) updated, double click.

Miguel Ángel.

 * Inglés - detectado
 * Inglés
 * Español

 * Inglés
 * Español


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.