Issue 14215 - Sheets with saved with Protect Workbook Structure in Excel XP cannot be opened
Summary: Sheets with saved with Protect Workbook Structure in Excel XP cannot be opened
Status: CLOSED DUPLICATE of issue 402
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-07 21:13 UTC by linuxkrn
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description linuxkrn 2003-05-07 21:13:22 UTC 
Sheets saved with Protect Workbook Structure (Excel XP) cannot be opened.  

Error message:
Error loading document file:///C:/test.xls:
Read-Error.
This file is password-protected..

After clicking OK it will not open.  However, in excel the file can be opened
without a password.

How to reproduce:
Open Excel XP new sheet
Tools/Protection/Protect Workbook...
Select 'Structure' and enter password
Confirm and save
Attempt to open in OO.

Tested version
1.0.3.1
1.1 Beta
644m11
Comment 1 frank 2003-05-08 11:03:11 UTC 
Hi,

this is not a bug.

Microsoft Excel uses a default password to encrypt the file if protect
workbook structure is set. As Microsoft is not willing to share the
algorithm with the world, we can't open such documents.

See also Issue 402 and Issue 5362.

Best regards

Frank

*** This issue has been marked as a duplicate of 402 ***
Comment 2 frank 2003-05-08 11:03:27 UTC 
closed double