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.
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.
Dear aidancallumcrawford, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This bug still affects LibreOffice version 25.2.3.2 (packaged by Debian). The affected OS has been updated to "all" to reflect that it affects multiple platforms.