Equivalent for FILTER() formula in Libre Office

Do you need automatic refresh, when the source table changed? If not, Data->More Filters->Standard Filter with the option Copy results to set to the desired sheet should do the trick.