You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2010/09/21 13:04:26 UTC
DO NOT REPLY [Bug 49966] New: Removing formula cell doesn't clear
calcChain entry
https://issues.apache.org/bugzilla/show_bug.cgi?id=49966
Summary: Removing formula cell doesn't clear calcChain entry
Product: POI
Version: 3.7-dev
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: nick.burch@alfresco.com
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)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 49966] Removing formula cell doesn't clear
calcChain entry
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49966
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #1 from Nick Burch <ni...@alfresco.com> 2010-09-21 07:16:28 EDT ---
Fixed in r999314, along with unit tests
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 49966] Removing formula cell doesn't clear
calcChain entry
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49966
m44rt3n@yahoo.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |
--- Comment #2 from m44rt3n@yahoo.com 2010-11-08 06:03:00 EST ---
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 49966] Removing formula cell doesn't clear
calcChain entry
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49966
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |FIXED
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2010-11-12 07:05:22 EST ---
Fixed in r1034358, junit added
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org