Spread.Sheets Documentation
suspendCalcService Method
GC.Spread.Sheets Namespace > Worksheet type : suspendCalcService Method
Specifies whether to invalidate the dependency cells.
Suspends the calculation service.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.suspendCalcService(ignoreDirty);
function suspendCalcService( 
   ignoreDirty : boolean
) : any;

Parameters

ignoreDirty
Specifies whether to invalidate the dependency cells.
Example
This example uses the suspendCalcService method.
activeSheet.suspendCalcService(false);
activeSheet.setValue(0,0,1);
activeSheet.setValue(0,1,2);
activeSheet.setValue(0,2,10);
activeSheet.getCell(1,1).formula("=SUM(A1:C1)");
activeSheet.resumeCalcService(true);
See Also

Reference

Worksheet type