Hi Eike
Thanks for the help.
> Effectively you're now trying to confuse the interpreter ;-)
> No, the cause seems to be that for the case of dimension arguments being
> given, internally always a range reference is returned. Didn't verify,
> but I think that returning a single reference for the case of a 1x1
> dimension it could work as you expected. We could call this a bug.
Probably the best plan then is for me to put a footnote in the
function description. This isn't going to be top of anyone's list
at the moment ;)
> Note
> however that your example isn't very meaningful
I came across it trying to solve a real life problem actually.
But it would have been a bit of a too-clever solution if it had
worked....
> and in Excel generates
> an error anyway and doesn't return any value there ...
Calc may be a long way ahead of Excel here. I believe Excel can't
handle quite a few functions in array formulae - eg CONCATENATE -
it seems to have a very makeshift approach.
On the other hand ;) in Calc {=ISLOGICAL({TRUE;"cat";"dog"})}
returns {FALSE;TRUE;TRUE} ....
Can I raise that one as an issue? Can't be right, can it?
David
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
