SheetXL - v0.3.20
    Preparing search index...

    Interface JSON

    ISheet persistence structure.

    interface JSON {
        directStyles?: { r: ICellRange.RefJSON; v: number }[];
        dynamic?: { r: ICellRange.RefJSON; v: JSON }[];
        dynamicArray?: [address: string, error: boolean][];
    }
    Index

    Properties

    directStyles? dynamic? dynamicArray?

    Properties

    directStyles?: { r: ICellRange.RefJSON; v: number }[]

    Either an object with RangeAddress to style id or an array of RangeCoordValue to style id.

    dynamic?: { r: ICellRange.RefJSON; v: JSON }[]

    A generalize solution for dynamic areas. This is used for externalData

    "C5:G10": { "type": "externalData", "error": false, // Or true if the last refresh failed "source": "Query1", // Example: Type-specific info "overrides": { // Object storing user edits within the region "D6": "Manual Edit", // Key = Cell Address within region "F8": 123.45 // Value = User-entered value } }

    dynamicArray?: [address: string, error: boolean][]

    Indicates a range was created via a dynamic array formula. This is a specific type of dynamic.

    Settings

    Member Visibility

    On This Page

    Properties