Issue 23503 - How to filter a column by a string
Summary: How to filter a column by a string
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-12 13:50 UTC by cianoz
Modified: 2004-01-06 16:01 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
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 cianoz 2003-12-12 13:50:29 UTC 
In OOo v1.1 (but it's the same on previous vers) i didn't find a way to make a
filter by a string content of a column, using a "standard" filter.
Guess you have some rows with several columns filled, as follows:
(col.A)    (col.B)
Test01     item 1 fdsfsdfa
Test02     item 2 remvhe93
Result01   result 1 ghtrur
Result02   result 2 rhvghe

How can filter my sheet by column A containing the string "Test" (= Test01,
Test02) ?
I didn't find any way to do this by handling the function/value fields in the
dialog box following the "Standard filter" command.
It seems that filters works fine only with numeric content.
Thank you.
Comment 1 frank 2004-01-06 16:00:54 UTC 
Hi,

this is neither a bug nor a feature, but an support request. Sucgh questions are
answered on the mailing lists. Especialy user@...

The Answer is use the more button in the filter dialog and enable regular
expression and enter '.*Test.*' without the quotes into the parameter field.

Frank
Comment 2 frank 2004-01-06 16:01:20 UTC 
closed inv