OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung PDF herunterladen (Seite 327)

100

101

2) Duplicate the column headings from the area to be filtered into the area that

will contain the filter criteria.

3) Enter the filter criteria underneath the column headings (see Table 24). The

criterion in each column of a row is connected with AND. The criteria from

each row are connected with OR.

Table 15. Example advanced filter criteria

Name Test 1 Test 2 Quiz 1 Quiz 2 Average Grade

="Andy" >80

<80

Tip

Define named ranges to reference your advanced filter criteria and any

destination ranges for filtered data (see Figure 321). Each appropriately

configured named range is available in drop down list boxes in the

Advanced Filter dialog (see Figure 328).

After creating one or more sets of filter criteria, apply an advanced filter as follows:

1) Select the sheet ranges that contain the data to filter.

2) Use Data > Filter > Advanced Filter to open the Advanced Filter dialog (see

Figure 328).

3) Select the range containing the filter criteria and any other relevant options.

4) Click OK.

Applying an advanced filter using a macro is simple (see Listing 17). The cell range

containing the filter criteria is used to create a filter descriptor, which is then used to

filter the range containing the data.

Figure 328. Apply an advanced filter using a previously defined named range.

Listing 17. Use an advanced filter.

Sub UseAnAdvancedFilter()

Dim oSheet 'A sheet from the Calc document.

Dim oRanges 'The NamedRanges property.

Chapter 13 Calc as a Simple Database 327

1 2 ... 322 323 324 325 326 327 328 329 330 331 332 ... 433 434

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung Seite 327

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software OpenOffice.org OpenOffice - 3.3