Re: [libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-19 Thread Sigrid Carrera
Hi, did you actually read the instructions? I'm talking about this ones here: http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Btw, this link is added to each email, so you should have seen it. If you did read the instructions, then why didn't you write to the postmaster,

Re: Re: [libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-19 Thread SARoets
Unsubscribe me please! The unsubscribe procedure does not work! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette Li

Re: [libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-19 Thread Jay Lozier
Patrick, On 01/19/2012 06:32 AM, tk5ep wrote: Hi All, Thanks for the different answers, but even if there are good ideas, they are all more demanding than doing all the work by hand in Calc. I could filter, copy , paste the result in a new sheet and save it... 4 or 5 clicks to be repeated 124

Re: [libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-18 Thread Calvin Kim
On 01/18/2012 03:08 PM, Andreas Säger wrote: Am 18.01.2012 18:13, Andreas Säger wrote: Connect a registered Base document to the spreadsheet. A connection to an indexed dBase copy might be more performant. Create a parameter query: SELECT * FROM "Table" WHERE "Column"= :p Use the parameter q

Re: [libreoffice-users] Re: Batch for extracting lines into new files in CALC

2012-01-18 Thread Calvin Kim
I usually convert it to .csv and extract data with PHP, but I love to see how to do it with Calc. cK -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki