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

[Niklas Nebel]

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.

And same with issue 104969, References to external sheets not allowed or 
 allowed but still need to be implemented?

INDIRECT with external references works (works again, see issue 101645). 
The problem in issue 104969 seems to be the use of OFFSET together with 
external references.

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).

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org