Spread.Sheets Documentation
recalcAll Method
Specifies whether to rebuild all fromula reference, custom name and custom functions.
Recalculates all the formulas in the sheet.
Syntax
var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.recalcAll(refreshAll);
function recalcAll( 
   refreshAll : boolean
) : any;

Parameters

refreshAll
Specifies whether to rebuild all fromula reference, custom name and custom functions.
Example
This example uses the recalcAll method.
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();
See Also

Reference

Worksheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.