2008/6/23 Brian Barker <[EMAIL PROTECTED]>: > 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 >
Thanks, Brian, I did not realize that I could hit F2 without first leaving the cell. Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
