OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Sheet protection

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
aurel
Newbie
Newbie


Joined: 26 Oct 2006
Posts: 1

PostPosted: Thu Oct 26, 2006 4:12 am    Post subject: Sheet protection Reply with quote

Do you know if that's possible to lock only few cells of a sheet and not the entire sheet?
Thanks.
Back to top
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Thu Oct 26, 2006 5:10 am    Post subject: Reply with quote

Yes:
use different styles for un- and protected cells, then protect the sheet.
Does this help?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
Back to top
View user's profile Send private message Visit poster's website
dranix2679
Newbie
Newbie


Joined: 26 Oct 2006
Posts: 4

PostPosted: Thu Oct 26, 2006 5:20 am    Post subject: interesting answer Reply with quote

Probe1, it's an interesting answer. is there any help file as to how to accomplish this process. I do not understand what you mean by using different styles. Please help. Thanks.
Back to top
View user's profile Send private message
dranix2679
Newbie
Newbie


Joined: 26 Oct 2006
Posts: 4

PostPosted: Thu Oct 26, 2006 5:41 am    Post subject: understand Reply with quote

Probe1. i have managed to figure out what you meant by playing around with the "styles" to enable the cell protection.
Thanks.
But in Excel there is a feature where we can....
Protect the whole worksheet with "passwordA" but having a few selectable cells being protected for editing by "passwordB"...
Meaning to say.... basically the whole worksheet is protected, because i do not want the user to do anything with the worksheet.... but just to enter their values into a few selecteable cells....
Is this scenario possible in OO?
Please Help
Thanks.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Oct 26, 2006 10:13 am    Post subject: Reply with quote

My understanding of cell protection, which I think is similar for Calc and Excel:

All cells have protection by default. Think of this as each cell having a lock.

You can change a cell to be unprotected. Think of this as removing the lock.

Overall protection is off by default. Think of this as all the locks unlocked.

If you switch protection on, all protected cells will be locked. Think of this as all the locks being locked. Any unprotected cell will not be locked, because it doesn't have a lock.

So all this means you need to:

1. Select which cells you want to be unlocked.
2. Format these to be unprotected.
3. Turn protection on, either for the whole file, or just that sheet.

Excel can use a password to unprotect. This is not a secure protection, because Calc simply by-passes the password.

(Edited to correct a typo, because I'm picky.)


Last edited by RickRandom on Fri Oct 27, 2006 10:49 pm; edited 1 time in total
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Oct 26, 2006 10:14 am    Post subject: Re: Sheet protection Reply with quote

Select the entire sheet [upper left rectangle] and unlock the cells. Then select the few cells you need and lock them. When you protect the sheet you'll have what you need.

David.
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Fri Oct 27, 2006 12:54 am    Post subject: Reply with quote

I think the default setting is unhelpful. Use the F11 dialogue. Right-click on "Default" and select "Modify". Un-select everything on the "Cell Protection" tab.

Now you can create a "_CellProt" style and apply it to the small minority of cells that need protection.
_________________
search forum by month
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Oct 27, 2006 6:04 am    Post subject: Reply with quote

RickRandom wrote:

1. Select which cells you want to be unlocked.
2. Format these to be unprotected.
3. Turn protection on, either for the whole file, or just that sheet.


One of us has to set our watch. Smile

David.
Back to top
View user's profile Send private message
dranix2679
Newbie
Newbie


Joined: 26 Oct 2006
Posts: 4

PostPosted: Fri Oct 27, 2006 7:37 am    Post subject: well explained Reply with quote

RickRandom wrote:
My understanding of cell protection, which I think is simular for Calc and Excel:

All cells have protection by default. Think of this as each cell having a lock.

You can change a cell to be unprotected. Think of this as removing the lock.

Overall protection is off by default. Think of this as all the locks unlocked.

If you switch protection on, all protected cells will be locked. Think of this as all the locks being locked. Any unprotected cell will not be locked, because it doesn't have a lock.

So all this means you need to:

1. Select which cells you want to be unlocked.
2. Format these to be unprotected.
3. Turn protection on, either for the whole file, or just that sheet.

Excel can use a password to unprotect. This is not a secure protection, because Calc simply by-passes the password.


Hi Rick.... thanks for your detailed explaination.... it was helpful..... but what happens if i need 2 layers of protection.... as in i have the sheets kind of protected twice...
1st layer is just for users to type in some values in to some cells.....
2nd layer is for the whole sheet so it will restrict the users to do anything else to any other cells except the ones allocated to them.....
i found excel can do this...
it has a cell protection feature...
and it has a overall sheet protection feature....
each feature can be protected by different password....
that's what make it possible... so users can just enter a simple password to access the 1st layer.... but however... will not be given access to do anything else to the sheet cos they don't know the password to the 2nd layer....

please advice if this is possible with Calc
Thanks.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Fri Oct 27, 2006 9:32 am    Post subject: Reply with quote

Oh no, the question seems to be aimed at me!

I can only suggest you have a play (not with your important spreadsheet). I think you've exhausted my knowledge on this subject. Embarassed
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Fri Oct 27, 2006 5:19 pm    Post subject: Reply with quote

There is only one layer.

Some cells are protected, some not. The cell protection is enabled / enforced / activated by protecting the sheet. The protection of cells has no effect unless the sheet is protected.

The users can still edit the unprotected cells.

The most efficient way of achieving that is to use a separate cell style for your protected / unprotected cells.
_________________
search forum by month
Back to top
View user's profile Send private message
dranix2679
Newbie
Newbie


Joined: 26 Oct 2006
Posts: 4

PostPosted: Fri Oct 27, 2006 8:35 pm    Post subject: thanks Reply with quote

RickRandom wrote:
Oh no, the question seems to be aimed at me!

I can only suggest you have a play (not with your important spreadsheet). I think you've exhausted my knowledge on this subject. Embarassed


Sorry... didn't mean to aim the question at you.... you seemed to know more about this.. so i thought you're the best person to ask.....
but yeah.... thanks for your help... i think the scenario i painted might be unaccomplished by using Calc...
Thanks.
Back to top
View user's profile Send private message
JadenGuy
Newbie
Newbie


Joined: 30 Nov 2005
Posts: 4

PostPosted: Mon Nov 06, 2006 10:23 pm    Post subject: Reply with quote

if you protect the document, it is uneditable without the master password. so you protect the sheet to protect the cells, and you protect the document to protect any edits.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group