https://bugs.documentfoundation.org/show_bug.cgi?id=155738
Bug ID: 155738
Summary: Plot data labels are lost when saving a Calc
spreadsheet in xlsx format.
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
