https://issues.apache.org/bugzilla/show_bug.cgi?id=47570
Summary: Extraneous /xl/calcChain.xml part (Calculation
properties) left behind in .xlsx file
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Use Mac Excel 2008 to create a workbook with a formula.
Run a POI-based program that reads in the workbook, deletes the sheet
containing the formula, creates a new sheet, and writes the result out as a new
workbook.
Mac Excel 2008 opens the new workbook fine, as does NeoOffice and the Finder's
built-in file viewer. However, Excel 2007 on Windows complains of unreadable
content and offers to remove it. It then reports removing the following:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
<logFileName>error005320_01.xml</logFileName>
<summary>Errors were detected in file
'D:\DynSQL\FRx\IO_Data\workbook.xlsx'</summary>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Formula from /xl/calcChain.xml part
(Calculation properties)</removedRecord>
</removedRecords>
</recoveryLog>
after which it successfully opens the file.
If you modify the POI-based program to delete all the content in the sheet to
be deleted before deleting the sheet, the problem still occurs. However, if you
also set all the cell formulas to null, then the problem disappears.
--
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: [email protected]
For additional commands, e-mail: [email protected]
