In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell.

=FILTER(Sheet1!A2:E, Sheet1!E2:E > 0)   

This gives me all the rows in the Sheet1 from row 2 downwards where the value in column E is greater than 0.

What would be the equivalent in LibreOffice Calc?

  • Is that intended to be =FILTER(Sheet1!A2:A, Sheet1!E2:E > 0) ? Aug 10, 2017 at 19:53

1 Answer 1


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.

  • 3
    No, With filter() function, you can then pass it to another function, for example to calculate standard deviation out of the resulting filter
    – Xwtek
    Apr 21, 2020 at 0:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.