AutoComplete interferes with Tab and Enter in the OpenOffice Spreadsheet

AutoComplete interferes with Tab and Enter in the OpenOffice Spreadsheet

When I have a large data-entry task, I like to uses tab to move to the next cell in a row, and enter to move to the beginning of the next row. When I type into a cell and OpenOffice can autocomplete the information in the cell (from the rows above it in the same column), I can hit enter to accept the current completion and move to the next row, but I can't hit tab to accept the current completion and move to the next cell. Is there any way to fix this?

Asked by: Guest | Views: 250

Total answers/comments: 2

Comments display order:

Guest [Entry]

"There's no way to mimic it exactly, but here's a workaround

Edit the keyboard to allow you to set
Ctrl-A to do the same thing as
Ctrl-Backspace.

Ctrl-Backspace navigates to the
current cell and allows you to
continue to use your Tab key for right
movement, and leaving the Enter key to
take you down a row and back to where
you started using the Tab key.

Ctrl-Backspace however isn't an easy
Keyboard short-cut or at least it
isn't for my hands, so I added Ctrl-A
to do the same thing. A is right next
to the Tab key so it's a fairly fast
keyboard click.

Tools>Customize>Keyboard> Under
Functions In Category, select
Navigation Function, select To Current
Cell"

Guest [Entry]

Use the right arrow key instead of tab.