Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

ExcelAutoFilterColumnInfo

OfficeIMO.Excel

Namespace
OfficeIMO.Excel
Assembly
OfficeIMO.Excel
Source revision
e163ccb36643 with working tree changes
Modifiers
sealed

Complete public state for one AutoFilter column.

Inheritance

  • object
  • ExcelAutoFilterColumnInfo

Usage

Explore 1 API references to this type

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

Returned or exposed by 1

Properties

public uint 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 bool MatchAll { get; } #

Whether all custom comparisons must match.

public bool IncludeBlank { get; } #

Whether blank values are included.

public bool HiddenButton { get; } #

Whether the filter button is hidden.

public bool ShowButton { get; } #

Whether the filter button is shown.

public bool? Top { get; } #

Top rather than bottom criterion.

public bool? Percent { get; } #

Percentage rather than item count criterion.

public double? TopValue { get; } #

Top/bottom threshold.

public string? DynamicType { get; } #

Dynamic criterion type.

public double? DynamicValue { get; } #

Dynamic criterion value.

public double? DynamicMaximum { get; } #

Dynamic criterion maximum.

public uint? DifferentialFormatId { get; } #

Color differential-format index.

public bool? CellColor { get; } #

Whether a color filter targets the cell color.

public string? IconSet { get; } #

Icon set name.

public uint? IconId { get; } #

Icon index.