Issue 74544

Summary:	RFC: Select rows by keyword
Product:	Calc	Reporter:	timjowers <timjowers>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P5 (lowest)	CC:	issues, kpalagin
Version:	OOo 2.0.4
Target Milestone:	---
Hardware:	All
OS:	All
URL:	http://www.serviza.com/
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description timjowers 2007-02-14 15:44:18 UTC

Say I buy a list of contacts and alot are schools. I'd love to be able to say
Data->Select by Keyword and enter "school" or even "school" "schl" "college" and
then hit select. Then be able to say Cut and cut those rows and put them on
another spreadsheet. That would be so useful. See, the keyword is embedded in
the cell so sorting doesn't help.

Comment 1 kpalagin 2007-02-15 05:24:45 UTC

timjowers,
you can hide your non-schools with the help of autofilter, and then copy 
visible rows with planned feature from Issue 
http://www.openoffice.org/issues/show_bug.cgi?id=33851

I suggest voting for i33851 (do not bother with comments - developers are 
waiting for community to deveop specification at 
http://wiki.services.openoffice.org/wiki/Calc/Drafts/Issue_33851)

I also suggest to vote for issues 
http://www.openoffice.org/issues/show_bug.cgi?id=25855
http://qa.openoffice.org/issues/show_bug.cgi?id=69690 too.

Resolving as dup of 33851.

*** This issue has been marked as a duplicate of 33851 ***

Comment 2 frank 2007-02-15 08:59:14 UTC

Or you're using the standard filter with output of the filtered data to another
sheet as it is possible since the beginnings of OOo