https://issues.apache.org/bugzilla/show_bug.cgi?id=55406
Bug ID: 55406
Summary: PatternFormatting.getFillBackgroundColor() returns 0
for conditional formatting with a pattern
Product: POI
Version: 3.9
Hardware: Other
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 30725
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30725&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
