SpreadsheetGear 2010
IArguments Interface Members
See Also  Properties  Methods  Send Feedback
SpreadsheetGear.CustomFunctions Namespace : IArguments Interface


The following tables list the members exposed by IArguments.

Public Properties

 NameDescription
 PropertyCountReturns the number of arguments to the custom function.  
 PropertyCurrentColumn Returns the column of the cell which is currently being calculated.  
 PropertyCurrentFormula Returns the formula of the cell which is currently being evaluated, or null if no cell is currently being evaluated.  
 PropertyCurrentFunctionName Returns the name of the function which is currently being evaluated.  
 PropertyCurrentRow Returns 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.  
 PropertyItem Returns 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
 MethodClearError Clears errors associated with the custom function which is currently being evaluated.  
 MethodGetArrayDimensions Returns the dimensions, consisting of the number of rows and columns, of the specified argument.  
 MethodGetArrayFormulaInfo 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.  
 MethodGetArrayValueReturns the specified value.  
 MethodGetLogical Returns 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.  
 MethodGetNumber Returns 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.  
 MethodGetText Returns 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

Copyright © 2003-2010 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.