https://issues.apache.org/bugzilla/show_bug.cgi?id=57571
Bug ID: 57571
Summary: Spreadsheet with cell comments cannot be opened Excel
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: SXSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32457
--> https://issues.apache.org/bugzilla/attachment.cgi?id=32457&action=edit
Test to reproduce.
SXSSF output with cell comments cannot be opened in Excel 2013. Excel shows a
dialog "We found some problems...". After Excel attempts to "fix" the doc, it
shows the following message: "Removed Records: Comments from /xl/comments1.xml
part (Comments)"
After this, all comments are gone.
See attached test to reproduce. It' based on POI's own SSPerformanceTest, with
a few modifications (added comments, changed to default packaging, etc).
If you run it as below, the problem should be evident:
... -Dexcel.comments=some SSPerformanceTest SXSSF 10000 6 1
By contrast, XSSF works fine. After running the test with "XSSF" as the first
arg, the resulting spreadsheet is valid.
>From our perspective, it's a blocker since we use comments extensively.
NB: also submitting another bug about comments causing quick OOM in SXSSF
--
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]
