SpreadJS Documentation
rangesToFormula Method
GcSpread.Sheets Namespace > Calc type : rangesToFormula Method
The cell range in the sheet.
The base row index of the formula.
The base column index of the formula.
Whether the range reference is relative or absolute.
Whether to use the R1C1 reference style.
Converts the specified cell range to a formula string.
Syntax
var value; // Type: string
value = GcSpread.Sheets.Calc.rangesToFormula(ranges, baseRow, baseCol, rangeReferenceRelative, useR1C1);

function rangesToFormula( 
   ranges : Range,
   baseRow : number,
   baseCol : number,
   rangeReferenceRelative : RangeReferenceRelative,
   useR1C1 : boolean
) : string;

Parameters

ranges
The cell range in the sheet.
baseRow
The base row index of the formula.
baseCol
The base column index of the formula.
rangeReferenceRelative
Whether the range reference is relative or absolute.
useR1C1
Whether to use the R1C1 reference style.

Return Value

The formula string that refers to the specified cell range.
See Also

Reference

Calc type

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.