Question on working with TEXT function

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")

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
-- 
A: Weil es die Lesbarkeit des Textes verschlechtert.
F: Warum ist TOFU so schlimm?
A: TOFU
F: Was ist das größte Ärgernis im Usenet?

_______________________________________________
gnumeric-list mailing list
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list

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
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list

Jean Bréfort <jean.brefortnormalesup.org> writes:

> 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.

I hoped text would accept an arbitrary number of values to
be
formatted. I now use concatenate to get the wanted result.

> 
>
>> whereas 
>> 
>>  =text(1,1;"00 00")

I misinterpretd the outcome of this.

>>  
>> 
>>  =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

Thank You
Berthold

-- 
A: Weil es die Lesbarkeit des Textes verschlechtert.
F: Warum ist TOFU so schlimm?
A: TOFU
F: Was ist das größte Ärgernis im Usenet?

_______________________________________________
gnumeric-list mailing list
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list