|
|
|
|
|
Width
|
Number
|
-
|
The width of the column.
|
DataType
|
character
|
"string"
|
The data type of the column. This is the data type that is used internally when sorting and filtering.
number
|
Number
|
string
|
character
|
datetime
|
Date and Time
|
|
DateTimeFormat
|
character
|
""
|
Date format (only ".D" and ".T" can be specified as option format in "System format"). If nothing is specified, it will be interpreted as the default date format.
|
EnabledSearchFilter
|
Boolean
|
TRUE
|
Set whether to include it in the search for the SearchFilter method. If you do not specify the third argument in the SearchFilter method and want to search everything, set this property to FALSE to exclude it from the search.
|
EnabledFieldFilter
|
Boolean
|
TRUE
|
If you want to set the cell type to a headerfieldfilter type cell and disable input, set this property to FALSE.
|
EnabledSortFilter
|
Boolean
|
TRUE
|
If you want to set the cell type to a headerbutton type cell and disable sorting, set this property to FALSE.
|
SortState
|
character
|
"NONE"
|
The state of the sort.
NONE
|
No sorting
|
ASCENDING
|
Sort Ascending
|
DESCENDING
|
Sort Descending
|
|
SortCompareNoCase
|
Boolean
|
FALSE
|
If DataType is character (string), and you want to sort without distinguishing between uppercase and lowercase letters, set this property to TRUE.
|
NumberFormat
|
character
|
""
|
Number format. This format is used to internally convert strings to numbers during sorting. If you do not set numeric data in the number format in the cell, there is no need to set this.
|
Temp
|
character
|
""
|
You can freely store your own strings in this property. It can be used for internal processing when displaying the screen, temporary storage of parameters, etc.
|