[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

FarPoint.Win.Spread.ModelessForm.GetFormula

GetFormula Method

GetFormula(SheetView, CellRange)

Gets the formula string of a sheet cell range.

Declaration
protected string GetFormula(SheetView sheetView, CellRange cellRange)
Protected Function GetFormula(sheetView As SheetView, cellRange As CellRange) As String
Parameters
Type Name Description
SheetView sheetView

The sheet view.
CellRange cellRange

The cell range.
Returns
Type Description
string

A formula string.

GetFormula(SheetCellRange[], bool)

Gets the formula string of multiple sheet cell ranges.

Declaration
protected string GetFormula(SheetCellRange[] cellRanges, bool useOpeningQuote)
Protected Function GetFormula(cellRanges As SheetCellRange(), useOpeningQuote As Boolean) As String
Parameters
Type Name Description
SheetCellRange[] cellRanges

The cell ranges.
bool useOpeningQuote

if set to true [use opening quote].
Returns
Type Description
string

A formula string.