[sc-dev] What are valid arguments for INDIRECT

[Regina Henschel]

Hi,

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?

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

And what about all type of names? INDIRECT("name") will fail. I know, 
that is mentioned in the help. But must it fail?

kind regards
Regina

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