Issue 113664 - Ability to toggle absolute and relative data references in charts
Summary: Ability to toggle absolute and relative data references in charts
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-08-05 04:02 UTC by rsking84
Modified: 2013-09-25 20:41 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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
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.