[Libreoffice-bugs] [Bug 144220] New: EDITING: Relative sheet name of a data range of chart is not stored

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144220

            Bug ID: 144220
           Summary: EDITING: Relative sheet name of a data range of chart
                    is not stored
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: snowboard975 at gmail.com

Created attachment 174668
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174668&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210831/a19f3bee/attachment.htm>