Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Add wildcards to the standard autofilter|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||eva-email, frank.loehmann, issues, pagalmes.lists, pet.ebe, rainerbielefeld_ooo_qa|
|Version:||OOo 1.1 Beta2||Keywords:||ms_interoperability, rfe_eval_ok|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
|Issue Depends on:|
Description philmperry 2003-08-07 23:20:25 UTC
The spreadsheet database's "standard" autofilter accepts either very simple matching or regular expressions. Although any wildcard usage should be expressible in a regular expression ( '*' == '.*' and '?' == '.' ), for the benefit of those migrating over from Excel and used to working with wildcards perhaps that option could be added (or even be the default, instead of simple matching). It might be possible to scan for * and ? in the simple matching expression and convert to .* and . and feed it to the regexp processor, although this simple-minded fix probably won't work right if the user should accidentally include any regexp control characters. Therefore it should probably be a three-way (radio button) choice: simple matching, wildcards, or regular expression.
Comment 1 oc 2003-09-17 09:40:23 UTC
Hi Bettina, one4you
Comment 2 bettina.haberer 2004-01-30 15:54:30 UTC
Add wildcards to the standard autofilter. This issue is considered for OO.o 2.0.
Comment 3 Regina Henschel 2006-03-25 23:12:14 UTC
*** Issue 63554 has been marked as a duplicate of this issue. ***
Comment 4 claudiadzm 2007-01-06 07:37:39 UTC
"------- Additional comments from bh Fri Jan 30 07:54:30 -0800 2004 ------- Add wildcards to the standard autofilter. This issue is considered for OO.o 2.0." Could it be considered for 2.2?
Comment 5 frank.loehmann 2009-01-27 11:05:13 UTC
Set target and cc myself.
Comment 6 bettina.haberer 2010-05-21 14:43:39 UTC
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
Comment 7 Rainer Bielefeld 2014-03-20 17:33:57 UTC
Accepted without accepter? Also see "LibO#2196 - FILTER: Implement ODF 1.2 HOST-USE-WILDCARDS"