On Sat, 2013-05-18 at 13:22 +0200, bat.gu...@don.blech.e4ward.com wrote: > 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.
So this is an installation problem. Somewhere on your system you should have gnumeric/1.12.1/plugins/fn-math gnumeric/1.12.1/plugins/fn-math/plugin.la gnumeric/1.12.1/plugins/fn-math/plugin.so gnumeric/1.12.1/plugins/fn-math/plugin.xml It appears that on your system, Gnumeric can find gnumeric/1.12.1/plugins/fn-math/plugin.xml since otherwise it would not know that countif even existed and you could not 'activate' the plugin, but Gnumeric fails to find at least one of gnumeric/1.12.1/plugins/fn-math/plugin.la gnumeric/1.12.1/plugins/fn-math/plugin.so I would suggest you try to reinstall Gnumeric. If that does not help, it should be a distribution (i.e. Ubuntu) issue. Andreas > > Screen-shot. > > Cheerio, > > Michael > > > > > Andreas > > > > On Fri, 2013-05-17 at 23:57 +0200, bat.gu...@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.gu...@don.blech.e4ward.com > >>> <mailto:bat.gu...@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 > > > > > > > -- Andreas Guelzow <aguel...@pyrshep.ca> _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
