CellOnClick
CellOnClick( expr )
A cell format predicate that specifies an expression to be evaluated when a user double-clicks on a table cell (for example in a result table). This can be configured from within a computed cell format in the Cell Format Expression attribute. The expression «expr» is allowed to have side-effects, such as assignments to global variables, in the same way an OnClick or OnChange expression can.
Use this function when you want to enable do some custom action when a user double-clicks on a particular cell in a result table. This behaves similarly to having a Button inside a table.
Examples
With the following Cell Format Expression, when the user double-clicks on any cell in the I='b'
row of the result table, the user interface will open the influence diagram for the module Mo1
.
If I='b' Then CellOnClick( ShowWindow( Handle(Mo1), 'Diagram' ) )
When the user clicks on any cell in the table, a message box shows the value at full precision.
CellOnClick( MsgBox( NumberToText(Self,fullPrecision:true) ) )
Enable comment auto-refresher