https://bugs.documentfoundation.org/show_bug.cgi?id=150199
Bug ID: 150199
Summary: Colorizing cell via Apache POI doesn't work
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.