Apache OpenOffice (AOO) Bugzilla – Issue 85396
Chart embedded in copy of sheet references original data instead of copy
Last modified: 2013-02-24 21:18:44 UTC
When copying a sheet that has an embedded chart in calc, the data for the chart in the copied sheet is sourced from the original sheet instead of the copy.
I checked with "2.3.1 Multilingual German version WIN XP: [680m9(Build9238)]": 1. Opened new Spreadsheet 2. Created some data (pls. see sheet 1 in "mytestsource.ods", also for further steps) 3. Created a pie chart 4. <ESC><ESC><ESC> 5. single mouse click on the chart 6. Menu "Edit -> Cut" 7. Chaneg to Sheet2 8. Menu "Edit -> Paste" New chart appears 9. <ESC><ESC><ESC> 10. Click on Tab "Sheet2" 11. Right click on Tab "Sheet2" 12. Context Menu "Move / Copy sheet" Dialogue appears 13. Set pulldown 'To document' to "- new document -" ("- move to end position-" Check "Copy" 14. Press <OK> Expected: new Document with Pie chart in it will be created with link to data source in "mytestsource.ods" or data packed to chart image (As it will be done when you copy a chart to a WRITER document), because no other one can be available in the new document) Actual: Chart looks fine, but when you doubleclick on image to check the Data source, the graph will disappear, and the data information in context menu 'Data Ranges' wil be empty (currently I can not confirm "linked to old document"). The problem only appears if the chart is not on the same sheet as the data source That is the same behaviour as when you copy paste a chart to a new spreadsheet. I see this as an ENHANCEMENT, a selection whether chart-data should be linked to old document or be packed to chart image might be useful. No Idea whether this the same problem as the reoporter wanted to describe. Pretty sure that "my" bug exists for all OS Related to Issue 82614? Related to Issue 78080? Might be fixed with Issue 85304? I checked with "1.1.4 (German) WIN XP: [645m52 (Build 8824)]" and found the same behaviour. @mothinator: You see some difference concerning detailedness between your report and my comments? Please read our guidelines on <http://qa.openoffice.org/issue_handling/pre_submission.html> and <http://www.openoffice.org/bugs/bug_writing_guidelines.html>, then contribute a clear step by step instruction containing all observations (error messages ...), every key press and every mouse click how to reproduce the problem, so that we can decide whether you problem really is the same as I found. Additionally information concerning your OS ans Platform is required
Didn't find a real DUP, so NEW
Created attachment 51017 [details] sample file
I should have been clearer in the original post. I'm using Ubuntu 7.10 and OOo version 2.3.0 The problem I notice is when copying sheets within a book. Say you want to have a workbook that tracks sales for the year, in it, there is a sheet for each month and a line graph tracking sales per week. Every month, instead of building the sheet over, I just copy the last months sheet and enter the data for the current month. The problem is that the chart in the copied sheet still references the previous month and I must manually change the source data field in the chart to the current sheet. Thanks.
@mothinator: Thank you for your specification, that effect is reported with Issue 29848. I will close this issue as a DUP and open a new ENHANCEMENT request for the problem I found during my tests. *** This issue has been marked as a duplicate of 29848 ***
close the duplicate