Issue 109897

Summary:	Chart data ranges not updated when copying the sheet
Product:	Calc	Reporter:	meseer <meseer>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P4	CC:	issues, rainerbielefeld_ooo_qa
Version:	OOo 3.2	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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