https://bz.apache.org/bugzilla/show_bug.cgi?id=60396
Marc <m...@schregardus.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from Marc <m...@schregardus.com.au> --- In my production code, the styles are cached and I still get the same issue. To demonstrate, I've amended the code below to create the style outside the loop (so only 1 style is created), and there is still the problem with wrapping for the streamed version of the renderer. SXSSFWorkbook wb = new SXSSFWorkbook(100); // XSSFWorkbook wb = new XSSFWorkbook(); CellStyle cellStyle = wb.createCellStyle(); cellStyle.setWrapText(true); Sheet sh = wb.createSheet(); for(int rownum = 0; rownum < 1000; rownum++){ Row row = sh.createRow(rownum); for(int cellnum = 0; cellnum < 10; cellnum++) { Cell cell = row.createCell(cellnum); String address = new CellReference(cell).formatAsString(); address += "\ntest"; row.setHeightInPoints((2*sh.getDefaultRowHeightInPoints())); cell.setCellStyle(cellStyle); cell.setCellValue(address); } } If you switch to the XSSFWorkbook (commented out), then the spreadsheet is rendered correctly -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org