Any open office file can be protected in a number of ways.
1) The entire file can be saved with a password, provided it is saved in
the appropriate Open office native format.
2) Spreadsheets in Calc can also be protected, with selective control; of
what cells are protected and which are not. For each cell, you can have it
either:
a. Unprotected
b. Protected, with formula visible
c. Protected with formula also hidden.
Today I have to go out of town, but later I will try and get a moment to
look at your example and see what is what.
By the way, what time zone are you in? (if not sure, what country?
Best regards,
Bruce Martin
Quebec, Canada
Why is this an OOo security issue that OOo has to fix. If the Excel password
is so easily ignored, then it's an Excel security problem, because Excel
purports to password protect that cell.
This is obviously not the case, if OOo can simply ignore it. That's an Excel
problem, not OOo's.
Get Microsoft to fix the Excel security bug that allows security to be easily
overridden.
Of course some people have found this particular thing quite useful when they
forget the passwords they put in their Excel spreadsheets. :)
Cheers
GL
--
Graham Lauder,
OpenOffice.org MarCon (Marketing Contact) NZ
http://marketing.openoffice.org/contacts.html
INGOTs Moderator New Zealand
www.theingots.org.nz
---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-u...@openoffice.org
For additional commands, e-mail: discus...@openoffice.org