Bug 159514 - XY Chart legend name and associated Range for name disappears when Calc document is saved and reopened
Summary: XY Chart legend name and associated Range for name disappears when Calc docum...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Legends XY-Scatter-Chart
  Show dependency treegraph
 
Reported: 2024-02-01 23:53 UTC by Marek Bel
Modified: 2024-10-16 05:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Document where problem can be reproduced. (118.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-01 23:55 UTC, Marek Bel
Details
Expected behaviour screenshot (34.26 KB, image/png)
2024-02-01 23:56 UTC, Marek Bel
Details
Actual behaviour screenshot (32.16 KB, image/png)
2024-02-01 23:56 UTC, Marek Bel
Details

Note You need to log in before you can comment on or make changes to this bug.
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.