Apache OpenOffice (AOO) Bugzilla – Issue 17995
up standard autofilter fields from 3 to 4
Last modified: 2013-08-07 15:14:30 UTC
The spreadsheet database autofilter "standard" can handle up to three fields. Apparently the latest versions of Excel can handle four fields. Please consider upping the field count from three to four. Even better, allow a more-or-less unlimited number of filter fields (use a dialog with a scrolling list of fields and operators).
Hi Bettina, 1 4 u Frank
*** Issue 22974 has been marked as a duplicate of this issue. ***
It'll be a verey useful thing to be able to choose an unlimited number of filters field ...
*** Issue 34378 has been marked as a duplicate of this issue. ***
*** Issue 60235 has been marked as a duplicate of this issue. ***
*** Issue 83588 has been marked as a duplicate of this issue. ***
I would like to fix this issue.
Hi, all I would like to fix this issue.
Before implementing this, please check with User Experience if they agree on the change.
Maybe the filter function in Thunderbird may be a guide. It is a clean GUI with unlimited number of filters. Depending on amount of work it is maybe the best idea to have this final solution - when next Exel version does have five filters we don't have to add one more then ;-)
Extending the filter offers only a limited functionality. A far more flexible way to extend the functionality is described in issue 66588. http://www.openoffice.org/issues/show_bug.cgi?id=66588 Having the ability to perform SQL-statements natively in Calc (without external data sources) is a way more flexible feature without any artificial limitations. The existing filter has 3 major limitations: 1.) limited categories (currently 3) 2.) limited string functionality 3.) no possibility to save and load filter settings Also, comparisons between 2 fields cannot be done and need to be pre-computed. Extending the filter to cover 4 fields is at most a minor enhancement. IF it is still desired to extend it, then a more comprehensive solution that permits an unlimited amount of rows is warranted: [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [ADD CONDITION] [DELETE CONDITION] [UNDO] Where: [-] Deletes the corresponding filter condition [ADD CONDITION] Adds another row to the filter [DELETE CONDITION] Similar to [-], deletes the condition that has the focus [UNDO] Undo last action (e.g. restores a deleted condition) IF less than 2 conditions remain, then 2 rows will be displayed, with one or both rows empty (as appropriate).
Thank you for your comments.:)
Added comments from UX point of view on ux-discuss mailing list: http://ux.openoffice.org/servlets/ReadMsg?list=discuss&msgNo=2316
Created attachment 56234 [details] Default appearance of Standard filter dialog
Created attachment 56235 [details] Expanded Standard filter dialog showing all options
Created attachment 56236 [details] Updated version with corrected buttons
Created attachment 56237 [details] Updated version tith corrected buttons
Slightly reworking my previous comment: IF it is still desired to extend it, then a more comprehensive solution that permits an unlimited amount of rows is warranted: [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [OPERATOR] [FIELD] [CONDITION] [VALUE] [-] [MORE OPTIONS] [DELETE CONDITION] [UNDO] [HELP] Where: A new row of conditions is automatically added once ALL rows are filled with conditions. [CHANGED from my previous post.] [-] Deletes the corresponding filter condition. If there are less than 3 conditions, the remaining rows up to 3 are displayed empty. [DELETE CONDITION] Similar to [-], deletes the condition that has the focus [UNDO] Undo last action (e.g. restores a deleted condition) [MORE OPTIONS] Display the advanced options [HELP] Display the Help
And forgot the OK/Cancel buttons :-) [MORE OPTIONS] [DELETE] [UNDO] [OK] [CANCEL] [HELP]
Created attachment 59129 [details] This patch described as follows: In standard filter dialog box, adds a row for filter condition, and increases filter conditions to 8 groups. The number of connection listbox add to 4 when the slider is not in 0 position. By scrollbar, the filter conditi
Created attachment 59130 [details] This patch described as follows: In standard filter dialog box, adds a row for filter condition, and increases filter conditions to 8 groups. The number of connection listbox add to 4 when the slider is not in 0 position. By scrollbar, the filter conditi
Created attachment 59131 [details] This patch described as follows: In standard filter dialog box, adds a row for filter condition, and increases filter conditions to 8 groups. The number of connection listbox add to 4 when the slider is not in 0 position. By scrollbar, the filter conditi
Because of the bad network, datafilter.patch is submitted three times, the three attachments about datafilter.patch are the same.
Hi Niklas, I have reviewed this patch file,I think it can work well,I hope you can review it.thanks!
Some points: - When filling the dialog from existing conditions (ScFilterDlg::Init), why is the last value left out? - The Tab order of the list boxes is wrong. - It must be possible to use the dialog with the keyboard, also to scroll to the other entries. In the Function Wizard and the Solver dialog we use cursor keys in the edit fields, but the list boxes in the filter dialog use the cursor keys already. You could add a TabStop flag to the scroll bar, but that wouldn't be very comfortable. Maybe you have a different idea. Otherwise this seems to work.
Created attachment 59196 [details] The updated patch of i17995
Created attachment 59197 [details] A patch about issue 17995.
I looked at gaojingmei's last patch and noticed 2 things: - In the "Find & Replace" dialog, "Less Options" has been renamed to "Fewer Options" (issue 84980), so we should also use "Fewer Options". - The tab order of the list boxes is correct now, but the order of the other controls is a bit strange.
Created attachment 59313 [details] The updated patch of i17995
The new patch looks good and I think we can integrate it when we have a CWS for 3.2 (feature freeze for 3.1 is over).
taking the issue
I added this to CWS "calc49". I changed the dialog layout a bit to match Frank's suggestion in the screenshot. The "Condition" list boxes should be made larger only when issue 35579 is integrated. The wide list boxes with the short content would look a bit strange.
reassigning to QA for verification
verified in internal version cws_calc49. Updated autotest c_updt2.bas to handle this enhancement
Verified in DEV300m49 on WinXP Closing