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
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
