Re: Is =concatenate("a",,a) valid?

[David Stanaway <david stanaway net>]

On Tue, 2005-01-04 at 21:58 +0100, Helmut Wollmersdorfer wrote:
> On my tries to improve the Gnumeric testcases and compare them with the 
> behaviour of MS/XL I got some crazy characters, which seems to be the 
> content of a buffer or stack out of XL XP, after entering
>
>    =concatenate("a",,a)
>
> As I understand the docs, the parameter
>
>     a
>
> is not a valid string, or something else valid, and this should always 
> result in an error. Right?


I do not get this, I get #NAME? since a is undefined.

http://www.stanaway.net/~david/gnumeric/concatenate-a-a.png

Possibly a region is aliased a, or some other magic.

-- 
David Stanaway <david stanaway net>