Bug 49966 - Removing formula cell doesn't clear calcChain entry
Summary: Removing formula cell doesn't clear calcChain entry
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.7-dev
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-09-21 07:04 UTC by Nick Burch
Modified: 2010-11-12 07:05 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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