poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 56683] New: SXSSF generated corrupted report in z/OS on applying cell Style
Date Mon, 30 Jun 2014 11:47:02 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=56683

            Bug ID: 56683
           Summary: SXSSF generated corrupted report in z/OS on applying
                    cell Style
           Product: POI
           Version: 3.10
          Hardware: Other
                OS: other
            Status: NEW
          Severity: major
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: ranju4u6@gmail.com

I am trying to execute a program in z/OS machine to write an Excel report. Due
to size of the report, we are using SXSSFWorkbook to write the report.

One of the cells in the report is grey in color. So I have to apply Color to
that cell. I used the following code to set the color.

XSSFCellStyle cellStyle = (XSSFCellStyle) wb.createCellStyle();
XSSFColor myColor = new XSSFColor(DatatypeConverter
        .parseHexBinary("FFBFBFBF")); //also tried the java.awt.Color
cellStyle.setFillForegroundColor(myColor);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cell.setCellStyle(cellStyle);

But for the report generated, this cell is dark in color. Out of curiosity, I
checked the Styles.xml inside the Excel document. The following is what I
found.

<fill><patternFill patternType="solid"><fgColor
rgb="ããâãâãâã"/></patternFill></fill>
I tried to generate the same report in a Windows machine, and it gave me
correct result.

<fill><patternFill patternType="solid"><fgColor rgb="FFBFBFBF"/></patternFill>

-- 
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


Mime
View raw message