[libreoffice-users] Re: Automate a Data Filter in Calc ?

Am 22.03.2012 00:32, lagagnon wrote:
> I have a 2500 line "database" in LO Calc with 10 fields per record (line). In
> a second sheet I want only specific records from the first sheet (the
> database) which match 3 criteria. I haven't quite figured out how to do that
> manually with Data, Filter, Standard Filter but it seems possible, but I
> cannot figure out how to post that filtered data to the second sheet.

Under [More Options] you can specify OtherSheet.A1 as target.

> Also, is there a way to automate it so that, say with a click of a button
> the filtering takes place?

Click a single cell in the source range and call Data>Refresh
This reapplies the last filter and/or sort order.


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