Bug 52538

Summary: xls file causes Protected View error in Excel
Product: POI Reporter: David Roe <d.roe>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.8-dev   
Target Milestone: ---   
Hardware: PC   
OS: All   
Bug Depends on: 52337, 52385    
Bug Blocks:    
Attachments: Minimal test file

Description David Roe 2012-01-26 15:39:25 UTC
Created attachment 28214 [details]
Minimal test file

I have a spreadsheet that opens in Excel fine. If I open it in POI and save it again, the resulting file causes the error "Protected View - Office has detected a problem with this file..." when opened in Excel 2010.

It works in POI 3.8 BETA 4 but not in BETA 5. I have bisected SVN and I think r1187640 "rewrite VariantSupport to use TypedPropertyValue at max without breaking compatibility" is the revision when it started doing this.

Attached is a minimal test file that exhibits the problem.
Comment 1 Yegor Kozlov 2012-01-26 16:24:48 UTC
We know about this regression and working on the fix. See Bug 52385 and Bug 52337.

I linked this bug report to Bugs 52385 and 52337, they all will be resolved in one go.

Yegor
Comment 2 Yegor Kozlov 2012-02-15 07:54:39 UTC
Should be fixed in r1244388

Regards,
Yegor