Apache OpenOffice (AOO) Bugzilla – Issue 20023
Protected workbook from Excel doesn't open read-only
Last modified: 2003-09-25 15:27:18 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.
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 ***
closed double
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
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