Bug 49966

Summary: Removing formula cell doesn't clear calcChain entry
Product: POI Reporter: Nick Burch <apache>
Component: XSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.7-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

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

Removed records: formula from /xl/calcChain.xml part (calculation properties)
Comment 1 Nick Burch 2010-09-21 07:16:28 UTC
Fixed in r999314, along with unit tests
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.
Comment 3 Yegor Kozlov 2010-11-12 07:05:22 UTC
Fixed in r1034358, junit added