At 18:52 23/06/2008 +0300, Dotan Cohen wrote:
When entering formulas, such as =sum(A1:A5), I find it much safer to type =sum() and then to back-arrow between the parenthesis to fill in the parameters. Anyone who programs in mid- to high- level languages will find this natural. However, in OOo pressing the arrow keys begins the cell selection rectangle. I know that I could reconfigure the arrow keys, but I would rather leave them as is because in other contexts the default arrow key behaviour is intuitive. How can one configure the arrow keys to move within the currently edited cell, yet leave their behaviour intact in all other instances? I have found a workaround by editing formulas in the bar at the top (how do you call this?). However, this requires the use of the mouse and slows work.
I think this is easy. Before you start to type the formula, just press F2 to enter Edit Mode. You can now edit the formula in its cell, and you will find that the left- and right-arrow keys work as you need.
If you wish, you can set Calc up to accept Enter as an alternative to F2 to achieve this change to Edit Mode. To do this, go to Tools | Options... | OpenOffice.org Calc | General | Input settings, and put a tick by "Press Enter to switch to edit mode".
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
