You are here: Features > Action Events > Set cell value

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.

Set Cell Value Action

Cookie Notice