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



Good evening,

On 18.05.2013 18:40, Andreas Guelzow wrote:
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

The XML and the "dynamic" libraries are present for fn-math and also for
fn-stat but both do not work. The other functions appear to be okay.
By the way, there is not one statical library found anywhere in the
plugin-directories.

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.

Thank you, this is my guess, too. The discussion in the Ubuntu-forum
(fr) is continued and so far we have arrived at verifying the same
parameters as here. I am curious to read the next comments.

Cheerio,

Michael.


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








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