onBeforeFormatChange

fires before cell format is changed

boolean onBeforeFormatChange(number row,number column,string format,string oldFormat, [string page] );
rownumberrow ID
columnnumbercolumn ID
formatstringnew format of the cell
oldFormatstringold format of the cell
pagestringthe name of the sheet
booleanreturning false will prevent format changing

Example

$$("ssheet1").attachEvent("onBeforeFormatChange",function(row,col,format,oldF,page){
    // handler code here
    return true;
});

See also
Back to top