Apache OpenOffice (AOO) Bugzilla – Issue 113664
Ability to toggle absolute and relative data references in charts
Last modified: 2013-09-25 20:41:41 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
Whether ranges are given with relative or absolute syntax within charts is completely ignored at the moment. There is a lot to do here.