Jason Cipriani wrote:
On Fri, Jul 25, 2008 at 3:54 PM, Richard Detwiler <[EMAIL PROTECTED]> wrote:
Jason Cipriani wrote:
How do I type a hyphen - or a double hyphen -- in a cell without
wrestling with auto-complete? Once I type it, if I click anywhere else
or move the arrows, it fills in the cell numbers.
Jason -- can you be more specific about what you're trying to do? And what
specifically you're typing, with the hyphen?
I can't replicate a problem in this regard, so I assume I must be doing
something differently than you are.
What I tried is typing "- test" (without the quotes) in a cell.
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.
Jason
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.
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]
