Issue 109897 - Chart data ranges not updated when copying the sheet
Summary: Chart data ranges not updated when copying the sheet
Status: CLOSED DUPLICATE of issue 29848
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: All All
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-03-07 14:18 UTC by meseer
Modified: 2010-03-08 10:06 UTC (History)
2 users (show)

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

Attachments
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 meseer 2010-03-07 14:18:10 UTC 
Let you have a sheet with data in it and a chart which refers to those data. Let 
you copy this sheet. On a new sheet the new chart will refer to the data from the 
old sheet in spite that the new sheet has the data as well.

The expected behaviour would be to keep all references to the data on other then 
copied sheet untouched (as it is now) but adjust all references to the data on 
the copied sheet to point on the newly created sheet. The very same behaviour as 
expected is currently used for formulas in copied page.
Comment 1 meseer 2010-03-07 14:30:26 UTC 
Even if you update data range references from default absolute references (like 
$Template.$R$50:$T$81) to relative one (like Template.$R$50:$T$81), you will get 
an absolute reference to old sheet on the copied sheet, which is clearly a bug.
Comment 2 Rainer Bielefeld 2010-03-08 10:05:17 UTC 
@meseer:
Thank you for your attention!
Please always specify your OS and Platform!

*** This issue has been marked as a duplicate of 29848 ***
Comment 3 Rainer Bielefeld 2010-03-08 10:06:13 UTC 
.