Bug 47737 - Unreadable content opening XSSF generated excel.
Summary: Unreadable content opening XSSF generated excel.
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-08-25 11:50 UTC by Ling Chen
Modified: 2009-09-12 09:03 UTC (History)
0 users


Attachments
Test Harness (17.33 KB, application/x-zip-compressed)
2009-09-10 10:13 UTC, Ling Chen 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ling Chen 2009-08-25 11:50:00 UTC 
I am having issues opening a POI modified .xlsx file. In Windows, it prompts me with an 'unreadable content...' prompt. If clicked yes, I get a repair message 'Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)' message. However, if I open within OpenOffice 3.0, the message doesn't appear.

I did a search on '/xl/calcChain.xml' and found a few discussions. But none is really related.
Comment 1 Yegor Kozlov 2009-08-31 10:14:48 UTC 
Please attach the source file,  sample code that modifies it and the unreadable output. Without this information we can't do much to help you.

Yegor
Comment 2 Ling Chen 2009-09-10 10:13:37 UTC 
Created attachment 24246 [details]
Test Harness

Thanks, Yegor.

Attached is a test harness zip. You'll find the source file called 'test_sample.xlsx'. After running the modified code (testHarness.java), the output file 'result.xlsx' will be corrupted when opening with office 2007.

We are using poi-3.5-beta7 version.
Comment 3 Ling Chen 2009-09-10 10:14:07 UTC 
Thanks, Yegor.

Attached is a test harness zip. You'll find the source file called 'test_sample.xlsx'. After running the modified code (testHarness.java), the output file 'result.xlsx' will be corrupted when opening with office 2007.

We are using poi-3.5-beta7 version.
Comment 4 Yegor Kozlov 2009-09-12 09:03:07 UTC 
Fixed in r814176

Excel wasn't happy to find orphan named references pointing to the deleted sheet.

Regards,
Yegor