Hi.
I have the following code used to modify the pattern of a cell:
Workbook wb = cell.getSheet().getWorkbook();
CellStyle errorStyle = wb.createCellStyle();
errorStyle.cloneStyleFrom(cell.getCellStyle());
errorStyle.setFillForegroundColor(Font.COLOR_RED);
errorStyle.setFillPattern(CellStyle.THIN_BACKWARD_DIAG);
cell.setCellStyle(errorStyle);
When I run it, I end up getting these weird looking black cells. Excel 2003
will also not let me directly change the format of the black cells. How
would I format the cells withouth getting this problem?
I am inclosing one of the workbooks. The messed up black cells are on
sheet2.
Thank you in advance for your help.
http://www.nabble.com/file/p24923092/workbook2.xls workbook2.xls
--
View this message in context:
http://www.nabble.com/Weird-cells-appearing-after-modifying-the-format-of-a-cell-tp24923092p24923092.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
