wks.col.categorical.type
Contents
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.