Represents a filter which can filter data based on whether the data is below or above the average of the entire data range.

See

[[WorksheetTableColumn.filter]]

Hierarchy

Hierarchy (view full)

Constructors

  • Parameters

    Returns AverageFilter

  • Parameters

    Returns AverageFilter

  • Parameters

    • a: number
    • Rest ..._rest: any[]

    Returns AverageFilter

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get average(): number
  • Gets the average that was computed the last time the filter was applied or 0 if any errors or all non-numeric values were found when applying the filter.

    Returns number

  • get type(): AverageFilterType
  • Gets or sets the value indicating whether to filter in values below or above the average of the data range. AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average.

    Throws

    [[InvalidEnumArgumentException]] The value assigned is not defined in the [[AverageFilterType]] enumeration.

    Returns AverageFilterType

  • set type(a): void
  • Parameters

    Returns void

Methods

  • Parameters

    • other: any

    Returns boolean

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean