Re: RANK() "bug compatibility"

[Jody Goldberg <jody gnome org>]

On Sun, Jun 20, 2004 at 03:23:22PM +0200, Matthias Drochner wrote:
> Just found a difference in behaviour of the RANK() function:
> If the list of numbers (the "ref" argument) contains a non-
> numeric field, this is silently ignored by Excel (and OpenOffice).
> With gnumeric (1.2.12) I get a "#VALUE!" error.
> While this looks correct formally, it has the effect that some
> (sloppy) worksheets work with Excel but not with gnumeric.

Finally decided to have a look at this (bugzilla is really a better
choice) over lunch.  The fix is trivial s/VALUE_TERMINATE/NULL/
and will be in 1.3.2