Issue 18110 - Standard in the autofilter doesn't accept regular expressions
Summary: Standard in the autofilter doesn't accept regular expressions
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC2
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-10 17:53 UTC by berberkenan
Modified: 2003-09-22 09:05 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 berberkenan 2003-08-10 17:53:24 UTC 
Standard option doesn't filter out expressions such as Field Name = G* altough
the help file explictly says that it can. 

My humble opinion is that the entire autofilter tool, being a very important
tool, has serious problems which needs prompt solution.
Comment 1 frank 2003-08-11 10:57:58 UTC 
Hi,

this is not a bug and the priority is much to high. Prio 1 means the
whole Application can't be started. So I adjusted it.

If you type '.*' without the quotes and set regular expressions under
the 'more' Tab, you get your desired result.

This is, aas the Star alone is interpreted as the Character and not
the wildcard. The dot makes it a regular expression. 

Best regards

Frank
Comment 2 frank 2003-08-11 10:58:19 UTC 
closed invalid
Comment 3 berberkenan 2003-09-20 10:58:21 UTC 
I don't want to look like a fool but:
I tried what you have proposed and I still couldn't get it to work. I
don't way to look like a fool by reopening the issue but:

There is my data set

<blank cell>
AA
AB
AC
AD
AF
AG
AH
BA
BB
BC
BD
BE
BF

I highlight the entire column including the blank cell, then I do,
DATA>FILTER>AUTOFILTER
Next I pick -Standard- from the pulldown menu on the top of the
column. Standard Filter window comes up. I put 'Column A = A.*' and
pick regular expression under more.
When I hit OK. All data disapears. It all comes back after I chose
-all- from pulldown menu.

Version 1.1 RC2
OS : Win 98 SE
Comment 4 berberkenan 2003-09-21 12:42:32 UTC 
My bad. It actually works without problem.
Comment 5 frank 2003-09-22 09:05:09 UTC 
closed