Issue 20023 - Protected workbook from Excel doesn't open read-only
Summary: Protected workbook from Excel doesn't open read-only
Status: CLOSED DUPLICATE of issue 402
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-25 07:27 UTC by udippel
Modified: 2003-09-25 15:27 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 udippel 2003-09-25 07:27:09 UTC 
Says it. To me a complete show-stopper: Open Office doesn't open a protected
workbook that we used to get mailed.
Details: In Excel2000 I can open the document; under Protection I see that the
workbook is protected, A real password is needed to unprotect the sheet. But: I
can read it.
In OpenOffice 1.1 RC4  it takes some time, then the title bar comes up with
'.....read-only' but then the white cross comes up: Error loading document -
Read Error - This file is password-protected - OK
It is. Yes. But since everyone else can read it in Excel, they won't bother to
unprotect it for me. Which would be wrong in any case. I am only supposed to
read it.

I'd add the file if it wasn't too much of 'secret' stuff included.
I did try to save it again in Excel under a different name, without success.

To me it's a show-stopper and if this cannot be resolved, I'll have to go back
to Windoze for such stuff after almost 3 years on Linux !
For someone else it might simply be an enhancement.
Comment 1 frank 2003-09-25 08:57:43 UTC 
Hi Uwe,

what's about using find an Issue with Spreadsheet as component and
password as keyword for the summary field ? This will lead you to
Issue 402.

Frank

*** This issue has been marked as a duplicate of 402 ***
Comment 2 frank 2003-09-25 08:58:08 UTC 
closed double
Comment 3 udippel 2003-09-25 14:50:24 UTC 
Don't want to reopen. But maybe you can confirm that the issue 402 was
at least slightly different: The reporter wanted to open the protected
file using the password. I do agree that this is difficult. 
My case, if read precisely, is different: I don't know the password,
but would like to see the same content as seen in Excel *without*
password.

You agree, this is slightly different, don't you ? 
I, OTOH, agree that the explanation 'encrypted' means something as
well. With a bit of basic logic, that implies that Micro$oft uses two
steps:
1. Encryption of the whole file without password
2. Access control to parts of the file using a password

Aha, learned something, which is not necessarily the case.

One day they encrypt *all* files (without password, simply at 'Save')
and we're bust. Right !?

Thanks for a daily dosis of enlightenment !

Uwe
Comment 4 frank 2003-09-25 15:27:18 UTC 
Hi Uwe,

Excel does an encryption on an part of the file even if you have only
selected the protect sheet function with a password making it
impossible for us to open the document without getting trouble with
the lawyeres. So we can't open the whole file. That's the way
Microsoft works.

Sorry for no better reply.

Frank