Re: sumproduct with "names" // fine in libreoffice, #VALUE! warning in gnumeric
- From: fellowsgarden gmail com
- To: gnumeric-list gnome org
- Subject: Re: sumproduct with "names" // fine in libreoffice, #VALUE! warning in gnumeric
- Date: Sun, 23 Oct 2011 11:12:24 +0200
PS: expenses, therefore amount_temp<0, as the column also contains income...
On Sun, Oct 23, 2011 at 11:07 AM, <fellowsgarden gmail com>
I just installed gnumeric (on ubuntu) for the first time and tried to open a document from libreoffice calc.
Gnumeric returns an error message for this field, when opening the document:
The cell shows the #VALUE! warning.
Both in openoffice / libreoffice this works, and is supposed to return the sum of all expenses _excluding_ rent (which it does, in oo & libreoffice).
Gnumeric does recognize the sumproduct function. It, too, recognizes the "names" I defined (it shows a rectangle around them, resp., when I F2 the problematic field).
I hope you have an idea :)
] [Thread Prev