Bug 155738 - Plot data labels are lost when saving a Calc spreadsheet in xlsx format
Summary: Plot data labels are lost when saving a Calc spreadsheet in xlsx format
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency tree / graph
 
Reported: 2023-06-08 17:33 UTC by nels.anderson
Modified: 2025-06-13 16:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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. (7.55 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-06-08 17:36 UTC, nels.anderson 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.
Comment 3 QA Administrators 2025-06-13 03:11:38 UTC Comment hidden (obsolete)
Comment 4 nels.anderson 2025-06-13 16:45:45 UTC 
I confirm that the bug persists in:

Version: 24.8.7.2 (X86_64) / LibreOffice Community
Build ID: f4f281f562fb585d46b0af5755dfe1eb6adc047f
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: CL threaded