Bug 52538 - xls file causes Protected View error in Excel
Summary: xls file causes Protected View error in Excel
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on: 52337 52385
  Show dependency tree
Reported: 2012-01-26 15:39 UTC by David Roe
Modified: 2012-02-15 07:54 UTC (History)
0 users

Minimal test file (25.50 KB, application/vnd.ms-excel)
2012-01-26 15:39 UTC, David Roe

Note You need to log in before you can comment on or make changes to this bug.
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.

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