Bug 47737

Summary:	Unreadable content opening XSSF generated excel.
Product:	POI	Reporter:	Ling Chen <lingjiao.chen>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	critical
Priority:	P2
Version:	3.5-dev
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Attachments:	Test Harness

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