[Libreoffice-bugs] [Bug 126337] New: Charts re-add deleted dollar signs to sheet identifiers in 'Data Ranges'.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126337
           Summary: Charts re-add deleted dollar signs to sheet
                    identifiers in 'Data Ranges'.
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: IA64 (Itanium)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: multipartite at gmail.com

Description:
When I edit the Data Ranges of a certain chart in LibreOffice Calc, its 'Data
Range' is '$template.$F$4:$G$54' and the 'Data Series' entries likewise begin
with '$template".  

Part 1:  If I remove the $ from just the Data Range field, or both the Data
Range and Data Series fields, then when close and reopen Data Ranges the $
signs have returned, though sometimes just one Data Series field doesn't have
it.

Part 2:  If I remove the $ signs from only Data Series, sometimes they stay
gone for a while, but then eventually in a new sheet (copied from the template
sheet) a chart doesn't reflect the data and I find its Data Ranges point to
$template, as do the Data Series fields of the original chart again.

I do not know what the earliest version affected by this is--I've seen this
problem for a while, but had been updating occasionally hoping that a newer
version would fix it.  I have not found this bug in Bugzilla by searching for
'sheet dollar chart', though I have seen this issue mentioned at this URL:
https://ask.libreoffice.org/en/question/74474/can-i-set-a-charts-data-ranges-relative-to-current-sheet/

Steps to Reproduce:
1. Insert a chart in a LibreOffice Calc spreadsheet.
2. In 'Data Ranges' for that chart, remove the $ signs before the sheet name in
the Data Range tab and the Data Series tab.
3. Close and reopen 'Data Ranges' and observe that the deleted $ signs have
been replaced.
4. (Optional:  Copy the sheet and see that the new sheet's chart refers to the
cells in the previous sheet, not the new sheet.)

Actual Results:
Deleted $ signs are replaced as if they had never been deleted.  (If only Data
Series $ signs are deleted, then they stay deleted for a while and are later
replaced with hard-to-predict timing.)

Expected Results:
Deleted $ signs should have stayed deleted forever.  I do not object to either
Data Range or Data Series overriding the other (such as adding or removing $ in
Data Range adding or removing it from all Data Series fields), but I do object
to all fields reverting to having unwanted $ signs.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: CL

-- 
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/20190711/ae52c0fd/attachment.html>