GNOME Bugzilla – Bug 497954
sort in autofilter
Last modified: 2018-05-22 13:24:09 UTC
The following was requested as http://bugs.debian.org/415718 : Package: gnumeric Version: 1.6.3-5 Severity: wishlist Microsoft Excel 2003 has Sort Ascending and Sort Descending options in the autofilter dropdown (see http://www.exceltip.com/st/Sort_Ascending/Descending_While_Using_AutoFilter/726.html ) This allows for temporarily sorting all relevant rows by the column containing the autofilter dropdown. This would be a helpful addition to Gnumeric.
Another helpful addition would be be to put similar functionality in the context menu's of row and column labels. I suspect the most common sort functionality used in spreadsheets is "sort the whole sheet by the contents of this column/row". Since the only variable in that statement is which row or column, it makes sense that the action could be performed by selecting a row or column. As an example, I right click on the label of Column H; I'm presented with a sort submenu, in which are three options: 1: first row of sheet contains headings (checkable) 2: sort sheet by this column ascending 3: sort sheet by this column descending
another problem when using this filter is it overwrites data in boxes between those you checked... thus if you have 100 rows but the filter only shows you 10 of these rows and you drag a figure across these 10, when you check all to see the whole sheet, everything has been written with what you just dragged... meaning you can only manually edit a figure for an account, such as changing a discount percentage for a customer, in a database worksheet containing many customers, or if a customer changes their name so you change that field, and suddenly every customer between the fields is now that customer. This bug is also in open office and in libre office but not in excel... Not sure why...
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/87.