SheetXL - v0.3.20
    Preparing search index...

    Interface JSON

    A JSON representation useful for persistence.

    interface JSON {
        formulas?: string[];
        pivot?: boolean;
        priority?: number;
        ref: string | IRange.Coords | IRange.Coords[];
        stopIfTrue?: boolean;
        style?: IStyle.Properties;
        type: IConditionalFormat.Type;
    }

    Hierarchy (View Summary)

    Index

    Properties

    formulas? pivot? priority? ref stopIfTrue? style? type

    Properties

    formulas?: string[]

    Use for evaluating. The number of formula is operator dependent.

    pivot?: boolean

    If associated with a pivot.

    false
    priority?: number

    Default will be the order these are added.

    ref: string | IRange.Coords | IRange.Coords[]

    An A1 representation of a ranges that is the bounding area for the conditionals.

    stopIfTrue?: boolean
    false
    style?: IStyle.Properties

    A conditional format must have 1 only 1 of the following properties set.

    type: IConditionalFormat.Type

    The type of conditional formatting rule.

    Settings

    Member Visibility

    On This Page

    Properties