OK - this seems to be the desired behaviour for the small/large
functions...
Yours
Joseph
---------- Forwarded message ----------
Date: Tue, 17 Feb 2009 00:47:26 +0000 (UTC)
From: "Gnumeric (bugzilla.gnome.org)" <bugzilla-dae...@bugzilla.gnome.org>
To: gn...@josephmaher.org
Subject: [Bug 571744] function small has changed behaviour between 1.6.3 and
1.8.3
If you have any questions why you received this email, please see the text at
the end of this email. Replies to this email are NOT read, please see the text
at the end of this email. You can add comments to this bug at:
http://bugzilla.gnome.org/show_bug.cgi?id=571744
Gnumeric | Analytics | Ver: 1.8.x
Morten Welinder changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution| |NOTABUG
------- Comment #1 from Morten Welinder 2009-02-17 00:47 UTC -------
This is correct and, in turns out, deliberate, see.
http://bugzilla.gnome.org/show_bug.cgi?id=343176#c4
The work-around is to use a range. If your original data was not in a
range as-is, create a new range that simply copies the data.
The documentation appears to be fixed in 1.9.x:
static GnmFuncHelp const help_small[] = {
{ GNM_FUNC_HELP_NAME, F_("SMALL: @{k}-th smallest value in a data
set.")
},
{ GNM_FUNC_HELP_ARG, F_("data:data set")},
{ GNM_FUNC_HELP_ARG, F_("k:which value to find")},
{ GNM_FUNC_HELP_NOTE, F_("If data set is empty this function returns a
#
NUM! error.") },
{ GNM_FUNC_HELP_NOTE, F_("If @{k} <= 0 or @{k} is greater than the
numbe
r of data items given "
"this function returns a #NUM! error.")},
{ GNM_FUNC_HELP_DESCRIPTION, F_("This function is Excel compatible.")
},
{ GNM_FUNC_HELP_EXAMPLES, F_("Let us assume that the cells A1, A2, ...,
A5 contain numbers "
"11.4, 17.3, 21.3, 25.9, and 40.1.") },
{ GNM_FUNC_HELP_EXAMPLES, F_("Then SMALL(A1:A5,2) equals 17.3."
"SMALL(A1:A5,4) equals 25.9.") },
{ GNM_FUNC_HELP_SEEALSO, "PERCENTILE,PERCENTRANK,QUARTILE,LARGE"},
{ GNM_FUNC_HELP_END }
};
Closing as NOTABUG because the change was deliberate and necessary to fix
implicit iteration.
--
See http://bugzilla.gnome.org/page.cgi?id=email.html for more info about why
you received
this email, why you can't respond via email, how to stop receiving
emails (or reduce the number you receive), and how to contact someone
if you are having problems with the system.
You can add comments to this bug at
http://bugzilla.gnome.org/show_bug.cgi?id=571744.
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
