Re: [1.12] countif(range, expression) unimplemented

[Andreas Guelzow <aguelzow pyrshep ca>]

On Sat, 2013-05-18 at 13:22 +0200, bat guano 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 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

-- 
Andreas Guelzow <aguelzow pyrshep ca>