| View previous topic :: View next topic |
| Author |
Message |
Acros
General User
Joined: 10 Feb 2006
Posts: 6
Location: Columbus, OH
|
 Posted: Mon Feb 13, 2006 3:37 pm Post subject: Cell Protection |
 |
|
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 |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Mon Feb 13, 2006 4:33 pm Post subject: Re: Cell Protection |
|
|
| 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 |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Mon Feb 13, 2006 10:30 pm Post subject: |
|
|
| 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 |
|
|
Acros
General User
Joined: 10 Feb 2006
Posts: 6
Location: Columbus, OH
|
| Posted: Tue Feb 14, 2006 8:00 am Post subject: |
|
|
| 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 |
|
|
|
