|
Sets the cell type.
|
From Rev7 onwards, it has become possible to specify the cell property "CellType" with SetCellProperty. Therefore, we recommend using SetCellProperty.
|
Syntax 1
SetCellType (
"cell",
cellType,
col,
row
[,props]
)
Specifies the cell type for the specified cell only.
Parameters
areaType
|
|
Type:
|
character
|
|
"cell"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
col
|
|
Type:
|
Number
|
|
Column index (column number starting from 0). If you want to specify the header section, specify the index in order starting from -1 in the negative direction.
|
row
|
|
Type:
|
Number
|
|
Index of the row (row number starting from 0). If you want to specify the header section, specify the index in negative order starting from -1.
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 2
SetCellType (
"all",
cellType
[,props]
)
Specify the cell type for all cells at once. You can change the properties for each cell later.
Parameters
areaType
|
|
Type:
|
character
|
|
"all"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 3
SetCellType (
"row",
cellType,
row
[,props]
)
Specifies the cell type for the specified row at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"row"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
row
|
|
Type:
|
Number
|
|
Row index (row number starting from 0). If you want to specify the header section, specify an index starting from -1 in the negative direction.
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 4
SetCellType (
"col",
cellType,
col
[,props]
)
Specifies the cell type for the specified column at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"col"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
col
|
|
Type:
|
Number
|
|
Column index (column number starting from 0). If you want to specify the header section, specify the index in negative order starting from -1.
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 5
SetCellType (
"range",
cellType,
col1,
row1,
col2,
row2
[,props]
)
Specifies the cell type for the specified range all at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"range"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
col1
|
|
Type:
|
Number
|
|
Index of column 1 (column number starting from 0). If you want to specify the header section, specify the index in negative order starting from -1.
|
row1
|
|
Type:
|
Number
|
|
The index of row 1 (row number starting from 0). If you want to specify the header section, specify an index starting from -1 in the negative direction.
|
col2
|
|
Type:
|
Number
|
|
Index of column 2 (column number starting from 0). If you want to specify the header section, specify the index in order starting from -1 in the negative direction.
|
row2
|
|
Type:
|
Number
|
|
Index of row 2 (row number starting from 0). If you want to specify the header section, specify an index starting from -1 in the negative direction.
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 6
SetCellType (
"common",
cellType
[,props]
)
Specifies a common type for all cells. With "all", you can change the properties for each cell later, but with "common", all cells share one common property.
For example, if you change the background color of a common property, the background colors of all cells will become that color. Common properties are set with SetCellProperty("common"…).
Especially when there are a large number of cells, setting common properties with "common" can speed up processing of SetCellProperty.
Parameters
areaType
|
|
Type:
|
character
|
|
"common"
|
cellType
|
|
Type:
|
character
|
|
cell type. ("label" / "edit" / "combo" / "meter" / "lamp" / "switch" / "button" / "sidebutton" / "image")
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
 Explanation
Sets the type of the cell.
|
reference
AddStyle
SetDefaultStyle
SetCellStyle
ClearStyle
SetCellType
SetCellProperty
GetCellProperty
SetColProperty
GetColProperty
SetRowProperty
GetRowProperty
SetColWidth
GetColWidth
SetRowHeight
GetRowHeight
SetGridLine
MergeCells
UnmergeCells
|