At 14:26 29/10/2009 -0700, Gallomimia wrote:
I have tried the procedure you outlined using the document provided by Ahamed. Prior to being able to change any options such as cell protection, the entire sheet must be Unprotected. This requires no password at first. I'm still not sure if it should, as the document Ahamed provided is .xls and may or may not have a password.
I'm guessing that any such protection would be under the control of a password. And yes: in order for the protection to remain controlled by the password, it would be necessary for this protection removal to require the password.
So the only question which remains for me, is if the program should ask for a password prior to unprotecting the sheet. As has been suggested by others addressing concerns such as this, it may be an issue with MSO2k3 not protecting the document properly in the first place.
No: I've opened it in Excel 2003, and the relevant cells are password-protected as you would expect. And the password is required in order to remove the protection.
Is there any fix for this? It seems like a heavy concern for users of the software.
If you want to use this password protection, I think you need to stick with one product and its native format: either Excel and .xls or Calc and .ods.
Can someone who has access to MSO2k3 and other versions please test whether the password is stripped after the proprietary document format is opened and modified by OOo?
I've reset the password protection in Calc as you describe, resaved as .xls, and then opened the resulting file in Excel 2003. The result is the same as in the other direction: the protection is still in place, but it can be removed without providing any password.
There are some details about this in the help text at "Microsoft Office;importing password protected files".
Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
