[libreoffice-users] Re: LibreOffice Calc - Filter text

Thank you Brian. The method you suggested is the one that worked for me.
On May 14, 2011 10:14 AM, "Brian Barker [via Document Foundation Mail
Archive]" <ml-node+2939714-1466972320-399335@n3.nabble.com> wrote:
> At 21:06 12/05/2011 -0700, Nobody Noname wrote:
> > From a .csv spreadsheet document, how would I filter text and save
> > the filtered items to another .csv spreadsheet document. I usually
> > use CSVed 2.1.4 to perform such tasks, but I would like to figure
> > out how to accomplish this from within LibreOffice Calc.
>
> At 19:58 13/05/2011 -0400, Nobody Noname wrote:
> > Thanks for everyone's help, but I am not trying to figure out how to
> > save a document as .csv, but trying to figure out how to filter a
> > .csv document by a word or phrase, and extract that data from within
> > one document and save it to another. Similar to using "Find &
> > Replace" to search for a word or phrase within a document. I just
> > can't figure out how to extract the found data to create a separate
> > document with only the extracted data to create a separate document,
> > such as another .csv document.
>
> If I understand you correctly, this should be fairly easy:
> o Open your .csv document in Calc.
> o Apply the filter. (I'm assuming you know how to do this.)
> o Now copy the range of filtered material.
> o Either open a new spreadsheet document or insert a new sheet into
> the existing one.
> o Paste the copied material into the new document or sheet. Notice
> that the copy action copied only the visible, filtered cells.
> o Save the new document or sheet in .csv format: in either case,
> only the active sheet will be saved.
>
> As has already been suggested, you can achieve the filtering and
> copying in one action (provided you have selected the appropriate
> range of material) by clicking the More button in the Filter dialogue
> and then using Copy results to... to copy the filtered results to
> another sheet.
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be
deleted
> _______________________________________________
> If you reply to this email, your message will be added to the discussion
below:
>
http://nabble.documentfoundation.org/LibreOffice-Calc-Filter-text-tp2934506p2939714.html
> To unsubscribe from LibreOffice Calc - Filter text, visit
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2934506&code=cGhhbnRvbTE5NjlAZ21haWwuY29tfDI5MzQ1MDZ8LTExNDMzMjY2MDU=


--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Calc-Filter-text-tp2934506p2941371.html
Sent from the Users mailing list archive at Nabble.com.
-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted