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")