Hi, On 18.05.2013 00:22, Andreas J Guelzow wrote:
"function implementation unavailable" should mean that you do not have the plugin loaded that defines 'countif'. Please check Tools->Plugins whether the Math functions are loaded.
I am sorry to say, but all plugins are "activated", whatever that means. You have a point however, as none of the other Math-functions are available, anyway. Screen-shot. Cheerio, Michael
Andreas On Fri, 2013-05-17 at 23:57 +0200, bat guano don blech e4ward com wrote:Good evening Tim, and good evening List. On 17.05.2013 23:32, Tim Schofield wrote:I think it should have read: =countif(c3:c9,"x");Unfortunately, I have tried both (and more).note the comma, not the semicolon. At least that works for me.The result remains the same. Also, if you ignore the semicolon, I really proceded like in my original post. Gnumeric itself should know how to construct the formula. ;-) In the meantime, I have written two python functions, one for "count in rows" and one fo "count in columns" as the ranges are not comfortable to work with. These functions replace countif, at least in the current context. As regards the missing countif in 1.12.1, I have posted the question to the french Ubuntu forum. For the time, nobody has really answered in a way which could clarify, if the error is specific to the Ubuntu-package in 13.04. I might try the same in the german and the english forums. Re-installing from the resources of the Linux-distribution has not changed anything. Good night, Michael.Thanks Tim On 17 May 2013 13:36, <bat guano don blech e4ward com <mailto:bat guano don blech e4ward com>> wrote: Hi, trying to count all occurences of "x" in a line, I chose from the function-dropdown "mathematics", then countif and completed the formula =countif(c3:c9;"x") The result is an error "function implementation unavailable". The message is translated from the German locale that I use but should be all in all identic in English. I do not ask for a fix, as I am quicker writing the missing function in Python. ;-) Cheerio, Michael. _______________________________________________ gnumeric-list mailing list gnumeric-list gnome org <mailto:gnumeric-list gnome org> https://mail.gnome.org/mailman/listinfo/gnumeric-list -- Course View Towers, Plot 21 Yusuf Lule Road, Kampala T +256 (0) 312 314 418 M +256 (0) 752 963 325 www.weberpafrica.com @TimSchofield2 Blog: http://weberpafrica.blogspot.co.uk/_______________________________________________ gnumeric-list mailing list gnumeric-list gnome org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Attachment:
sc_plugins.png
Description: PNG image
