|Summary:||Removing formula cell doesn't clear calcChain entry|
|Product:||POI||Reporter:||Nick Burch <apache>|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
Description Nick Burch 2010-09-21 07:04:23 UTC
As reported on the mailing list: Given a .xlsx file containing a formula cell. This cell should be cleared and then the workbook is saved to a new .xlsx file, When I open the new .xlsx file with Microsoft Excel 2007 I get an error message: Removed records: formula from /xl/calcChain.xml part (calculation properties)
Comment 2 m44rt3n 2010-11-08 06:03:00 UTC
The same issue still exists when executing XSSFSheet.html#removeRow According to the doc: All cells contained in the row are removed as well However, the calcChain entries are not deleted for each cell resulting in the issue described. Workaround is to manually remove all cells of the row before removing the row.