Re: [sc-dev] What are valid arguments for INDIRECT

[Regina Henschel]

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: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org