https://bz.apache.org/bugzilla/show_bug.cgi?id=65464
--- Comment #10 from Nico Seegert <[email protected]> --- Hello PJ Fanning, as you said, the created Excel File is still corrupt upon opening but can be repaired now. However, the following code fix in XSSFSheet should create a non-corrupt Excel (at least when I tested it locally) without the need to be repaired: Replace ``` nextF.setT(STCellFormulaType.SHARED); //https://bz.apache.org/bugzilla/show_bug.cgi?id=65464 ``` by ``` nextF.setT(STCellFormulaType.SHARED); //https://bz.apache.org/bugzilla/show_bug.cgi?id=65464 if (!nextF.isSetSi()) { nextF.setSi(f.getSi()); } ``` I do not know whether the if-check is necessary, as I do not know the code base too well. However, the addition above created non-corrupt Excel files for us. It would be great if this fix (or similar) can be added to 5.0.1. - is a new bug ticket needed? Best regards, Nico -- 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]
