suspendCalcService Method

Suspends the calculation service.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Spread(host, options);
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

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

Reference

Spread type

Send comments on this topic.