Issue 75774 - String Filter in Calc Standard Filter
Summary: String Filter in Calc Standard Filter
Status: CLOSED DUPLICATE of issue 35579
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-03-27 10:23 UTC by ramanal
Modified: 2008-05-17 23:13 UTC (History)
1 user (show)

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

Attachments
Ms. Excel's Custom Auto Filter (14.62 KB, image/jpeg)
2007-03-27 10:24 UTC, ramanal 		no flags Details
String Filter item in Ms. Excel (19.53 KB, image/jpeg)
2007-03-27 10:26 UTC, ramanal 		no flags Details
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 ramanal 2007-03-27 10:23:47 UTC 
User usually set Auto-Filter in a table of data, then choose which item will be
shown by choosing filter in selected column.

There is three options in auto filter in each column:
- all
- standard
- Top 10

The standard filter only have items for numeric filtering  (> = < Largest
Smallest Largest %, Smallest %), but none for String filtering like (contains,
begin with, etc).

Attached is Ms. Excel Filter.
Comment 1 ramanal 2007-03-27 10:24:56 UTC 
Created attachment 43960 [details]
Ms. Excel's Custom Auto Filter
Comment 2 ramanal 2007-03-27 10:26:39 UTC 
Created attachment 43961 [details]
String Filter item in Ms. Excel
Comment 3 kpalagin 2007-03-28 15:04:24 UTC 
Dup of http://www.openoffice.org/issues/show_bug.cgi?id=35579.
Resolving.

ramanal,
please vote for 35579.
Also please note that 35579 is waiting for file format specification, so no 
need to post additional comments.
In the mean time you can use regular expressions to achieve the result (if I 
am not mistaken ".*Contact.*" is identical to "contains 'Contact'").

*** This issue has been marked as a duplicate of 35579 ***
Comment 4 ace_dent 2008-05-17 21:11:37 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 5 ace_dent 2008-05-17 23:13:54 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew