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

Am 13.05.2011 06:06, phantom1969 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. Thanks in advance.
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/LibreOffice-Calc-Filter-text-tp2934506p2934506.html
> Sent from the Users mailing list archive at Nabble.com.

Since csv is a database exchange format, Base would be the office 
component to do this in the most convenient ways.
http://user.services.openoffice.org/en/forum/viewtopic.php?t=40403#p186158

In Calc, you can import your source file into a blank sheet of a regular 
spreadsheet document with more than one sheet (Insert>Sheet From File...).
Then Data>Filter>Standard... specify criteria
[More Options] Copy Result to: OtherSheet.A1.


--
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