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 [email protected]
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
