Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
8.3
8.3
Description

Excerpt

The AutoFilter class represents the filter that is applied to a selected area of cells in a worksheet.

...

Remarks

To return an AutoFilter object, use Worksheet.AutoFilter.

By There is only one auto filter per worksheet; by default, the filter is not set . If the worksheet doesn't already have a filter, the and AutoFilter.Area property will return null. In order to apply the

When applying an auto filter to a selected select area of cells in the on a worksheet, the Area property has to bear in mind:

  1. AutoFilter.Area must be set to an Area object
. The designated area has to be
  1. on the same worksheet as the auto filter.
  2. There
can
  1. is only
be
  1. one auto filter
in a
  1. per worksheet.
However the area of cells that it is applied to can be changed to different areas of cells within the same worksheet through the AutoFilter.Area property.
  1. If AutoFilter.Area is already set, changing AutoFilter.Area will overwrite the previous area and the auto filter will be applied to the new area.
  2. AutoFilter.Area must include all of the cells that the filter applies to. ExcelWriter will not automatically detect the boundaries of the filtered area.

The filter will be removed from the worksheet either by calling the filter's Clear() method, by setting the Area property to null, or by deleting all the rows (or just the first row that has the filter headers) or all the columns of the filter from the worksheet.

...

Name

Description

Area

Excerpt Include
EW8:AutoFilter.AreaEW8:
AutoFilter.Area
nopaneltrue

...

Name

Description

Clear()

Excerpt Include
EW8:AutoFilter.Clear()EW8:
AutoFilter.Clear()
nopaneltrue