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

[Jean Bréfort <jean brefort normalesup org>]

gnumeric/1.12.1/plugins/fn-math/plugin.la is actually not needed.

Regards,
Jean

Le samedi 18 mai 2013 à 10:40 -0600, Andreas Guelzow a écrit :
> 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