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

El 05/01/12 1:12, Tom Davies escribió:
> Hi :)
> In Writer
>
> Insert - Object - Chart
>
> seems to do something and then right-click on the chart and have a look at data-range or something. 
>  In the Draw guide there is a chapter about working with Objects and maybe that might help?
> http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Draw_Guide
>
> Someone else asked a similar question to this a few weeks ago and i don't think we were able to 
> help him much either :(
> Apols and regards from
> Tom :)
>
>
> --- On Wed, 4/1/12, David Edwards<dave.e@somniumtech.com>  wrote:
>
> From: David Edwards<dave.e@somniumtech.com>
> Subject: Re: [libreoffice-users] linking a calc chart into a writer document
> To: oolst@nouenoff.nl, users@global.libreoffice.org
> Date: Wednesday, 4 January, 2012, 23:56
>
> Hi Cor,
>
> Thanks for the info.
>
> I've still not managed to work out how to do this!
>
> I had used OLE linking succesfully to insert other spreadsheets into writer
> and they work fine (but doesn't OLE obsolete DDE?).
>
> When I've selected the chart and paste special there is no DDE link option.
>
> Thus I've tried anchoring the chart to a cell and copying that cell. Paste
> special does then have a DDE option, but it just pastes a link to the empty
> cell and doesn't include the chart.
>
> I wonder if using DDE linking to link the actual cells into writer,
> generate the table locally in writer would work - though I'd need a method
> to "hide" the actual cells in writer. Is there a method to do this?
>
> Thanks in advance!

To insert:
- Menu/Insert/Ole Object - Create from file, mark Link to file.
  Select the file.

To update:
- Menu/Edit/Link - update.

Or another way:
- Menu/Insert/Ole Object - Create new.
- Open the new object (double click), and paste the area from the 
spreadsheet including the data and the graph.
- Paste.
- Copy the data in original spreadsheet.
- Paste special - link.

The graph is from inserted object.
The data are linked to the original spreadsheet.

Miguel Ángel.










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