Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

Simple question: 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.

Hope that makes sense.

Thanks.

share|improve this question
So I figured it out doing Advanced filtering, and then I found a terrible issue here: oooforum.org/forum/viewtopic.phtml?t=44999 (which limits size of filtering criteria). – Niloct Jun 13 '12 at 15:04

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.