wks.col.categorical.type

categorical.type

1 Syntax
2 Type
3 Access
4 Description
5 Examples
6 See also

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