Spread.Sheets Documentation
rangeToFormula Method
GC.Spread.Sheets Namespace > CalcEngine type : rangeToFormula 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 = GC.Spread.Sheets.CalcEngine.rangeToFormula(range, baseRow, baseCol, rangeReferenceRelative, useR1C1);
function rangeToFormula( 
   range : Range,
   baseRow : number,
   baseCol : number,
   rangeReferenceRelative : GC.Spread.CalcEngine.RangeReferenceRelative,
   useR1C1 : boolean
) : string;

Parameters

range
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

CalcEngine type

 

 

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.