On Friday, 1 February 2013, 19:24:01, David L Babcock <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
