Issue 7223 - Password protected sheets/document loose their passwords after exporting to SO5.2, 4.0, 3.0
Summary: Password protected sheets/document loose their passwords after exporting to S...
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 98
: P1 (highest) Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords: oooqa
: 7224 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-08-24 15:13 UTC by ismax
Modified: 2003-09-08 16:55 UTC (History)
2 users (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 ismax 2002-08-24 15:13:06 UTC 
Protected sheets or document with a password will loose the pasword when you save the document in previous StarOffice formats. The 
passwords are removed so the user can unprotect the sheets. This happens with protected sheets and with protected documents. 
OpenOffice 1.0.0 also exhibits this behaviour.

   How to reproduce the problem:

- Create an empty spreadsheet and protect one or more sheets. Enter a password.
- Save the document as a StarCalc 5.0, 4.0, 3.0
- Open the saved document. Unprotect the sheet/s previously protected --> No password needed !!!

- Instead protecting a sheet, protect the document. The same behaviour occurs.

Isma.
Comment 1 prgmgr 2002-08-25 04:11:39 UTC 
Thanks for posting this issue Ismael.

Duplicated on Win NT 4.0 SP6a, OO 1.0.1.

Does the older version of StarOffice support the password protection 
features offered in OO 1.0.1?

Unfortunately I don't have copies of the older versions of StarOffice.
Comment 2 ismax 2002-08-25 04:50:50 UTC 
Yes, StarOffice 5.x has this capabilities.

To clarify:

StarOffice 5.x --> OOo  * Password protection works as expected
OOo --> StarOffice 5.x  * Password lost, protection still works

Isma.
Comment 3 prgmgr 2002-08-25 16:56:40 UTC 
*** Issue 7224 has been marked as a duplicate of this issue. ***
Comment 4 frank 2002-08-26 09:32:19 UTC 
Hi Falko,

one Issue that needs some clarrification from you.

Frank
Comment 5 prgmgr 2002-08-27 04:16:54 UTC 
I just want to add a comment about 7224.

I marked it as a duplicate of this issue because it's a password 
related issue.

Please note that issue 7224 deals with password protecting Writer 
documents, not Calc worksheets.
Comment 6 falko.tesch 2003-01-13 16:02:46 UTC 
Well, this seems a bug to me. We need to fix this IMHO.
Comment 7 niklas.nebel 2003-01-13 16:43:26 UTC 
The mechanism for sheet or document protection passwords was changed
between the 5.0 and 6.0 (OOo 1.0) file formats. Therefore we cannot
save a file to 5.0 format with the passwords. 5.0 and earlier formats
are treated like other alien formats which don't contain all
information (for example, MS Excel format).
Note that this is different from saving a file with a password.
Comment 8 niklas.nebel 2003-01-13 16:44:07 UTC 
closing the issue.
Comment 9 ismax 2003-01-14 11:51:12 UTC 
> ... we cannot save a file to 5.0 format with the passwords.

   :(   I think it will be a good idea to say this somewhere in
the documentation, readme or release notes because this breaks
the security of the documents without warning the user, wich
believes that the document or the sheets will be protected as
before but in fact, it will not and everybody will have access to
previously protected sheets.

> ... 5.0 and earlier formats are treated like other alien formats

   I'm sorry, but this is a very bad thing IMHO. :((

One thing is not being able to export new features to older formats
and another is not being able to restore the same features we can
import from our older file formats.

With regards, Isma.