Applying Filters

Filteri i napredni filteri omogućavaju rad na odredjenim filtriranim redovima (podacima) u nizu podataka. U spreadsheet-u u LibreOffice postoje razne mogućnosti za primjenu filtera.

  1. Jedna primjena AutoFilter funkcije je da brzo ograničiš prikazivanje identičnih unosa u polje za unos podataka.

  2. U Standardni filter dialogue box, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect up to three conditions with either a logical AND or a logical OR operator.

  3. :The Advanced filter exceeds the three condition limitation and allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.

Tip Icon

To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose Data - Filter - Reset Filter.


Note Icon

:When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected.


Note Icon

:This is the opposite to rows that you have hidden manually by the Oblik - Redovi - Hide Redovi command. Manually hidden rows are deleted when you delete a selection that contains them.