Jump to cell XX after Enter

Albireo · Posted: Mon Jun 08, 2009 4:18 am Post subject: Jump to cell XX after Enter

I have tree kolumns
A B C
1 TEXT1 Date1 Date2
2 TEXT2 Date3 Date4

When text & dates are filled in to the different cells,
I want to switch cell horizontally when I press Enter.

for ex.
When the text in cell A1 is completed, press Enter
and the cursor jumps to cell B1.

Is it possible?
How?

//jan

ken johnson · Posted: Mon Jun 08, 2009 4:48 am Post subject:

Go Tools|Options|OpenOffice.org Calc|General...

under "Input settings" change Press Enter to move selection to Right.

Ken Johnson

Villeroy · Posted: Mon Jun 08, 2009 5:42 am Post subject:

Locked cells together with sheet-protection lets you tab from one input cell to the next unlocked input cell (analogue to database forms).
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Albireo · Posted: Mon Jun 08, 2009 6:19 am Post subject:

thanks!
Really good, it works.

_____________________________________

Another thought on this subject

With this tip,
the direction change occurs in the entire worksheet.
(and for me it works)

But
Can You mix the direction of move in the worksheet?
for ex.
Column A B - moving vertically.
Column C - moving horizontally (or jump to next row column A)

//Jan

Villeroy · Posted: Mon Jun 08, 2009 6:39 am Post subject:

No, Calc does not provide that sophisticated capabilities to serve as a replacement for database forms.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Albireo · Posted: Mon Jun 08, 2009 7:28 am Post subject:

Thank You!