SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface Stop

    One threshold in a IConditionalFormat.Scale — where a band starts.

    Stops are held in the order they were authored, which for every scale Excel can write is ascending. A color scale attaches a color to each; a data bar and an icon set do not.

    interface Stop {
        exclusive?: boolean;
        type?: IConditionalFormat.ColorStopType;
        value?: string | number | IFormula;
    }

    Hierarchy (View Summary)

    Index
    exclusive? type? value?
    exclusive?: boolean

    Upper bound exclusivity.

    false => inclusive (>=), true => exclusive (>) If true, equality does NOT enter the upper stop/segment (exclusive upper bound). Default false matches Excel's boundary-inclusive behavior.

    false
    type?: IConditionalFormat.ColorStopType
    StopType.Num
    value?: string | number | IFormula

    The value of the stop

    • For numbers: Threshold value:
      • Num: absolute number
      • Percent: 0..100 of min..max span
      • Percentile: 0..100 quantile (requires percentile stats)
    • For formulas:
    • Formula: a formula whose result is the threshold. Authored as formula text or an ICalculation.IFormula; a rule holds it as an IFormula.

    Settings
    Member Visibility

    On This Page
    Properties