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

    Interface Preset

    A named fill a user can be OFFERED — a Filler plus the options that configure it.

    A menu entry is not a filler. Fill Days is the date filler with no options; Linear Trend is the linear filler with Options.trend on. The same filler appears under several presets, and they do not all apply to the same selection: a growth series steps from a single value, where a growth trend needs two to fit.

    AutoFill.canApply — whether a preset can be offered for a given selection.

    interface Preset {
        filler: Filler;
        id: string;
        minValues?: number;
        options?: IAutoFill.Options;
    }
    Index
    filler id minValues? options?
    filler: Filler

    The filler this preset drives.

    id: string

    Stable id — what a menu entry, a script, or a transaction's ITransaction.Operation.params names. Not a display label; those are localized against this id.

    minValues?: number

    The fewest non-blank values the preset can work from.

    1

    A trend has to fit a line through the values, so it needs two — which is why Excel greys Linear Trend on a single cell but offers Fill Days there.

    options?: IAutoFill.Options

    Options applied on top of the caller's own.

    Settings
    Member Visibility

    On This Page
    Properties