https://issues.apache.org/bugzilla/show_bug.cgi?id=51222

             Bug #: 51222
           Summary: XSSFColor.getARGBHex() returns wrong color for Excel
                    2007 xlsx file
           Product: POI
           Version: 3.8-dev
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
        AssignedTo: [email protected]
        ReportedBy: [email protected]
    Classification: Unclassified


Created attachment 27026
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=27026
Java code and sample xls file to extract cell foreground color of Excel 2007
file

I am using poi 3.8 beta 2 to extract the foreground fill color of cells for
Excel 2007 xlsx spreadsheet. I found that the color is wrong for the attached
xlsx file.

Specifically, please look at cells A4 and A5. In Excel 2007, the foreground
color in hex for A4 is EEECE1, and for A5 is 1F497D.

However, through the poi library, the colors are reversed (A4 gets 1F497D and
A5 gets EEECE1).

I am also attaching the java code so that you can reproduce this problem.

Thanks,

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]

Reply via email to