https://bz.apache.org/bugzilla/show_bug.cgi?id=60396
--- Comment #3 from Dominik Stadler <dominik.stad...@gmx.at> ---
I tried to reproduce this with the following test, but LibreOffice does show
both resulting files equally, let's see if it is the same on Excel itself for
me.
@Test
public void bug60396() throws Exception {
writeWithWrappedText(new SXSSFWorkbook(100), "60396s");
writeWithWrappedText(new XSSFWorkbook(), "60396");
}
private void writeWithWrappedText(Workbook wb, String file) throws
Exception {
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);
}
}
OutputStream out = new FileOutputStream("/tmp/" + file + ".xlsx");
try {
wb.write(out);
} finally {
out.close();
}
// also reformat the resulting files to make it easier to compare them
OOXMLPrettyPrint.main(new String[] {
"/tmp/" + file + ".xlsx",
"/tmp/" + file + "-pretty.xlsx"
} );
wb.close();
}
--
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
