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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
