SpreadsheetGear
GetArrayFormulaInfo Method
See Also  Send Feedback
SpreadsheetGear.CustomFunctions Namespace > IArguments Interface : GetArrayFormulaInfo Method

row1
Will be set to the zero based upper row of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
col1
Will be set to the zero based left column of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
row2
Will be set to the zero based lower row of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
col2
Will be set to the zero based right column of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
Returns true and sets row1, col1, row2 and col2 to the zero based upper-left and lower-right row and column indexes of the array formula if the formula currently being evaluated is an array formula, or returns false and leaves the parameters unchanged if the formula currently being evaluated is not an array formula.

Syntax

Visual Basic (Declaration) 
Function GetArrayFormulaInfo( _
   ByRef row1 As Integer, _
   ByRef col1 As Integer, _
   ByRef row2 As Integer, _
   ByRef col2 As Integer _
) As Boolean
C# 
bool GetArrayFormulaInfo( 
   ref int row1,
   ref int col1,
   ref int row2,
   ref int col2
)

Parameters

row1
Will be set to the zero based upper row of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
col1
Will be set to the zero based left column of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
row2
Will be set to the zero based lower row of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.
col2
Will be set to the zero based right column of the array formula currently being evaluated, or left unchanged if the formula currently being evaluated is not an array formula.

Return Value

true if the formula currently being evaluated is an array formula, or false if the formula currently being evaluated is not an array formula.

Requirements

Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.