|Summary:||PatternFormatting.getFillBackgroundColor() returns 0 for conditional formatting with a pattern|
|Product:||POI||Reporter:||Dmitriy Chernyavsky <dmitriyc>|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
|Attachments:||A file that contains conditional formatting in cells A1 and A2|
Description Dmitriy Chernyavsky 2013-08-12 22:09:00 UTC
Created attachment 30725 [details] A file that contains conditional formatting in cells A1 and A2 I use the following formula based conditional formatting: The formula is ISEVEN(ROW()), the applied style is "No font formatting, grey background color with solid fill pattern, auto foreground color". This makes every other row filled with solid grey color when rows are copied. The font settings are kept by default. However, while I tried to read the spreadsheet using Apache POI I noticed that getFillForegroundColor() returns the correct color (64=AUTO) but conditionalFormattingRule.getPatternFormatting().getFillBackgroundColor() returns 0 instead of a valid color (index). I've attached the sample to the bug
Comment 1 Dominik Stadler 2015-09-13 12:29:48 UTC
In the description above you state getFillForeground... and getFillBackground.., Forground/Background! Please note that these are different things in the XLSX, if I look at the values that I get out of getFillForeground... it looks ok both for normal styles and conditional formatting styles, i.e. I get back color 0 for the normal cell style and color 64 for the conditional cell style. Please reopen if this is still a problem for you.