| Action | FormatCell
Format
|
| Description | Shows the row, column or cell format dialog.
|
| Examples | with Cube1
.row = 2
.col = 5
if doAction("Format") then
msgBox "Successful"
end if
end with
with Cube1
.row = 8
.col = 5
if doAction("FormatCell") then
msgBox "Successful"
end if
end with
|
| Example Explanation | Chooses row 2 and column 5 and call the format row or format column dialog. Depending on the row and column coordinates, the row or the column will be
formatted.
Afterwards formats cell(8, 5)
|
| See also | You can add elements manually using the SetValue("HiddenElementsNum") and SetValue("HiddenElement") functions.
|
| Notes | Depending on your row and column
parameters, distinct elements will be show in the dialog.
Choose an x axis dimension element to format a column and a y axis element to format a row using the Format action
Choosing cells with data, will only work with the FormatCell action.
|