Bug 49966

Summary:	Removing formula cell doesn't clear calcChain entry
Product:	POI	Reporter:	Nick Burch <apache>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
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
message:

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

Yegor