Good, and thanks for letting me know. There is an additional point to note with styles. As they are shared, if you recover a style from a cell and then change it, that change will be reflected in all of the cells that share the style. This behaviour will be the same if you open a workbook created with Excel just as if you were working with one created through POI. The trick, in this case, is to use the cloneStyleFrom() method of the CellStyle class to create a 'copy' of the style, top modify that copy and apply it to the cell.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/SXSSFWorkbook-with-CellStyle-format-issue-big-file-tp5710422p5710427.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]
