Hello! 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: =sumproduct((item_temp<>"rent")*(amount_temp<0)*amount_temp) 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 :) Harry
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
