Issue 125930 - Copy and paste chart to new sheet results in data link loss
Summary: Copy and paste chart to new sheet results in data link loss
Status: CLOSED DUPLICATE of issue 121231
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-07 01:56 UTC by richardbaxter
Modified: 2017-05-20 09:52 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description richardbaxter 2014-12-07 01:56:15 UTC
Copying and pasting a chart to a new sheet results in data link loss with the original cells (data appears to be stored in its own embedded table). 

The user must be able to create a chart on a new sheet (or move a chart to a new sheet), otherwise it makes it very difficult to print charts consistently (as the page layout changes every time the original data sheet is updated).
Comment 1 Regina Henschel 2014-12-07 12:32:27 UTC
Do not use the clipboard to duplicate the chart, but use the Navigator. Set the link type to "Insert as copy" and drag the name of the chart from the tree view of the Navigator to the desired sheet. Charts are listed in the branch "OLE objects".

Or display the target sheet in a new window (Menu Window) and drag&drop the chart. By pressing the Ctrl-key you can duplicate the chart, otherwise it is moved.

In older versions, charts kept there data range link when copying between different documents. But the data source did not exist in the target document and therefore you lost the data. To avoid this, copying via clipboard was changed to always embed the date. Because there exist alternative ways to duplicate a chart inside a Calc document, I tend to set this issue to WONTFIX.
Comment 2 oooforum (fr) 2014-12-08 13:48:51 UTC
Already reported
After paste chart, the new one will use Data table instead of Data source.

*** This issue has been marked as a duplicate of issue 121231 ***
Comment 3 richardbaxter 2014-12-13 05:13:28 UTC
I understand the rationale for what has happened, but would argue the ability to move a chart to a new sheet is an extremely important function. Even with the instructions it is taking me longer than a minute to implement the workaround (and it is certainly not intuitive). 

I would recommend the software detecting if the copy/cut and paste operation is occurring within the same document or a different document (if it is occurring within the same document the software should operate as it has historically done and maintain a link to the original data). Likewise, an option should be provided during chart formation to create a chart on a new sheet.
Comment 4 Regina Henschel 2014-12-13 12:30:47 UTC
(In reply to richardbaxter from comment #3)
> I understand the rationale for what has happened, but would argue the
> ability to move a chart to a new sheet is an extremely important function.
> Even with the instructions it is taking me longer than a minute to implement
> the workaround (and it is certainly not intuitive). 
> 
> I would recommend the software detecting if the copy/cut and paste operation
> is occurring within the same document or a different document (if it is
> occurring within the same document the software should operate as it has
> historically done and maintain a link to the original data). Likewise, an
> option should be provided during chart formation to create a chart on a new
> sheet.

I agree with you, that a more intuitive way would be good. I can think of
(1) add an option in the wizard to generate the chart on a specified sheet or on a new one. Excel offers such choice.
(2) add an option "move" in the UI, which moves the chart to another sheet while keeping the data ranges.

Perhaps you write an new issue as enhancement request?

(In reply to oooforum from comment #2)
> Already reported
> After paste chart, the new one will use Data table instead of Data source.
> 
> *** This issue has been marked as a duplicate of issue 121231 ***

I do not think, that it is a duplicate to 121231. Because that one is about binding and unbinding a chart to an external data range. This issue is about easily choose the position of a chart inside a spreadsheet document.