SheetXL - v1.0.2
    Preparing search index...

    Interface AddOptions

    Options for adding a chart: sheet.getCharts().add(source, options).

    interface AddOptions {
        anchorType?: IAnchored.Type;
        author?: Author;
        autoSelect?: boolean | IMovable.SelectOptions;
        autoSelectRestore?: boolean;
        bounds?: Partial<Bounds>;
        description?: string;
        expectedCommitId?: string;
        meta?: Record<string, string>;
        name?: string;
        readOnly?: boolean;
        seriesBy?: SeriesBy;
        type?: string;
    }

    Hierarchy (View Summary)

    Index
    anchorType? author? autoSelect? autoSelectRestore? bounds? description? expectedCommitId? meta? name? readOnly? seriesBy? type?
    anchorType?: IAnchored.Type

    How the chart moves and resizes with the cells under it.

    IAnchored.Type.TwoCell

    author?: Author

    Who authored this change. Recorded on the commit (ICommit.getAuthor).

    the store's author, else null (unattributed)

    autoSelect?: boolean | IMovable.SelectOptions

    Select the movables the operation leaves the user working on, once it completes.

    Resolved once, when the outermost operation closes: within a batch the selection is where the last operation that asked leaves it, an addToSelection extending what came before.

    autoSelectRestore?: boolean

    Select what the operation acted on when it is undone or redone: an undo lands on the selection it began with, a redo where it left the user.

    autoSelect

    bounds?: Partial<Bounds>

    The chart's frame in pixels. A size with no position is placed in the middle of the visible window, or at the selection where there is none.

    Excel's 5 by 3 inches (480 by 288 pixels)
    description?: string

    A human description.

    'determined by the set operation and locale'
    expectedCommitId?: string

    Optimistic concurrency guard. If set, the operation only begins if the store's current commit id matches; otherwise a TransactionConflictError is thrown.

    The check happens atomically as the root transaction begins — there is no window between check and commit. If any transaction is already open the check fails with reason open (the head could move beneath the operation).

    meta?: Record<string, string>

    Stored with the commit (ICommit.getMeta) — for what a view of the history wants to know beyond the description, such as the command that made the change.

    name?: string

    The chart's name.

    A name made from the type, such as Chart 3.

    readOnly?: boolean

    Declares the operation read-only: any state update within it throws.

    false

    Writes are tracked automatically — a batch that performs no updates never creates a commit (no new commit id, no events, no undo entry) whether or not this is set. The flag is purely an assertion for callers that want the guarantee enforced. Nested transactions inherit it; they cannot opt back out.

    seriesBy?: SeriesBy

    Whether each series is a row or a column of the cells.

    'auto'

    type?: string

    The chart's type.

    'columnClustered'

    Settings
    Member Visibility

    On This Page
    Properties