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

Tabbing cells in Calc

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


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 10:52 am    Post subject: Tabbing cells in Calc Reply with quote

I am new to calc and have noticed when finishing typing in a cell and hitting "enter" it drops to the cell directly underneath the one you were just in. In excel it use to go to the first cell on the next line. Is there anyway to setup Calc to automatically have the cursor go to the first cell in the next row.

Thanks, Ozier
Back to top
View user's profile Send private message
Warrick Nelson
OOo Advocate
OOo Advocate


Joined: 04 May 2004
Posts: 203
Location: Christchurch, New Zealand

PostPosted: Wed Oct 18, 2006 11:08 am    Post subject: Reply with quote

Under Tools/Options/Calc/General
Pressing Enter can be changed to do nothing, or move to the next cell up/down/left/right.
Back to top
View user's profile Send private message Visit poster's website
nozier
General User
General User


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 11:22 am    Post subject: Reply with quote

I did find that but I was wondering if instead of just moving it directly down a cell if it could move it down and to the first cell in that row like excel does by default. Any ideas?
Back to top
View user's profile Send private message
nozier
General User
General User


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 11:37 am    Post subject: Reply with quote

Interesting, I will give that a try. Thank you for your quick assistance!
Back to top
View user's profile Send private message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Wed Oct 18, 2006 11:43 am    Post subject: Reply with quote

nozier wrote:
I did find that but I was wondering if instead of just moving it directly down a cell if it could move it down and to the first cell in that row like excel does by default. Any ideas?


Not having Excel on my PC, could you explain this to me.
"move it down and to the first cell in that row like excel does by default"

Does this mean that if I'm in cell AZ256 and press the "tab" key, that Excel would move me to cell A257? How is that a desirable behaviour?
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
BillP
Super User
Super User


Joined: 07 Jan 2006
Posts: 2703

PostPosted: Wed Oct 18, 2006 11:48 am    Post subject: Reply with quote

You have to select a range of cells in Calc to get the behavior you describe. Pressing Enter when in the last column of the range will move to the first cell of the next row (assuming Enter has been set to "move right" in instead of "move down"). I think this is also true in Excel. I don't see any need to move down and to the first cell unless a range is selected.
Back to top
View user's profile Send private message
nozier
General User
General User


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 11:49 am    Post subject: Reply with quote

If you are in cell D1 and you hit "enter" the cursor drops down to the cell directly underneath it (in this case D2).

What I am asking: If after hitting "enter" on cell D1 the cursor would drop down to the A2 cell.
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Oct 18, 2006 11:51 am    Post subject: Reply with quote

nozier,

I'm not sure whether you saw my 1st post that looked like the one below as I didn't care for it and deleted the same. This one is more appropriate.

There is no direct way to get this movement for the Enter key.

You can record a macro of pressing the down arrow and the Home key then save the macro in the My Marcos > Standard library. From a Calc file do Tools > Customize > Keyboard tab and assign this macro to the Enter key. The bullet at the top of this dialog should be in Calc!
Back to top
View user's profile Send private message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Wed Oct 18, 2006 11:58 am    Post subject: Reply with quote

nozier wrote:
If you are in cell D1 and you hit "enter" the cursor drops down to the cell directly underneath it (in this case D2).

What I am asking: If after hitting "enter" on cell D1 the cursor would drop down to the A2 cell.


I'm genuinely interested to know why one would want that to be the default behaviour. What is the advantage in having the cursor jump potentially dozens of the columns to the left whenever one hits "Enter"?
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
nozier
General User
General User


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 11:59 am    Post subject: Reply with quote

Creating a macro and saving it to the enter key fixed the problem. Thanks!
Back to top
View user's profile Send private message
BillP
Super User
Super User


Joined: 07 Jan 2006
Posts: 2703

PostPosted: Wed Oct 18, 2006 12:21 pm    Post subject: Reply with quote

How did you get Excel to do this by default? Default in Excel 97 is to move down. I can change it to move up, left or right. I can't find any option to move down and to the first cell in the row.
Back to top
View user's profile Send private message
nozier
General User
General User


Joined: 18 Oct 2006
Posts: 20

PostPosted: Wed Oct 18, 2006 12:36 pm    Post subject: Reply with quote

I am sorry that I didn't make this clearer, maybe this will help. To get this to happen in excel you can hit the tab button a couple of times, after doing this you can hit "enter" and it will take you to the first cell in the next row. If you just select a cell in excel and hit enter it will drop directly down like calc does. So my revised question would be after tabbing in Calc, how to get the cursor to drop down to the first cell in the next row.
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Wed Oct 18, 2006 12:44 pm    Post subject: Reply with quote

Press Home, then down arrow?

OK, 2 buttons, not 1.
Back to top
View user's profile Send private message
BillP
Super User
Super User


Joined: 07 Jan 2006
Posts: 2703

PostPosted: Wed Oct 18, 2006 12:51 pm    Post subject: Reply with quote

Thanks. I never knew this or had completely forgotten it. It does work in Excel 97. Excel seems to remember the cell where tabbing first started and Enter moves to the cell below that cell, but it doesn't have to be the first cell in the row.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Oct 18, 2006 2:54 pm    Post subject: Reply with quote

When you have unocked your input range(s) and protected the sheet, the Tab-key navigates through all unlocked cells row by row.
Select range(s)
Format>Cells Tab:Protection uncheck "Locked"
Tools>Protect>Sheet
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
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