[Bug 55406] New: PatternFormatting.getFillBackgroundColor() returns 0 for conditional formatting with a pattern

[bu...@apache.org]

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: dev@poi.apache.org
          Reporter: dmitriyc@google.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org