Hi,
I've a formula in a range of cells, that can evaluate to a value, but
also can evaluate to nothing.
Example: =IF(AND(A13>5;A14>5);A13;"")
Now using the keys ctrl-arrow to navigate, the cursor jumps to the
first/last cell in that range.
Example of cells with formula:
all have the same formula> A2 A3 A4 A5 A6 A7
value as result in the cell> 5 5 7
When in A1 and pressing Ctrl-left, the cursor goes to A2.
pressing Ctrl-left again, the cursor goes to A7.
I would have liked if the cursor jumps to a cell that holds a value.
So, when in A1 and pressing Ctrl-left, that the cursor goes to A3.
pressing Ctrl-left again, that the cursor goes to A4.
Is this behaviour by design, or that can't be avoided, or that can be
changed via an option, or ...
Thanks for your replies,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws
Arnhem - Netherlands - nl.OpenOffice.org - marketing contact
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
