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

2012-01-19 Thread tk5ep
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 times. I was looking for a way to do that with

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

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

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:

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

2012-01-18 Thread Andreas Säger
Am 17.01.2012 17:23, tk5ep wrote: Hi All, I have a 13 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

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

2012-01-18 Thread Andreas Säger
Am 18.01.2012 14:56, Calvin Kim wrote: I usually convert it to .csv and extract data with PHP, but I love to see how to do it with Calc. cK Manually without any coding: Connect a registered Base document to the spreadsheet. A connection to an indexed dBase copy might be more performant.

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

2012-01-18 Thread Andreas Säger
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 query for testing if you get the wanted records for

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

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

2012-01-17 Thread tk5ep
Hi Jay, The Calc file has only one sheet, no formulas, only raw datas. I need to extract all lines having the same value (numerical) from one column and create an XLS sheet with these lines. This XLS file must be named with the value used to filter. For example, filter all lines who have 001 in