Issue 23503

Summary:	How to filter a column by a string
Product:	Calc	Reporter:	cianoz <luczani>
Component:	ui	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 RC5
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

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