API Reference

Class

ExcelAutoFilterColumnInfo

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Complete public state for one AutoFilter column.

Inheritance

  • Object
  • ExcelAutoFilterColumnInfo

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Properties

public UInt32 ColumnOffset { get; } #

Zero-based offset inside the AutoFilter range.

public ExcelAutoFilterCriteriaKind Kind { get; } #

Criterion family.

public IReadOnlyList<String> Values { get; } #

Explicit values.

public IReadOnlyList<ExcelAutoFilterConditionInfo> Conditions { get; } #

Custom comparisons.

public IReadOnlyList<ExcelAutoFilterDateGroupInfo> DateGroups { get; } #

Date-group values.

public Boolean MatchAll { get; } #

Whether all custom comparisons must match.

public Boolean IncludeBlank { get; } #

Whether blank values are included.

public Boolean HiddenButton { get; } #

Whether the filter button is hidden.

public Boolean ShowButton { get; } #

Whether the filter button is shown.

public Nullable<Boolean> Top { get; } #

Top rather than bottom criterion.

public Nullable<Boolean> Percent { get; } #

Percentage rather than item count criterion.

public Nullable<Double> TopValue { get; } #

Top/bottom threshold.

public String DynamicType { get; } #

Dynamic criterion type.

public Nullable<Double> DynamicValue { get; } #

Dynamic criterion value.

public Nullable<Double> DynamicMaximum { get; } #

Dynamic criterion maximum.

public Nullable<UInt32> DifferentialFormatId { get; } #

Color differential-format index.

public Nullable<Boolean> CellColor { get; } #

Whether a color filter targets the cell color.

public String IconSet { get; } #

Icon set name.

public Nullable<UInt32> IconId { get; } #

Icon index.