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

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)**.*
>
> 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). *

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
> 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!

- 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.

Regards
Miguel Ángel.

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

 * Inglés
 * Español

 <javascript:void(0);>

--
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