Issue 122897

When modify source data only first graph updates. Second copied chart is not affected.

Rev. 1503704 Debian

Yes the clipboard format has changed although it still says "Star Object Descriptor". The clipboard should contain a third format with link to spreadsheet in addition.

Workaround: Drag the chart and hold down Ctrl-key while dragging. Notice, that the mouse pointer gets a plus.

Hi,

Workaround don’t work if you copy/paste chart in another sheet of the same Calc’s document.

Please, adjust keyword : regression

This issue can be a blocker for 4.0.1 ?

Best regards

This bug is still present in version 4.0.1.
This is truly a great limitation, when you think to solve it?

Already Reproducible with server installation of  "AOO 3.4.0 – German UI / German locale [AOO340m1(Build:9590) - Rev.1327774]" on German WIN7 Home Premium (64bit)", own separate user profile: Result of Copy / Paste with <control+c> / <control+v> is a Chart object with internal data table as I am used to see when I copy / Paste a Chart to Writer, Draw.

The modified behavior is caused by the fix for issue 118840.  The new behavior may even be "works as designed" (see comment 36 of issue 118840).

But regardless of whether we see this as bug or feature, I am not sure that there is a simple way to fix this.  For the past few days I looked into a related bug and have discovered that you need a very deep knowledge of the chart code to make any changes that don't break anything else.

Furthermore we first have to come to a clear understanding of the desired behavior.  As said above, the new behavior can be interpreted as a feature, not a bug.

Grepping to keep in sight

Confirm issue for AOO-4.0.1 and 4.1.0-beta [AOO410m14(Build:9760)  -  Rev. 1573601
2014-03-03 17:47:48 (Mo, 03 Mrz 2014)].

When I create the chart and then copy it to the same or another sheet it inserted as "Star Object Descriptor (XML)" with it's own "Chart Data Table" instead of "Data Ranges" bounded with spreadsheet's data in properties of chart.

I can't copy at all existing chart to another sheet of teh same document with saving association with spreadsheet data. In the menu "Edit - Paste Special" only "Star Object Descriptor (XML)" and "GDI metafile" are available.

Confirmed with AOO410m1(Build:9750)-Rev. 1551855 under Ubuntu_x64

(In reply to Andre from comment #6)
>the new behavior can be interpreted as a feature,
> not a bug.

For me, it's bug.

How you do to move chart in another sheet  ?
You must create a chart again, because copy or cut chart, break data range for internal data table

Still present in AOO410m14(Build:9760)  -  Rev. 1585706

Generally everybody expects a perfect clone (and not a picture) after copy: 
(a) if you want to transfer the chart to a different sheet
(b) if you want to create a copy of the chart with smaller
    modifications to demonstrate an other aspect of the data in the chart
(c) because that is the behavior of all other copy / paste actions.
(d) Version has been changed in error, back to 4.0.0
(e) Still reproducible with server installation of "AOO 4.1.0-dev – English UI
    / German locale - [AOO410m14(Build:9760)  -  Rev. 1583418_2014-04-02]" 
    on German WIN7 Home Premium (64bit)", own separate user profile.

I think it's impossible to find any user-benefit of the current behavior for using charts in Calc. If the Fix for Issue 118840 causes this one that fix will have to be reverted.

(In reply to Rainer Bielefeld from comment #11)
> I think it's impossible to find any user-benefit of the current behavior for
> using charts in Calc. If the Fix for Issue 118840 causes this one that fix
> will have to be reverted.

Issue 118840 was one of the most frequently reported bugs at the time, so it's very good that it is now fixed. The change should not be reverted until we find  a better solution that also addresses the case outlined here.

> How you do to move chart in another sheet  ?

Even so if you D&D objects outside of every AOO document:
Look into the help:
Tab Index: drag-and-drop → overview
What the help not says at this position: you have to wait a little bit when you click onto the object until the mouse cursor changed. If you don't wait the object can be moved only inside the document/sheet.

But dragging from Navigator is easy.

> You must create a chart again,

No. By dragging from Navigator you easily can have so many copies as you want.

(In reply to mroe from comment #13)
> you have to wait a little bit when
> you click onto the object until the mouse cursor changed. 
[...]
> But dragging from Navigator is easy.
> By dragging from Navigator you easily can have so many copies as you
> want.

Works fine :)

(In reply to mroe from comment #13)
> > How you do to move chart in another sheet  ?

Here we are talking about copy/paste, not about drag and drop

(In reply to Rainer Bielefeld from comment #15)
>we are talking about copy/paste, not about drag and drop

A possible behavior would be a new entry in the special-paste ?
(if is possible...)

As an additional issue with the fact a copy/paste of a chart does not generate an identical item, if the data in the chart (Y-axis) is formatted as "Currency" the formatting in the original chart will have the "source format" option ticked and the Y-axis data will be displayed as Currency.  In the Pasted chart this field 'source format" field is not ticked and the Y-axis will be displayes as the default "number".

*** Issue 125514 has been marked as a duplicate of this issue. ***

Reset the assignee to the default "issues@openoffice.apache.org".

This issue remains with 4.1.3

After creating a chart it seems the "Data Ranges" editing feature remains operational for a while. Then..(perhaps after saving?) it is suddenly replaced with "Chart Data Table", which does not allow full manipulation of the data within the chart (like re-ordering), nor easy addition of new data sets.

This occurs with the chart on the same sheet as the data, and when charts have been cut and pasted to another sheet.

"Drag and dropping" another data set into the chart brings the "Data Ranges" editing feature back, but doing so eliminates all other data sets in the chart, so that is not a work-around. Recreating the chart from scratch seems to be the only solution if "Chart Data Table" shows up.

Do not use copy and paste. Click on the chart and hold down mouse button for about 2 seconds. Then drag it while holding down the Ctrl-key to duplicate the chart. Or set drag mode to "copy" in the Navigator and drag it from the Navigator to the sheet.