SheetXL - v1.0.2
    Preparing search index...

    Interface JSON

    A group as JSON.

    interface JSON {
        colorAxis?: string;
        colorFirst?: string;
        colorHigh?: string;
        colorLast?: string;
        colorLow?: string;
        colorMarkers?: string;
        colorNegative?: string;
        colorSeries?: string;
        data: string;
        dateAxis?: boolean;
        dateRange?: string;
        displayEmptyCellsAs?: ISparklineGroup.EmptyCellsAs;
        displayHidden?: boolean;
        displayXAxis?: boolean;
        first?: boolean;
        high?: boolean;
        last?: boolean;
        lineWeight?: number;
        low?: boolean;
        manualMax?: number;
        manualMin?: number;
        markers?: boolean;
        maxAxisType?: ISparklineGroup.AxisType;
        minAxisType?: ISparklineGroup.AxisType;
        negative?: boolean;
        rest?: Record<string, string>;
        rightToLeft?: boolean;
        type?: ISparklineGroup.Type;
    }

    Hierarchy (View Summary)

    Index
    colorAxis? colorFirst? colorHigh? colorLast? colorLow? colorMarkers? colorNegative? colorSeries? data dateAxis? dateRange? displayEmptyCellsAs? displayHidden? displayXAxis? first? high? last? lineWeight? low? manualMax? manualMin? markers? maxAxisType? minAxisType? negative? rest? rightToLeft? type?
    colorAxis?: string
    colorFirst?: string
    colorHigh?: string
    colorLast?: string
    colorLow?: string
    colorMarkers?: string
    colorNegative?: string
    colorSeries?: string
    data: string

    The data, as a list of areas paired by position with the group's ranges: each the data the range's first cell draws (A2:E2,A9:E9 for F2:F4,G3).

    Every other cell of a range draws the same area moved by its offset from the first cell, as a conditional format's formula is written for the first cell of its range: in F2:F4 reading A2:E2, F3 draws A3:E3. An area on the group's own sheet is written without a sheet name. An empty area is a range with no data, which draws nothing (F2:F4,G5 with A2:E2,).

    dateAxis?: boolean

    Space the points by the dates in dateRange.

    false

    dateRange?: string

    The cells holding the date of each point, as a formula; read when dateAxis is on.

    displayEmptyCellsAs?: ISparklineGroup.EmptyCellsAs

    'zero'

    displayHidden?: boolean

    Draw the values of hidden rows and columns.

    false

    displayXAxis?: boolean

    A horizontal axis at zero, when zero is within the vertical range.

    false

    first?: boolean

    The first point in colorFirst.

    false

    high?: boolean

    The highest point in colorHigh.

    false

    last?: boolean

    The last point in colorLast.

    false

    lineWeight?: number

    The line's weight in points.

    0.75

    low?: boolean

    The lowest point in colorLow.

    false

    manualMax?: number

    The maximum, when maxAxisType is 'custom'.

    manualMin?: number

    The minimum, when minAxisType is 'custom'.

    markers?: boolean

    A marker on every point of a line.

    false

    maxAxisType?: ISparklineGroup.AxisType

    'individual'

    minAxisType?: ISparklineGroup.AxisType

    'individual'

    negative?: boolean

    Negative points in colorNegative.

    false

    rest?: Record<string, string>

    Attributes a file gave the group that are not modeled here, kept so a resave writes them back.

    rightToLeft?: boolean

    Draw from right to left.

    false

    type?: ISparklineGroup.Type

    'line'

    Settings
    Member Visibility

    On This Page
    Properties