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



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>



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]