SheetXL - v0.3.20
    Preparing search index...

    Interface ValueTypeJSON

    Describes the type characteristics of a function parameter or return value.

    At least one of scalar, range, or context must be defined.

    interface ValueTypeJSON {
        arrayDepth?: number;
        description?: string;
        range?: "r" | "l" | "a";
        scalar?: string;
    }

    Hierarchy (View Summary)

    Index

    Properties

    arrayDepth? description? range? scalar?

    Properties

    arrayDepth?: number

    Defines the number of array signatures after a parameter.

    • 0: No array signature. The value is scalar or a single cell.
    • 1: Will flatten.
    • 2: Nest.

    0 if no range is defined, otherwise 1.

    description?: string

    A short description of the value's purpose or expected usage.

    range?: "r" | "l" | "a"

    Indicates that the value is a range (multi-cell) structure.

    • r: A RangeReference, representing a pointer to sheet coordinates.
    • l: A RangeLiteral, representing the actual values in the range.
    • a: A materialized array (Scalar[] or Scalar[][]) that has been extracted from the range.

    If specified, the function supports multi-cell or structured range inputs.

    scalar?: string

    Indicates that the value is a single, scalar cell-compatible value.

    This corresponds to a ScalarType such as Number, Boolean, or String. ScalarType.Null is permitted only for event handler return types.

    Settings

    Member Visibility

    On This Page

    Properties