title: LibreOffice: Advanced Filter with Named Ranges
body: <p>I have a (rather big) table which I want to filter. Since the filter is complicated I am using "advanced filter". This works fine if I input the cell-range where the advanced filter is located (e.g. <code>$Sheet1.$F$18:$F$21</code>) in the Advanced Filter Filter-Criteria dialog. </p>
  
  <p>Now, since I want to have multiple advanced filters and since selecting them every time is quite cumbersome I thought of using <strong>named ranges</strong>. Then I could simply imput <code>fa</code>, <code>fb</code>, <code>fc</code> for my different filter criterias. But the Advanced Filter dialog does not accept this. I get an <code>invalid sheet reference</code> error.</p>
  
  <p>How can I use named ranges together with advanced filters? Or is there another easy way to have pre-defined filters which can easily be activated?</p>