Created attachment 174668 [details] Relative sheet name of a data range of chart is not stored When I try to input a relative sheet name in a range of cells of a chart, such as Sheet1.$A$1 (no $ sign in front of "Sheet") instead of $Sheet1.$A$1, the relative name is removed automatically after clicking the OK button. This is frustrating when copying a chart to another sheet when I want the copied sheet to refer to the data range in the new sheet instead of the original sheet. How to reproduce the bug: * Create a new calc document * Input 1 at cell A1 * Click on the chart icon on the toolbar at cell A1. * Click Next * Input a cell range with a relative sheet name such as Sheet1.$A$1 * Click Finish * Double click the chart and right click on the chart selecting data range Expected result: * The chart has the range of Sheet1.$A$1 Actual result: * The chart has the range of $Sheet1.$A$1
Chart is agnostic about its position and relative references and knows only absolute references, be it sheets, columns or rows. It asks Calc to hand over data for a specific cell range.