[Bug 47570] Extraneous /xl/calcChain.xml part (Calculation properties) left behind in .xlsx file

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=47570

Tommy Y Li <to...@firefire.co> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
           Hardware|PC                          |Macintosh
            Version|3.5-dev                     |3.10-dev
         Resolution|WORKSFORME                  |---
                 OS|Mac OS X 10.4               |Mac OS X 10.9

--- Comment #3 from Tommy Y Li <to...@firefire.co> ---
(In reply to Dominik Stadler from comment #2)
> no response in a long time => resolving for now, please reopen with more
> information if this is still an issue

I can confirm this issue is still happening and I'm using 3.10-beta2.

I've attached a very simple test to verify this issue using Groovy.

Basically, test.xlsx is the original spreadsheet with no problems and contains
two very simple formulas in cells A1 and A2.  testOut.xlsx is the output after
running sheet.createRow(0) on test.xlsx.

What's expected in testOut.xlsx is the first becomes blank whilst second row
still has the formula from cell A2.

What actually happens is that an error from Excel saying:
"Excel could not open testOut.xlsx because some content is unreadable.  Do you
want to open and repair this workbook?

Selecting open and repair fixes the problem and the "Review Log File" from
Excel contains this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>Repair
Result to testOut 03366.xml</logFileName><summary>Errors were detected in file
'Root:Development:tmp:testOut.xlsx'</summary><removedRecords summary="Following
is a list of removed records:"><removedRecord>Removed Records: Formula from
/xl/calcChain.xml (Calculation
properties)</removedRecord></removedRecords></recoveryLog>

I also found related posts on previous POI mailing list:
http://mail-archives.apache.org/mod_mbox/poi-user/201009.mbox/%3C4C988E0F.3030802@science-computing.de%3E

A reply to this suggested "workbook.onDeleteFormulaCell wasn't being called"...
not sure if it's related.
http://mail-archives.apache.org/mod_mbox/poi-user/201009.mbox/%3Calpine.DEB.1.10.1009211216380.337@urchin.earth.li%3E

I also verified that instead of sheet.createRow(0), I do, sheet.removeRow()
works and does not produce the error.

-- 
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