functions don't work in formulas

[Marc A. Jacobs]

Binary package hint: gnumeric

Ubuntu 8.04
gnumeric, gnumeric-common and gnumeric-doc version 1.8.2-1ubuntu1

Build in functions like PI, SIN, LOG, SUM etc don't work and result the formula result '#NAME?'. This occurs both on manual input of an formula and in previously created .gnumeric files (files worked OK in Ubuntu 7.10).

[LaserJock (laserjock)]

The only one I'm getting this with is PI, all the other ones seem to work.

[LaserJock (laserjock)]

Actually, PI() does work, PI doesn't and apparently shouldn't. Can you either give use a sample formula or spreadsheet? I'm not seeing a regression here.

[Marc A. Jacobs (marc-a-jacobs)]

Please find attached the test spreadsheet and the screen shot of the
results on my system.

PS. I wanted to include the Help/About dialog in the screen shot, but
this also seems broken as it doesn't appear via Help/About in the menu.

Jordan Mantha wrote:
> Actually, PI() does work, PI doesn't and apparently shouldn't. Can you
> either give use a sample formula or spreadsheet? I'm not seeing a
> regression here.
>
> ** Changed in: gnumeric (Ubuntu)
> Status: New => Incomplete
>
>

[LaserJock (laserjock)]

Hmm, that spreadsheet works fine. You may need to have the gnumeric-doc package install for the About dialog, although that seems a tad odd. In any case, everything works for me, pi, sin, log, About. To get the version of gnumeric you have installed, run:
   dpkg -l | grep gnumeric
in a terminal.

[Marc A. Jacobs (marc-a-jacobs)]

~$ dpkg -l | grep gnumeric
ii gnumeric
1.8.2-1ubuntu1 spreadsheet application for GNOME - main pro
ii gnumeric-common
1.8.2-1ubuntu1 spreadsheet application for GNOME - common f
ii gnumeric-doc
1.8.2-1ubuntu1 spreadsheet application for GNOME - document

gnumeric-doc thus already installed. However, more important for me is
the functions issue... This same non-working functions problem has hit
me before in the past. I don't know when, it might have been somewhere
around the Hoary or Breezy.

Jordan Mantha wrote:
> Hmm, that spreadsheet works fine. You may need to have the gnumeric-doc package install for the About dialog, although that seems a tad odd. In any case, everything works for me, pi, sin, log, About. To get the version of gnumeric you have installed, run:
> dpkg -l | grep gnumeric
> in a terminal.
>
>

[Marc A. Jacobs (marc-a-jacobs)]

Found a workaround: the gnumeric-gtk package does not seem to be effected by the formula problem (nor the About dialog).

[Peter Schachte (schachte-csse)]

I see the same bug in gnumeric version 1.8.2-1ubuntu1 under Ubuntu 8.04, and confirm that installing gnumeric-gtk in place of gnumeric fixes it. Using the gnumeric package, only a few functions (min, max, sum, product, and a very few more) are defined.

[DrLock (nospam-drlock)]

I can confirm this behavior in gnumeric 1.8.2-1ubuntu1. gnumeric-gtk 1.8.2-1ubuntu1 does not have this bug.

[Andreas J Guelzow (aguelzow)]

This sounds like the issue that the plugins aren't loaded (since they provide most functions). You may want to check tools->plugins and activate the plugins.

[Marc A. Jacobs (marc-a-jacobs)]

Fix confirmed. For the default gnumeric package no plugins are loaded
(in contrast to the gnumeric-gtk package). Enabling the plugins fixes
the issue.

Andreas Guelzow wrote:
> This sounds like the issue that the plugins aren't loaded (since they
> provide most functions). You may want to check tools->plugins and
> activate the plugins.
>
>

[Charlie Kravetz (cjkgeek)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. However, I am closing it because the bug has been fixed in the latest development version of Ubuntu - the Jaunty Jackalope. It won't be fixed in previous versions of Ubuntu because the package doesn't fit the requirements for backporting. See https://help.ubuntu.com/community/UbuntuBackports for more information.