suspendCalcService Method

Suspends the calculation service.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(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.

Javascript

activeSheet.isPaintSuspended(true);
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.isPaintSuspended(true);
activeSheet.resumeCalcService(true);
activeSheet.isPaintSuspended(false);

Reference

Sheet type

Send comments on this topic.