On Sat, Jul 26, 2008 at 7:19 PM, Richard Detwiler <[EMAIL PROTECTED]> wrote: >> Your test is not what I was trying to do. I am only typing a hyphen, >> nothing else. The solution is to press enter before moving to another >> cell (although enter moves the cursor down one cell). The reason I'm >> clicking on other cells is because I'm quickly entering data into >> various places in a spreadsheet, and sometimes I want to move to >> another cell, so I click on it. >> > Interesting -- I still can't duplicate what you're seeing. When I type just > a hyphen in a cell, then press an arrow key or click in another cell, it > simply enters the hyphen as typed, and doesn't try to make it into a > formula. Possibly it's a version difference -- I'm using OOo 2.3.0, on > Windows XP.
Maybe it's changed in a recent version. I'm using 2.4.0 (haven't got the 2.4.1 update yet). Jason > I've always taught (and been taught) in Excel that to make a formula, it > always always has to start with an equal sign. And I had assumed (and found) > that to be true in Calc as well. But possibly a more recent version of Calc > enables starting formulas with + or - signs as well? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
