onBeforeConditionSet

fires before a new condition for cells has been set

boolean onBeforeConditionSet(number row,number column,array oldCondition,array newCondition, [string page] );
rownumberthe ID of the row
columnnumberthe ID of the column
oldConditionarraythe old condition for cells
newConditionarraythe new condition for cells
pagestringthe name of the sheet
booleanreturning false will prevent the new condition setting

Example

$$("spsheet1").attachEvent("onBeforeConditionSet",function(row,col,oCond,nCond,page){
    // handler code here
    return true;
});

See also
Back to top