| Summary: | Colorizing cell via Apache POI doesn't work | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Nikita Glukhov <tikani93> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | aron.budea, himajin100000, miguelangelrv, telesto, tikani93 |
| Priority: | medium | ||
| Version: | 7.2.7.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 140202 | ||
| Attachments: | Demo workbook, which illustrates the coloring issue | ||
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. |
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