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 treegraph
 
Reported: 2022-07-30 10:01 UTC by Nikita Glukhov
Modified: 2025-03-29 03:12 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

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.
Comment 5 QA Administrators 2025-03-29 03:12:06 UTC
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