Jean Bréfort <[EMAIL PROTECTED]> 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?
pgptDyOmbBYqB.pgp
Description: PGP signature
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
