recalcAll Method

Recalculates all the formulas in the sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.recalcAll();

function recalcAll() : any;

Example

This example uses the recalcAll method.

Javascript

activeSheet.setValue(0,0,1);
activeSheet.setValue(0,1,2);
activeSheet.setValue(0,2,10);
activeSheet.getCell(1,1).formula("=SUM(A1:C1)");
activeSheet.recalcAll();

Reference

Sheet type

Send comments on this topic.