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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also