Issue 113664

Summary: Ability to toggle absolute and relative data references in charts
Product: General Reporter: rsking84 <ryanskingsbury>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, robert.pollak
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description rsking84 2010-08-05 04:02:36 UTC
When a chart is created in Calc, by default the data ranges selected are given
absolute references.  This means that if you duplicate a sheet or copy a chart
to another sheet, the chart remains linked to the original data.  This behavior
can lead to confusion and creates unnecessary extra work when a user desires to
"mass produce" charts from a common template.

The Chart module should offer the ability to easily toggle the data references
between relative and absolute (perhaps using F4 as in calc cells).  Ideally, the
user would also have an option to set which reference type would be used by
default when creating charts.

For discussion of a bug related to this behavior, see
http://www.openoffice.org/issues/show_bug.cgi?id=29848
Comment 1 IngridvdM 2010-08-05 11:00:37 UTC
Whether ranges are given with relative or absolute syntax within charts is
completely ignored at the moment. There is a lot to do here.