SpreadsheetGear The Performance Spreadsheet Component Company 
EvaluateRanges Method
See Also 
SpreadsheetGear Namespace > ISheet Interface : EvaluateRanges Method
formula
The formula to evaluate.
Evaluates the specified formula and returns the resulting array of ranges.

Syntax

C# 
virtual IRange[] EvaluateRanges( 
   string formula
)

Parameters

formula
The formula to evaluate.

Return Value

The result of evaluating the formula as an array of ranges.

Remarks

Multiple instances of IRange may be returned by providing a formula with comma separated (or the appropriate argument separator for the workbook set's locale) expressions.

null will be returned if the formula is invalid or does not evaluate to one or more ranges.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also