Table of Contents

TUserDefinedFunction.TryGetCellRange Method

Tries to retrieve a cell range from a parameter, and return it if it can be converted or an error if not.

Syntax

Unit: FlexCel.Core

class function TUserDefinedFunction.TryGetCellRange(const param: TFormulaValue; out ResultValue: TXls3DRange; out ResultError: TFlxFormulaErrorValue): Boolean; static;

Parameters

<-> Parameter Type Description
const param TFormulaValue One of the parameters passed to Evaluate
out ResultValue TXls3DRange Value of the parameter as a TXls3DRange. If TryGetRange returns false, this value is undefined.
out ResultError TFlxFormulaError​Value Value of the error when converting the parameter. If TryGetCellRange returns true (there was no error), this value is undefined.

Returns

True if the parameter can be converted to a cell range, false if there was an error.

See also