Re: Question on working with TEXT function

[Jean Bréfort <jean brefort normalesup org>]

Le dimanche 20 juillet 2008 à 14:21 +0200, Berthold Höllmann a écrit :
> Why is this formula invalid:
>
>  =text(index(w!A:A;v!$A220+1;1;1),index(w!B:B;v!$A220+1;1;1);"00 00")
                                   ^
I don't understand why you use the comma just above. If you want to
separate two arguments, you need to use ';' in german locale, and in all
cases the text function takes only two arguments.

> whereas 
>
>  =text(1,1;"00 00")
>
>  =index(w!A:A;v!$A220+1;1;1)
>
> and
>
>  =text(index(w!A:A;v!$A220+1;1;1);"00")
>
> are all valid? Is this a bug im my older gnumeric version (1.7.11) or
> am I doing something wrong?
>
> Regards 
> Berthold