wks.col.categorical.type

Syntax

wks.col.categorical.type

Type

numeric

Access

Read/write

Description

Read or set the type for column n:
0 = Column type not Categorical.
1 = Auto off: Set as Categorical, with Categories manually managed. Categories can be added/deleted and are arbitrarily sorted (cannot be sorted by wks.col.categorical.sort).
2 = Auto on: Set as Categorical, with Categories auto-generated by column data (can be sorted by wks.col.categorical.sort). Categories updated automatically with data change.

Examples

See wks.col.categorical.sort

See also

wks.col.categorical.sort, wks.col.filter