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;
});

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.