Issue 14215

Summary:	Sheets with saved with Protect Workbook Structure in Excel XP cannot be opened
Product:	Calc	Reporter:	linuxkrn <gwatson>
Component:	code	Assignee:	oc
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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