Bug 155738

Summary:	Plot data labels are lost when saving a Calc spreadsheet in xlsx format
Product:	LibreOffice	Reporter:	nels.anderson
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	adamseskunas, buzea.bogdan
Priority:	medium
Version:	7.5.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108542
Attachments:	Created in Calc, the points on the plot in this spreadsheet were labeled. But when the sheet is reopened, the labels have been replaced by numbers.

Description nels.anderson 2023-06-08 17:33:21 UTC

Description:
I create an xy-plot in Calc and label the points by specifying data labels in the Data Ranges dialogue box.  So far, so good.  Then I save the spreadsheet in xlsx and close Calc.  When I reopen the spreadsheet, the data labels I specified have vanished, and the points in the plot are labeled with numbers.

This bug has existed for years, across many versions of Calc, different versions of Ubuntu Linux (w

Steps to Reproduce:
1. Open or create a Calc spreadsheet and create an xy-plot (other plot types may have the problem too).
2. Right-click on the data series and choose "Data Ranges..."; specify a range of non-blank cells as Data labels.  Click "OK".
3. Right-click on the data series again, and choose "Format Data Labels..."; under "Text Attributes" ensure that only "Category" is checked; click "OK".
4. Observe that points are now labeled.
5. Save the spreadsheet in xlsx format and close Calc.
6. Reopen the spreadsheet.

Actual Results:
Labels by data points have been replaced by numbers.

Expected Results:
Labels as they appeared before the spreadsheet was saved and closed.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 67bf5ab3e8553b11738d1302ab7051a12dd8b40d
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-GB (en_US.UTF-8); UI: en-US
Calc: threaded

Comment 1 nels.anderson 2023-06-08 17:36:50 UTC

Created attachment 187789 [details]
Created in Calc, the points on the plot in this spreadsheet were labeled.  But when the sheet is reopened, the labels have been replaced by numbers.

Comment 2 Adam664 2023-06-12 18:40:30 UTC

Thanks for reporting the bug. I can confirm the bug is present in the versions listed below. The bug does not exist if the file is saved in ods format.

Version: 7.5.2.2 (X86_64)
Build ID: 50(Build:2)
CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 7.7.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5a2c6f4df7149f8c1f543f120fe19bd66abfc189
CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Setting status to NEW.