Hi Brian,
Brian Barker wrote (18-3-2008 15:28)
At 08:38 18/03/2008 +0100, Cor Nouws wrote:
(I trust it's not *exactly* the same formula, as that would normally be
expected to produce identical results! Er, yes: I'm aware of the
exceptions to this.)
Yes, it was just an example. The real beast looks like this:
=IF($M62>0;(IF(AND(DAYS($M62;V$1)<$T$2;DAYS($M62;V$1)>-1);$Q62;""));(IF(AND(DAYS($L62;V$1)<$T$2;DAYS($L62;V$1)>-1);$Q62;"")))
And all cells in a range of 40 or more rows and columns. But that is of
no interest for this issue, so pls don't try to understand ;-)
You have confused the matter a little here, as you have laid out your
description horizontally and then talked of using the left arrow key -
which might be appropriate for a row - but you label your cells as A2 to
A7, which are actually elements of a column rather than a row. And then
you later say "left" when I suspect that you must mean "right".
(Apologies if I've misunderstood this.) Assuming that you are
describing a row and that you do mean "right" ...
You are right, my description was not precise enough. I should have
typed Ctrl-Right.
When in A1 and pressing Ctrl-[right], the cursor goes to A2. pressing
Ctrl-[right] 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-[right], that the cursor goes to A3.
pressing Ctrl-[right] 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 ...
I can't say whether it is by design, but it is certainly what happens.
The help text talks of "data ranges" and contrasts them with cells that
are "empty". Clearly a cell that contains a formula which happens to
evaluate to a null string is not regarded as "empty", but instead as
holding a value (as you put it) - the formula itself. I don't know of
any way in which this can be configured.
Hmm.
Depending on what you are trying to achieve, one workaround could be to
The problem is, that the formula fills a rather large range with 35
columns or so.
And I would like to jump from one cell at the left to just the one cell
with a value in it - all other cells hold just the formula.
copy the data area and use Paste Special with Numbers ticked and
Formulas not ticked, either back in place or somewhere else. You could
then navigate around in your row more as you wish. But note that, even
then, this technique does not move to the next cell that contains a
value but rather to the last cell in the current data range. Ctrl+right
in your A3 will move to A4 not because it is the next occupied cell, but
because it happens also to be the last cell in the present contiguous
range of occupied cells. If A5 were occupied, focus would move there
(or beyond).
Thanks for your help, Brian, but I my situation that's not an improvement.
Kindest regards,
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]
