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.

Related Topics