Variable ScalarType`Const`

ScalarType: {
    Boolean: "b";
    Error: "e";
    Null: "z";
    Number: "n";
    RichData: "r";
    String: "s";
}

Represents the type of a Scalar.

ReadonlyBoolean: "b"
A boolean value (true or false).
ReadonlyError: "e"
A cell that contains an error value.

Remarks
Error cells represent cells where an error occurred during formula evaluation or data processing.
ReadonlyNull: "z"
Represents a cell that contains no value (null).

Remarks
Cells with null values may still contain formatting or other cell metadata.
ReadonlyNumber: "n"
A numeric value.

Remarks
Dates are expressed as formatted numbers within cells. They are internally stored as serial numbers and can be formatted to display as dates.
ReadonlyRichData: "r"
A complex data type that is represented as a JSON object.

Remarks
Rich data may include structured or complex data that goes beyond simple strings, numbers, or booleans. Useful for use cases where a cell holds data like rich text or embedded objects.
ReadonlyString: "s"
A string value.

ScalarType is used to indicate the kind of data contained in the cell, such as a number, string, boolean, or rich data object.

For example, dates are represented as (serial) numbers, and rich text or complex data is stored as RichData.

Variable ScalarTypeConst