Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RE: [discuss] Openoffice Security Issue

0 views
Skip to first unread message

Bruce Martin

unread,
Oct 30, 2009, 8:42:05 AM10/30/09
to
Dear Ahmed:

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

Brucem...@gmail.com

Graham Lauder

unread,
Oct 30, 2009, 10:10:55 AM10/30/09
to
On Thursday 29 October 2009 14:32:52 Ahamed Fasudeen wrote:
> Hi Team,
>
> I'm newly use openoffice...I have some query realted for password security.
>
> Currently i'm using MSoffice2003. In that i have protect the sheet &
> workbook
>
> And i have protect the cell A2:C22(attached sheet) with password range,in
> msoffice2003 once i click
> the A2:C22(cell) it will pop-up password box once i give the password it
> will allow to enter
> the data. And in D2:D22 with out range password user will edit without
> password.
>
> When i use to open the msoffice speared sheet to openoffice... entire
> restriction was removed by calc(openoffice)
>
> i don't why it was happen....with less security in open office.
>
> Could you please provide me the fix for this issue....

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

0 new messages