Issue 77213 - Graph on duplicated sheet becames linked to duplicated sheet's data
Summary: Graph on duplicated sheet becames linked to duplicated sheet's data
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-10 17:04 UTC by orpolo
Modified: 2014-01-07 18:39 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
A sheet with simple data and a graph. The sheet has been duplicated and the data has been changed in the new sheet. The graph on the new sheet does not reflect the changes (its data source is still Sheet1) (14.28 KB, application/vnd.sun.xml.calc)
2007-05-10 17:07 UTC, orpolo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description orpolo 2007-05-10 17:04:58 UTC 
The case described here is for data plotted on graphs that are placed on the
same sheet.

When a sheet (Sheet1) is copied (Edit->Sheet->Move/Copy menu), data and graph
are duplicated (into Sheet1_2).  The data source of the graph however remains
the original data in Sheet1.  If the data in Sheet1_2 is modified, the graph
doesn't change.  Both graphs on Sheet1 and Sheet1_2 will change if the data on
Sheet1 is changed.

It would seem more logical and useful to change the implementation of the Copy
functions so that when the graphs and data are duplicated they remain linked. 
It would allow to prepare a template sheets with the desired layout, duplicate
it and easily apply new data with a simple copy and paste, with graphs that will
reflect the changes.  This is also the behavior of Excel.
Comment 1 orpolo 2007-05-10 17:07:08 UTC 
Created attachment 45026 [details]
A sheet with simple data and a graph.  The sheet has been duplicated and the data has been changed in the new sheet.  The graph on the new sheet does not reflect the changes (its data source is still Sheet1)
Comment 2 oc 2008-07-15 10:43:41 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 3 stephan66 2013-03-09 21:52:00 UTC 
This problem is solved in version 3.3.0.

See duplicate bug #29848.
Comment 4 Edwin Sharp 2014-01-07 18:39:21 UTC 
IMHO sheets should be independent.

AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657
Debian