https://issues.apache.org/bugzilla/show_bug.cgi?id=47570
Tommy Y Li <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Hardware|PC |Macintosh Version|3.5-dev |3.10-dev Resolution|WORKSFORME |--- OS|Mac OS X 10.4 |Mac OS X 10.9 --- Comment #3 from Tommy Y Li <[email protected]> --- (In reply to Dominik Stadler from comment #2) > no response in a long time => resolving for now, please reopen with more > information if this is still an issue I can confirm this issue is still happening and I'm using 3.10-beta2. I've attached a very simple test to verify this issue using Groovy. Basically, test.xlsx is the original spreadsheet with no problems and contains two very simple formulas in cells A1 and A2. testOut.xlsx is the output after running sheet.createRow(0) on test.xlsx. What's expected in testOut.xlsx is the first becomes blank whilst second row still has the formula from cell A2. What actually happens is that an error from Excel saying: "Excel could not open testOut.xlsx because some content is unreadable. Do you want to open and repair this workbook? Selecting open and repair fixes the problem and the "Review Log File" from Excel contains this: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";><logFileName>Repair Result to testOut 03366.xml</logFileName><summary>Errors were detected in file 'Root:Development:tmp:testOut.xlsx'</summary><removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Formula from /xl/calcChain.xml (Calculation properties)</removedRecord></removedRecords></recoveryLog> I also found related posts on previous POI mailing list: http://mail-archives.apache.org/mod_mbox/poi-user/201009.mbox/%[email protected]%3E A reply to this suggested "workbook.onDeleteFormulaCell wasn't being called"... not sure if it's related. http://mail-archives.apache.org/mod_mbox/poi-user/201009.mbox/%[email protected]%3E I also verified that instead of sheet.createRow(0), I do, sheet.removeRow() works and does not produce the error. -- 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]
