Hi Niklas,
Niklas Nebel schrieb:
On 09/19/09 22:15, Regina Henschel wrote:
the submitter of issue 105182 closed the issue, because he find a way
to solve his problem. But for me the situation is not clear.
=ISREF(D1:D3!C2:E2) returns TRUE
but
=ISREF(INDIRECT("D1:D3!C2:E2")) returns FALSE
=ISREF(A1~B1) returns TRUE
but
=ISREF(INDIRECT("A1~B1")) returns FALSE
And INDIRECT("(A1:C3):(B2:D4)") fails too.
Are expressions as text not allowed for INDIRECT or are they allowed
but not implemented yet?
INDIRECT is supposed to parse a reference, not any more complex expression.
So what is a 'reference'? For ISREF the help say, "Tests if the argument
is a reference. Returns TRUE if the argument is a reference, returns
FALSE otherwise." Taking that, D1:D3!C2:E2 is a 'reference'.
I know that INDIRECT cannot work with this sort of 'reference' up to
know. My question is, whether this is because of definition in ODF or
not. If the definition allows it, then we can enhance INDIRECT (if we want).
And what about all type of names? INDIRECT("name") will fail. I know,
that is mentioned in the help. But must it fail?
The help is outdated here. Support for named ranges was added some time
ago (issue 4695).
Indeed, that works now. :)
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
