Set Cell Value Action
Event Function: SetCellValue
The Set Cell Value action enters a specified value in a selected cell.
Using the Events tab
Under | Enter | Example |
---|---|---|
Run Skip Condition |
If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed. |
|
Cell Number |
A cell number |
cellno(C945) |
Value |
The new value of the cell |
"4530" |
Recalculate |
A yes or no decision to recalculate the document after this event is run |
"1" (for Yes) |
Syntax (if entering it in the Equation bar)
ACTION("SetCellValue", expr1, expr2, expr3)
Where
expr1 = entry under Cell Number
expr2 = entry under Value
expr3 = entry under Recalculate
How the example will appear in the Equation bar
ACTION("SetCellValue", cellno(C945), "4530","1")
NOTE: The Set Cell Value action treats the Value as a string of text rather than as an integer. To set the value of the selected cell as an integer, use the MKINT function.