onBeforeConditionSet

fires before a new condition for cells is 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 setting the new condition

Example

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

Details

The event is not called for pasting copied data. Use onBeforePaste instead.

See also
Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.