SpreadsheetGear 2012
IArguments Interface Members
Properties  Methods 

The following tables list the members exposed by IArguments.

Public Properties
 NameDescription
 PropertyCountReturns the number of arguments to the custom function.  
 PropertyCurrentColumnReturns the column of the cell which is currently being calculated.  
 PropertyCurrentFormulaReturns the formula of the cell which is currently being evaluated, or null if no cell is currently being evaluated.  
 PropertyCurrentFunctionNameReturns the name of the function which is currently being evaluated.  
 PropertyCurrentRowReturns the row of the cell which is currently being calculated.  
 PropertyCurrentWorksheetReturns the worksheet of the cell which is currently being calculated. The Function.Evaluate method precludes the use of any API on this worksheet except for the Name, Index and Workbook.Name properties.  
 PropertyItemReturns the argument specified by the zero based index. Note that this indexer has the side effect of converting a range or array to a single value.  
Top
Public Methods
 NameDescription
 MethodClearErrorClears errors associated with the custom function which is currently being evaluated.  
 MethodGetArrayDimensionsReturns the dimensions, consisting of the number of rows and columns, of the specified argument.  
 MethodGetArrayFormulaInfoReturns 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.  
 MethodGetArrayValueReturns the specified value.  
 MethodGetLogicalReturns the argument specified by the zero based index as a logical (boolean) value. Note that this method has the side effect of converting a range or array to a single value.  
 MethodGetNumberReturns the argument specified by the zero based index as a double precision floating point number. Note that this method has the side effect of converting a range or array to a single value.  
 MethodGetTextReturns the argument specified by the zero based index as a string. Note that this method has the side effect of converting a range or array to a single value.  
Top
See Also

Reference

IArguments Interface
SpreadsheetGear.CustomFunctions Namespace

Send Feedback