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

Cell Protection

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


Joined: 10 Feb 2006
Posts: 6
Location: Columbus, OH

PostPosted: Mon Feb 13, 2006 3:37 pm    Post subject: Cell Protection Reply with quote

My co-workers and I (tech support) have been using Excel for our call logs. They recently got rid of MS Office in favor of OpenOffice.

In our Excel spreadsheets, we have columns A-I for our call information and then columns J-P to track daily stats of our calls. In Excel, those stat cells were set to protected and we couldn't even select them. For example, when I would get to column I at the end of a call, I could hit the right arrow key and it would put me back at column A of the next row.

Is there a way to do the same thing in Calc?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Mon Feb 13, 2006 4:33 pm    Post subject: Re: Cell Protection Reply with quote

Acros wrote:
My co-workers and I (tech support) have been using Excel for our call logs. They recently got rid of MS Office in favor of OpenOffice.

In our Excel spreadsheets, we have columns A-I for our call information and then columns J-P to track daily stats of our calls. In Excel, those stat cells were set to protected and we couldn't even select them. For example, when I would get to column I at the end of a call, I could hit the right arrow key and it would put me back at column A of the next row.

Is there a way to do the same thing in Calc?


I doubt you can have the same thing due to different keying definitions. There has been much discussion on the cursor moving back to the start, or down a line etc. "like that other program". However, you can avoid moving too far to the right. Simply hide all the columns to the right that you don't want to travel. That is most readily done, if the used portion is small, by selecting the entire sheet by clicking the small rectangle top-left. Then deselect the columns you want to keep [CTRL and SHIFT help there.] Then right-click in any part of the column header [A B C ...] and choose to hide. If all goes well you'll not see the part you don't use, and so end movement there.

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


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Mon Feb 13, 2006 10:30 pm    Post subject: Reply with quote

I don't need to use this myself, but I understand from other threads that if cells are protected, the tab key moves the cell pointer to the next unprotected cell.
Back to top
View user's profile Send private message
Acros
General User
General User


Joined: 10 Feb 2006
Posts: 6
Location: Columbus, OH

PostPosted: Tue Feb 14, 2006 8:00 am    Post subject: Reply with quote

noranthon wrote:
I don't need to use this myself, but I understand from other threads that if cells are protected, the tab key moves the cell pointer to the next unprotected cell.


The tab key works! Now, I just need to get used to using that.

Thanks all!!
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