How to edit formulas in the formula bar

Hwoarang · Newbie Joined: 27 Aug 2003 Posts: 3 Location: Brazil

When we hit f2, we can edit the formula in the actual cell...
But I want to edit the formula in the formula bar...

I can't find where to configurate this...

Someone can help me ?

Thanx.

Hwoarang · Newbie Joined: 27 Aug 2003 Posts: 3 Location: Brazil

After a hard search for functions in Keyboard configurations I found the solution...

assign F2 to Insert Line, in Application category...

Bye...

Guest · Posted: Tue Nov 18, 2003 8:51 am Post subject:

I have the same problem but I don't understand your solution .. can you be more clear??

Tnx a lot

Guest · Posted: Tue Nov 18, 2003 2:41 pm Post subject:

Does it have ot be keyboard? Just click in the formula bar with your left-mouse. Then edit to your heart's content.

David.

ftack · Posted: Wed Nov 19, 2003 1:09 am Post subject:

That could indeed have been included as an option under Tools Options. Thanks, Hwoarang, for the tip of how it can be achieved anyway.

Guest · Posted: Wed Nov 19, 2003 9:37 am Post subject:

for a faster use I prefer to use the keyboard to edit (using F2) but I don't understand how Hwoarang have done this .. I can't find "Insert Line" in the Application category; I have an "insert line" voice under "Insert" category which inserts an entire line .. where (or which) is the correct voice to assign to the F2 key ?? Tnx a lot

ftack · Posted: Thu Nov 20, 2003 12:45 am Post subject:

Tools Configure
Category: Application
Function: Input Line. This is by default assigned to Ctrl+Shft+F2, but you want to change that to F2

Guest · Posted: Sat Nov 22, 2003 2:20 am Post subject:

thanks a lot I was using an Italian version of OOO and I wasn't able to find the correct translation of "input line" (was "insert line") .. searching by shortcut (ctrl+shift+F12) I found it immediately ..