After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 647401 - autofilter top10-percentage behaves very differently from Excel
autofilter top10-percentage behaves very differently from Excel
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-04-10 23:30 UTC by Andreas J. Guelzow
Modified: 2012-08-03 04:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andreas J. Guelzow 2011-04-10 23:30:18 UTC 
Enter the data:
a
1
2
3
2
2
2
24

create an autofilter for this data select top10 and specify:
top 60 percentage

The autofilter now shows only a single item (24). This does not seem to make sense.
Comment 1 Andreas J. Guelzow 2011-04-11 00:35:33 UTC 
Looking at the code, Gnumeric selects the rows that are in the top 60% of the range of data values. (That's quite different from choosing a certain number or percentage of data records.) 

We may need to make this clearer if it is indeed what we intend to do.
Comment 2 Andreas J. Guelzow 2011-04-11 01:08:53 UTC 
Note that according to frob, Excel shows: 2-3-2-2-2-24
Comment 3 Andreas J. Guelzow 2011-04-11 01:14:20 UTC 
I have clarified the top10 dialog so that it is clear what we are calculating. We probably should add an option that allows us to select the same as Excel does, ie the top values as a percentage of the total number of items.
Comment 4 Andreas J. Guelzow 2012-08-03 04:09:38 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.