On 2/2/2013 10:13 AM, johnny smith wrote:
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
Sorry for the delay.
Using your latest advice (above) I was able to get 4 of 5 graphs
transferred. The 5th graph copied over with the sheet, but when -in the
new spreadsheet- I recopied it to the correct sheet, it still popped
into "data table" form. In all 5 cases the data ranges and the graphs
are on the same sheet.
The 4 that did transfer did not go easily! Several retries. Along the
way I got the impression that using Paste Special instead of ctl V
helped, but I have no firm data on that. Looks like a bug for sure.
Thanks for the help,
Dave B.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
