Set Cell Calculation Action

Event Function: SetCellCalculation

The Set Cell Calculation action enters a specified calculation 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(C763)

Calculation

The calculation to insert in the cell

map("BA", "533")

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("SetCellCalculation", expr1, expr2, expr3)

Where

expr1 = entry under Cell Number

expr2 = entry under Calculation

expr3 = entry under Recalculate

How the example will appear in the Equation bar

ACTION("SetCellCalculation", cellno(C763), map("BA", "533"),"1")

Related Topics