Description: After colorizing cells programmatically in existing XLSX workbook with Apache POI 5.2.0, saving changes and opening the workbook in Calc 7.2.7.2 cells are not colorized, but everything is OK in Excel 2007-2019. So, I think there is compatibility issue in the LibreOffice Calc. Steps to Reproduce: 1. Open workbook with Apache POI 5.2.0 2. Call cell colorizing code, e.g. "сellStyle.setFillForegroundColor(IndexedColors.LAVENDER.getIndex()); сellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);" 3. Save changes with Apacha POI API. 4. Open the workbook in Calc. Actual Results: Cells are not colored. Expected Results: Cells are colored successfully, like when file is opened in the MS Excel. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.2.7.2 (x64) / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 16; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL
Please can you attach a sample file.
Created attachment 181498 [details] Demo workbook, which illustrates the coloring issue This workbook was edited with Apache POI 5.2.0, you can find colored headers in sheets starting from the third (first 2 contain pivot tables). If you open it in MS Excel, you will see headers filled with lavender. In Calc these headers rendered in white.
(In reply to m.a.riosv from comment #1) > Please can you attach a sample file. Done.
Reproducible Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 20cc897dddb8ae7cee3c6d66e9cebba9da543c3a CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Opens fine with excel, but even saving it with excel, doesn't work. Changing it in excel, lets LibreOffice opening it fine.
Dear Nikita Glukhov, 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