Issue 113664

Summary:	Ability to toggle absolute and relative data references in charts
Product:	General	Reporter:	rsking84 <ryanskingsbury>
Component:	chart	Assignee:	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.