Re: [Libreoffice] append function result to string

2011-01-04 Thread James
On 01/04/11 13:53, Regina Henschel wrote: > Hi James, > > James schrieb: >> I want to prepend the result of the AVERAGE function with the string >> 'average '. > > Where did you try this? AVERAGE and Concat are Calc functions and CStr > is a BASIC function. You cannot mix that. > >> I tried this: >

Re: [Libreoffice] append function result to string

2011-01-04 Thread Regina Henschel
Hi James, James schrieb: I want to prepend the result of the AVERAGE function with the string 'average '. Where did you try this? AVERAGE and Concat are Calc functions and CStr is a BASIC function. You cannot mix that. I tried this: =concat('average ',cstr(AVERAGE(C3:C200))) In Calc ="av

[Libreoffice] append function result to string

2011-01-04 Thread James
I want to prepend the result of the AVERAGE function with the string 'average '. I tried this: =concat('average ',cstr(AVERAGE(C3:C200))) ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoff