Bug 157967 - FILESAVE: XLSX: Trend line "decimal places" format does not save
Summary: FILESAVE: XLSX: Trend line "decimal places" format does not save
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Limitations
  Show dependency treegraph
 
Reported: 2023-10-29 14:37 UTC by aidancallumcrawford
Modified: 2023-11-06 19:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Attachment with a trend line equation. The trend line equation decimal places format was not saved. (8.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-10-29 14:37 UTC, aidancallumcrawford
Details

Note You need to log in before you can comment on or make changes to this bug.
Description aidancallumcrawford 2023-10-29 14:37:25 UTC
Created attachment 190493 [details]
Attachment with a trend line equation. The trend line equation decimal places format was not saved.

When creating a trendline in a scatter plot with Libreoffice Calc, adding a trend line and specifying Format Trend Line -> Numbers -> Decimal Places, this formatting is not saved when saving as an XLSX Excel 2007 file. This bug does not occur when saving the file as an ODS file. This bug does not occur when saving using 202X Excel.

Steps to reproduce:
1. Add random data (preferably with lots of decimals) to A1-A3 and B1-B3 in a new Calc file
2. Highlight these 6 rectangles and select insert: Chart. Select scatter plot, and create it as-is.
3. Edit the scatter plot, click on one of the points, and select Insert Trend Line. Select "Show Equation." Create the trend line.
4. Select the trend line equation (right click it and) select Format Trend Line Equation
5. Select Numbers, All, General and specify decimal places: 1
6. Observe that there are fewer decimal places shown in the trend line. Save the file (as an xlsx). Close Libreoffice.
7. Open the xlsx file in Libreoffice Calc (or any spreadsheet viewer). Note that the decimal places format has not been saved.

This issue can be reproduced with the included attachment starting at step 4.
Tested using Windows 11 22H2.
Comment 1 m_a_riosv 2023-10-29 15:39:16 UTC
Confirmed with
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7fff4e2ca6739928f72e5f0d2eb5820823916769
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Opening with Excel, the file saved with LO has no decimal places.
Microsoft® Excel® para Microsoft 365 MSO (versión 2309 compilación 16.0.16827.20166) de 64 bits save and opens fine the decimal places.
File save with Excel, doens't open fine with LibreOffice.