|
Set the cell properties.
Syntax 1-1
SetCellProperty(
"cell",
name,
value,
col,
row
)
Sets the properties for the specified cell.
Parameters
areaType
|
|
Type:
|
character
|
|
"cell"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
col
|
|
Type:
|
Number
|
|
Index of the column starting from 0. If you want to specify the header section, specify the index in the negative direction starting from -1.
|
row
|
|
Type:
|
Number
|
|
Index of the line starting from 0. If you want to specify the header section, specify the index in the negative direction starting from -1.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 1-2
SetCellProperty(
"cell",
props,
col,
row
)
Sets the properties for the specified cell.
Parameters
areaType
|
|
Type:
|
character
|
|
"cell"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
col
|
|
Type:
|
Number
|
|
Index of the column starting from 0. If you want to specify the header section, specify the index in the negative direction starting from -1.
|
row
|
|
Type:
|
Number
|
|
Index of the line starting from 0. If you want to specify the header section, specify the index in the negative direction starting from -1.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 2-1
SetCellProperty(
"all",
name,
value
)
Sets properties for all cells at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"all"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 2-2
SetCellProperty(
"all",
props
)
Sets properties for all cells at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"all"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 3-1
SetCellProperty(
"row",
name,
value,
row
)
Sets the properties for the specified rows all at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"row"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
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.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 3-2
SetCellProperty(
"row",
props,
row
)
Sets the properties for the specified rows all at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"row"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
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.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 4-1
SetCellProperty(
"col",
name,
value,
col
)
Sets properties for the specified columns in bulk.
Parameters
areaType
|
|
Type:
|
character
|
|
"col"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
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.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 4-2
SetCellProperty(
"col",
props,
col
)
Sets properties for the specified columns in bulk.
Parameters
areaType
|
|
Type:
|
character
|
|
"col"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
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.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 5-1
SetCellProperty(
"range",
name,
value,
col1,
row1,
col2,
row2
)
Sets properties for the specified range all at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"range"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
col1
|
|
Type:
|
Number
|
|
index of column 1 (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.
|
row1
|
|
Type:
|
Number
|
|
index of row 1 (row number starting from 0). If you want to specify the header section, specify the index in negative order starting from -1.
|
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 the index in negative order starting from -1.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 5-2
SetCellProperty(
"range",
props,
col1,
row1,
col2,
row2
)
Sets properties for the specified range all at once.
Parameters
areaType
|
|
Type:
|
character
|
|
"range"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
col1
|
|
Type:
|
Number
|
|
index of column 1 (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.
|
row1
|
|
Type:
|
Number
|
|
index of row 1 (row number starting from 0). If you want to specify the header section, specify the index in negative order starting from -1.
|
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 the index in negative order starting from -1.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 6-1
SetCellProperty(
"common",
name,
value
)
Sets common properties. Available only if "common" is specified in SetCellType.
Parameters
areaType
|
|
Type:
|
character
|
|
"common"
|
value
|
|
Type:
|
General purpose
|
|
The configuration value.
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
Syntax 6-2
SetCellProperty(
"common",
props
)
Sets common properties. Available only if "common" is specified in SetCellType.
Parameters
areaType
|
|
Type:
|
character
|
|
"common"
|
props
|
|
Type:
|
Characters (array)
|
|
Specify "Cell property". (Property setting format)
|
Return Value
|
|
Type:
|
Boolean
|
|
FALSE - Failure. TRUE - Success.
|
 Explanation
Sets the cell properties. The properties that can be set vary depending on the cell type. For details, please refer to the explanation in Grid control.
|
reference
AddStyle
SetDefaultStyle
SetCellStyle
ClearStyle
SetCellType
SetCellProperty
GetCellProperty
SetColProperty
GetColProperty
SetRowProperty
GetRowProperty
SetColWidth
GetColWidth
SetRowHeight
GetRowHeight
SetGridLine
MergeCells
UnmergeCells
|