Bug 159514

Summary: XY Chart legend name and associated Range for name disappears when Calc document is saved and reopened
Product: LibreOffice Reporter: Marek Bel <marek.bel>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: mhillat, stephane.guillou
Priority: medium    
Version: 6.0.0.3 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=73515
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108543    
Attachments: Document where problem can be reproduced.
Expected behaviour screenshot
Actual behaviour screenshot

Description Marek Bel 2024-02-01 23:53:31 UTC
Description:
XY Chart legend name and associated Range for name disappears when Calc document is saved and reopened

Steps to Reproduce:
1.Open attached document Some_generic_data.ods
2.Open sheet "Sorted"
3.Double click any chart, e.g. top left called 210 measurements
4.Right click it.
5.Select Data Ranges...
6.Select Data Series tab.
7.Select currently unnamed series called Series (not score)
8.Select Name
9.Click button next to range for name.
10.Select cell E57
11.Click ok
12.Now chart legend next to red dot displays "inverse score weighted avg x from 50 best samples"
13.Save the document.
14.Close LibreOffice Calc.
15.Open saved document Some_generic_data.ods by double tapping it in Windows explorer.

Actual Results:
There is no legend for second (red) series. see attached Actual.png

Expected Results:
There is legend for second (red) series "inverse score weighted avg x from 50 best samples". see attached Expected.png


Reproducible: Always


User Profile Reset: No

Additional Info:
Even before saving the file, if the Data Series... menu is recalled again after being closed Range for Name of Series being edited is already empty. Even though previously selected label for series is still correctly displayed on chart legend.
The same problem can be reproduced in this document for Chart "First 187 measurements" when I66 is selected for range for name.
The same problem can be reproduced in this document for Chart "Best 50 samples in 210 measurements" when E57 is selected for range for name.
The same problem can be reproduced in this document for Chart "Best 50 samples in 187 measurements" when I66 is selected for range for name.
Comment 1 Marek Bel 2024-02-01 23:55:44 UTC
Created attachment 192329 [details]
Document where problem can be reproduced.
Comment 2 Marek Bel 2024-02-01 23:56:24 UTC
Created attachment 192330 [details]
Expected behaviour screenshot
Comment 3 Marek Bel 2024-02-01 23:56:59 UTC
Created attachment 192331 [details]
Actual behaviour screenshot
Comment 4 Stéphane Guillou (stragu) 2024-02-02 07:37:19 UTC
Thank you for the report.

Reproduced in:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2cac2ee38445c19c9281f54c2b961bbc9149cc00
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and:

Version: 6.0.0.3
Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk2; 
Locale: en-AU (en_AU.UTF-8); Calc: group

Interesting thing I noticed was that editing the same chart in OOo 3.3 the data table, not the data ranges.

Sounds similar to bug 73515.