| View previous topic :: View next topic |
| Author |
Message |
JohnChamberlain
Newbie
Joined: 22 Sep 2006
Posts: 1
|
 Posted: Fri Sep 22, 2006 1:30 pm Post subject: tab key not moving to next cell |
 |
|
Normally when I edit a cell I start entering the values desired then hit the Tab key to move to the next cell. I do not want to have to hit enter.
Unfortunately when I hit the tab key during editing nothing happens. It just stays in the current cell.
I have turned off everything I could find in the way of all that automatic helper crap. |
|
| Back to top |
|
 |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Fri Sep 22, 2006 8:17 pm Post subject: |
|
|
It's working on my system. Does the desktop use the TAB key for something else?
It seems that you cannot use Tools >Customise to assign anything to the Tab key.
The arrow keys can be used to navigate to adjoining cells. I've never understood why OO wastes the Tab key on a function served by the right arrow or why, at least, it cannot be modified.
Ah, well. 
_________________
search forum by month |
|
| Back to top |
|
|
dagar
Newbie
Joined: 31 Oct 2006
Posts: 2
|
| Posted: Tue Oct 31, 2006 8:14 am Post subject: have this problem as well |
|
|
I have had this problem as well on different systems.
Here is the scenario:
I am entering something in a cell and then want to go to the cell to the right. Yes, the right arrow will work, IF I am at the end of the text. If I am starting to edit text that is already in a cell, I have to right arrow through the rest of the text till it will go on to the next cell. Tab should be able to go to the next cell no matter what.
Thanks in advance |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Tue Oct 31, 2006 10:27 pm Post subject: |
|
|
That sounds like a bug. You can assign the function to another key (Tab is excluded). The category is "Navigate" and the function is "To next unprotected cell".
_________________
search forum by month |
|
| Back to top |
|
|
PromptJock
Super User
Joined: 26 Jul 2006
Posts: 741
|
| Posted: Wed Nov 01, 2006 5:37 pm Post subject: Re: tab key not moving to next cell |
|
|
| JohnChamberlain wrote: | Normally when I edit a cell I start entering the values desired then hit the Tab key to move to the next cell. I do not want to have to hit enter.
Unfortunately when I hit the tab key during editing nothing happens. It just stays in the current cell.
I have turned off everything I could find in the way of all that automatic helper crap. |
An ostensibly stupid question here: are you sure your "TAB" key is working?
With that typed, see if your "TAB" key works in any other application (i.e. Write). If it does, then there is Indeed Something Amiss between calc and your keyboard. If it doesn't, try another keyboard.
Please don't laugh - I've experienced this many times with SHIFT keys! 
Good luck and Always Think OOo...
_________________
I'm making perfect sense - you're just not keeping up! |
|
| Back to top |
|
|
dagar
Newbie
Joined: 31 Oct 2006
Posts: 2
|
| Posted: Thu Nov 02, 2006 5:58 am Post subject: Odd ver 2.0.4 in Ubuntu Edgy works |
|
|
| Now that I have upgraded to Ubuntu Edgy Eft 6.10 with OO 2.0.4, it seems to work fine. How odd. |
|
| Back to top |
|
|
gwolfBonanza
Power User
Joined: 03 Jun 2006
Posts: 65
|
| Posted: Thu Nov 02, 2006 10:45 am Post subject: |
|
|
I had a similar problem. The solution is to go to Tools->customize and change the keyboard settings. I somehow hosed this on my computer, and this was the only solution.
However, once I discovered it, it can do some really cool things!
_________________
Regards,
George |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Nov 02, 2006 3:43 pm Post subject: |
|
|
When you type into one or more highlighted ranges the tab-key navigates through the highlighted cells only.
Ctrl-Click or Shift+Right,Shift+Left selects a single cell as input-range.
The same occurs if the active cell is the only unlocked cell in a protected sheet.
This is the only way I can reproduce the odd behavior.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
gwolfBonanza
Power User
Joined: 03 Jun 2006
Posts: 65
|
| Posted: Fri Nov 03, 2006 2:58 pm Post subject: |
|
|
Cool! I didn't know that! (yeah - RTFM, but it's a BIG manual!)
_________________
Regards,
George |
|
| Back to top |
|
|
|
