You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by johnny smith <ka...@krovatka.su> on 2013/02/02 13:19:18 UTC
Re: How? copy a graph exactly (no data table) to another file
On Friday, 1 February 2013, 19:24:01, David L Babcock <ol...@rochester.rr.com> wrote:
> However the graphs so transferred appear in the new file with a data
> table instead of actual cell ranges, which kills them dead so far as
> showing changing data. They show a snapshot of last year's last data.
the workaround is to copy to the new file not the sheet's content but the sheet itself. to do it please right-click the sheet's tab in the bottom of the calc's window, open the 'move/copy sheet' window from the context menu and choose what is needed from the 'to document' list. the sheet will be copied in full with all graphs linked to the appropriate data ranges. you could then delete all the old data from the sheet's cells, leaving the graphs alone, and fill in the new content.
you should also note that i failed to reproduce the bug in the latest version of open office, 3.4.1, although i could recollect experiencing it myself in the past. so, it may have bin fixed by the developers since then. if your office is not the most up-to-date, then you could probably get your problem fixed by just upgrading.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org