onBeforeConditionSet
fires before a new condition for cells has been set
boolean onBeforeConditionSet(number row,number column,array oldCondition,array newCondition, [string page] );
| row | number | the ID of the row |
| column | number | the ID of the column |
| oldCondition | array | the old condition for cells |
| newCondition | array | the new condition for cells |
| page | string | the name of the sheet |
| boolean | returning 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