Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to filter a spreadsheet on LibreOffice 3.4.4 Calc, based on values of a second spreadsheet column. How can I do that ?

I would like intersection and, if possible, complement filters. So the result would be only cells that are in the other spreadsheet, or cells in the first that are not in the other.

share|improve this question
So I figured it out doing Advanced filtering, and then I found a terrible issue here: (which limits size of filtering criteria). – Niloct Jun 13 '12 at 15:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.