Am 17.01.2012 17:23, tk5ep wrote:
Hi All, I have a 130000 lines CALC file. I need to : - filter the lines according a criterion - export these lines to a new XLS file named after this criterion - email the file this has to be done about 500 times (criterions) Has anybody a solution ?? Thanks for any help, -- View this message in context: http://nabble.documentfoundation.org/Batch-for-extracting-lines-into-new-files-in-CALC-tp3666623p3666623.html Sent from the Users mailing list archive at Nabble.com.
Leave behind all spreadsheets. There is no technical reason nor convenience factor in favour of using spreadsheets with a database dump of raw data. The dBase driver of the Base component supports indexing for fast lookups within millions of rows. Save as dBase in a *dedicated directory*. dBase is a database in a directory.
Connect a Base document to the *directory*. Open the table for editing and add some indices on relevant fields. Create a set of simple queries. Parameter queries are supported.Video tutorial on something similar with a small amount of data in a sheet: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=40403&p=186845&hilit=+parameter#p186158
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted