Issue 17993 - Add wildcards to the standard autofilter
Summary: Add wildcards to the standard autofilter
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: All All
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability, rfe_eval_ok
: 63554 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
 
Reported: 2003-08-07 23:20 UTC by philmperry
Modified: 2014-03-20 17:34 UTC (History)
6 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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"