Re: RANK() "bug compatibility"

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

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