You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by David L Babcock <ol...@rochester.rr.com> on 2013/02/01 20:23:21 UTC
How? copy a graph exactly (no data table) to another file
I have a file for collecting a year's data which I want to duplicate for
the next year (2013).
Since I am annoyed by a bunch of structural/embedded things that are
copied along from year to year when I do a simple rename, I am building
a new file, sheet by sheet, by copying each sheet over to it.
(This scrambles many of the links between sheets, but I can fix these.)
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.
I do not want to build anew these graphs, they are complex, with many
attribute tweaks.
Any ideas? XP, OO 3.4
Dave Babcock
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file
Posted by David L Babcock <ol...@rochester.rr.com>.
On 2/1/2013 7:58 PM, Andrew Douglas Pitonyak wrote:
>
> On 02/01/2013 02:23 PM, David L Babcock wrote:
>> I have a file for collecting a year's data which I want to duplicate
>> for the next year (2013).
>>
>> Since I am annoyed by a bunch of structural/embedded things that are
>> copied along from year to year when I do a simple rename, I am
>> building a new file, sheet by sheet, by copying each sheet over to it.
>>
>> (This scrambles many of the links between sheets, but I can fix these.)
>>
>> 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.
>>
>> I do not want to build anew these graphs, they are complex, with many
>> attribute tweaks.
>>
>> Any ideas? XP, OO 3.4
>
> I have no particular comment on your current process, but.... is it
> possible for you to create a template from this (even if you only save
> a mostly empty copy for next year) so that you can start from the
> "mostly empty" stage easily next year.
>
A template would usually work, but it's this year's special case of
trying to shake out some obscure oddities from the file, that makes a
total new file seem necessary.
In addition I would like in general to be able to copy/paste a complex
graph from one spreadsheet to another.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file
Posted by Andrew Douglas Pitonyak <an...@pitonyak.org>.
On 02/01/2013 02:23 PM, David L Babcock wrote:
> I have a file for collecting a year's data which I want to duplicate
> for the next year (2013).
>
> Since I am annoyed by a bunch of structural/embedded things that are
> copied along from year to year when I do a simple rename, I am
> building a new file, sheet by sheet, by copying each sheet over to it.
>
> (This scrambles many of the links between sheets, but I can fix these.)
>
> 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.
>
> I do not want to build anew these graphs, they are complex, with many
> attribute tweaks.
>
> Any ideas? XP, OO 3.4
I have no particular comment on your current process, but.... is it
possible for you to create a template from this (even if you only save a
mostly empty copy for next year) so that you can start from the "mostly
empty" stage easily next year.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file
Posted by johnny smith <ka...@krovatka.su>.
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
Re: How? copy a graph exactly (no data table) to another file - partial suc
Posted by David L Babcock <ol...@rochester.rr.com>.
On 2/7/2013 3:46 PM, johnny smith wrote:
> On Thu, 07 Feb 2013 18:34:02 -0000, David L Babcock
> <ol...@rochester.rr.com> wrote:
>
>> 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.
> copying between the sheets of the same document can be acomplished through
> the following ritual:
> 1. rename the source sheet to Sheet1,
> 2. create a temporary document containing a sheet named Sheet1,
> 3. copy the graph between these sheets (in fact, you can copy to any other
> tempdoc's sheet on this step, Sheet1's bare existence within the tempdoc
> is quite sufficient),
> 4. restore the source sheet's name to its original state,
> 5. rename the destination sheet to Sheet1,
> 6. copy the graph to this Sheet1 from the tempdoc's Sheet1,
> 7. rename the destination back to what it used to be previously.
>
> you see, the clue is to always copy between the sheets named 'Sheet1'. i
> realise it's ridiculous, but it works. as it has already been mentioned,
> copying graphs is a bug common throughout all spreadsheet editors.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
NOW my mind is properly boggled! I gotta try it....
Dave B
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file - partial suc
Posted by johnny smith <ka...@krovatka.su>.
On Thu, 07 Feb 2013 18:34:02 -0000, David L Babcock
<ol...@rochester.rr.com> wrote:
> 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.
copying between the sheets of the same document can be acomplished through
the following ritual:
1. rename the source sheet to Sheet1,
2. create a temporary document containing a sheet named Sheet1,
3. copy the graph between these sheets (in fact, you can copy to any other
tempdoc's sheet on this step, Sheet1's bare existence within the tempdoc
is quite sufficient),
4. restore the source sheet's name to its original state,
5. rename the destination sheet to Sheet1,
6. copy the graph to this Sheet1 from the tempdoc's Sheet1,
7. rename the destination back to what it used to be previously.
you see, the clue is to always copy between the sheets named 'Sheet1'. i
realise it's ridiculous, but it works. as it has already been mentioned,
copying graphs is a bug common throughout all spreadsheet editors.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file - partial success
Posted by David L Babcock <ol...@rochester.rr.com>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file
Posted by johnny smith <ka...@krovatka.su>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org