Bug 150199 - Colorizing cell via Apache POI doesn't work
Summary: Colorizing cell via Apache POI doesn't work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: MSO-External-Producers
  Show dependency tree / graph
 
Reported: 2022-07-30 10:01 UTC by Nikita Glukhov
Modified: 2023-03-29 17:59 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
Demo workbook, which illustrates the coloring issue (31.41 KB, application/octet-stream)
2022-07-30 11:42 UTC, Nikita Glukhov 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Nikita Glukhov 2022-07-30 10:01:21 UTC 
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
Comment 1 m_a_riosv 2022-07-30 10:22:27 UTC 
Please can you attach a sample file.
Comment 2 Nikita Glukhov 2022-07-30 11:42:25 UTC 
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.
Comment 3 Nikita Glukhov 2022-07-30 11:43:37 UTC 
(In reply to m.a.riosv from comment #1)
> Please can you attach a sample file.

Done.
Comment 4 m_a_riosv 2022-07-31 01:22:29 UTC 
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.