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
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.
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.