Filter Libreoffice

admin

Since the first release of our filter in LibreOffice 3.5.0, we were improving it thanks to bug reports from our users. It is a big thank you that I would like to say to all those that took the bother to submit reports in our bugzilla. Without you, guys, this filter would be only a moot exercise. These videos demonstrate how to get the distinct/unique values in a column or a list of elements in LibreOffice Calc. Procedure to get the distinct values in a column or a list of elements: Select the column (or the list of data) that you want to process Click on the top menu Data then click. I often use filters in my Open/LibreOffice and wanted to know how to create a macro that removes all existing filters. The OpenOffice Wiki tells you how to do this. The underlying logic is that when a filter is applied to a sheet, it replaces any existing filter for the sheet. Setting an empty filter. LibreOffice Base Tutorial (Making a Filter Inside a Form): In this Tutorial, I make a new database using LibreOffice Base and I try to make a filter form using an external SQL Query. Using text box, or combo box as parameter for searching for items in records, is not easy in LibreOffice. In this tutorial I. Insert Image dialog 1) Click in the LibreOffice document where you want the image to appear. 2) Choose Insert Image From File from the Menu bar. 3) On the Insert Image dialog, navigate to the file to be inserted, and select it.

  1. Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR.

  2. Once you have created a filter matrix, select the sheet ranges to be filtered. Open the Advanced Filter dialog by choosing Data - Filter - Advanced Filter, and define the filter conditions.

  3. Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the Format - Row - Show command.

Example

Load a spreadsheet with a large number of records. We are using a fictional Turnover document, but you can just as easily use any other document. The document has the following layout:

A

B

C

D

E

1

Month

Standard

Business

Luxury

Suite

2

January

125600

200500

240000

170000

3

February

160000

180300

362000

220000

4

March

170000

and so on...


Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on.

A

B

C

D

E

20

Month

Standard

Business

Luxury

Suite

21

January

22

<160000


Rows

Specify that only rows which either have the value January in the Month cells OR a value of under 160000 in the Standard cells will be displayed.

Choose Data - Filter - Advanced Filter, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view.

Related Topics

< Documentation‎ OOo3 User Guides‎ Calc Guide
  • Filters
Filter libreoffice free



Use filters to limit the visible rows in a spreadsheet. Generic filters, common to all sorts of data manipulations, are automatically provided by the auto filter capability. You can also define your own filters.

Libreoffice
After applying a filter, some rows are visible and some rows are not. If you select multiple rows in one operation, you will also select the invisible rows contained between the selected visible rows. Operations, such as delete, act on all of the selected rows. To avoid this problem, you must individually select each of the filtered rows using the control key.

Auto filters

Use auto filters to quickly create easily accessible filters found to be commonly used in many different types of applications. After creating an auto filter for a specific column, a combo box is added to the column. The combo box provides quick access to each of the auto filter types.

  • The All auto filter causes all rows to be visible.
  • The Standard auto filter opens the Standard Filter dialog and is the same as the standard filter.
  • The Top 10 auto filter displays the ten rows with the largest value. If the value 70 is in the top ten values, then all rows containing the value 70 in the filtered column are displayed. In other words, more than ten rows may be displayed.
  • An auto filter entry is created for each unique entry in the column.

To create an auto filter, first select the columns to filter. For example, using the data in Table 1, select data in columns B and C. If you do not select the title rows, Calc asks if the title row or the current row should be used. Although you can place the auto filter in any row, only the rows below the auto filter are filtered. Use Data > Filter > AutoFilter to insert the auto filter combo box in the appropriate cell. Finally, use the drop-down arrow to choose an appropriate auto filter.

Filter Libreoffice Calc

Use an auto filter with column C.

Remove an auto filter by repeating the steps to create the auto filter—in other words, the menu option acts as a toggle to turn the auto filter on and off. When an auto filter is removed, the combo box is removed from the cell. The macro in Listing 4 demonstrates creating an auto filter for a range.

Standard filters

Use Data > Filter > Standard Filter to open Standard Filter dialog and limit the view based on 1 to 3 filter conditions. Use Data > Filter > Remove Filter to turn off the filter.

Use the standard filter

The macro in Listing 5 creates a simple filter for the first sheet.

Listing 5. Create a simple sheet filter.

When a filter is applied to a sheet, it replaces any existing filter for the sheet. Setting an empty filter in a sheet will therefore remove all filters for that sheet (see Listing 6).

Listing 6. Remove the current sheet filter.

Listing 7 demonstrates a more advanced filter that filters two columns and uses regular expressions. I noticed some unexpected behaviour while working with Listing 7. Although you can create a filter descriptor using any sheet cell range, the filter applies to the entiresheet.

Listing 7. A simple range filter using two columns.


Libreoffice Filter By Color

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).

Libreoffice Filter Function

Retrieved from 'https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Filters&oldid=242118'