Issue 85396

Summary: Chart embedded in copy of sheet references original data instead of copy
Product: General Reporter: mothinator <apascall>
Component: chartAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@graphics <issues>
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sample file none

Description mothinator 2008-01-19 19:05:22 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.
Comment 1 Rainer Bielefeld 2008-01-20 08:52:22 UTC
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
Comment 2 Rainer Bielefeld 2008-01-20 09:21:34 UTC
Didn't find a real DUP, so NEW
Comment 3 Rainer Bielefeld 2008-01-20 10:34:14 UTC
Created attachment 51017 [details]
sample file
Comment 4 mothinator 2008-01-20 23:17:45 UTC
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.
Comment 5 Rainer Bielefeld 2008-01-21 06:26:22 UTC
@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 ***
Comment 6 Mechtilde 2008-11-05 21:16:15 UTC
close the duplicate