On Fri, 01 Feb 2013 19:23:21 -0000, 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. On Sat, 02 Feb 2013 12:19:18 -0000, johnny smith <ka...@krovatka.su> wrote: > the workaround is to copy to the new file not the sheet's content but the > sheet itself. since then, i've found a better workaround, which is: 1. rename the sheet with the source data ranges to Sheet1 (experimenting with Sheet2 and other similar names didn't succeed), 2. rename the sheet which contains the respective data ranges in the destination document to Sheet1 too, 3. copy and paste the graph. note that the sheet on which the graph itself resides doesn't matter, only that one with the data ranges does. i do not know why the program behaves this way but it does, however. i also was not able to find how to perform the trick if the data ranges spread over several sheets. and, lastly, it's obviously a kind of unspecified behaviour indicating some issue in the underlying code. as far as i know, the problem with copying graphs between sheets exists in ms excel too. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
