Bug 50849 - CellUtil.setFont(cell, workbook, font) cleans cell background color in case it's set from theme palette
Summary: CellUtil.setFont(cell, workbook, font) cleans cell background color in case i...
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC Windows XP
: P2 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2011-03-01 11:08 UTC by andrei
Modified: 2017-09-11 19:15 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description andrei 2011-03-01 11:08:07 UTC
Thre reason is that CellUtil class doesn't work with theme colors.
Comment 1 Nick Burch 2011-03-01 17:35:06 UTC
CellUtil ought to work happily with both HSSF and XSSF, and should just be working with common usermodel stuff

Any chance you could figure out what step that it calls internally that breaks it? I suspect we need to change something inside the XSSF code to avoid the issue, rather than in CellUtil, but we ideally need to narrow down what and where!
Comment 2 andrei 2012-05-18 15:12:11 UTC
Nick, method setFormatProperties resets fill color index only, and doesn't set theme index. So cell loses the background.
Comment 3 Dominik Stadler 2017-09-11 19:15:01 UTC
Very long time with no progress and no clear description of how the problem can be reproduced, therefore I am closing this as WONTFIX for now. If this is still an issue for your, then please reopen the bug with more description of how it can be reproduced, ideally with a self-sufficient unit-test that can be added to the test-suite of Apache POI.