IgnoresValues Method

Determines whether the function ignores cells values passed to the specified argument.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Function IgnoresValues( _
   ByVal i As Integer _
) As Boolean

'Usage
 
Dim instance As FunctionInfo
Dim i As Integer
Dim value As Boolean
 
value = instance.IgnoresValues(i)

public virtual bool IgnoresValues( 
   int i
)

Parameters

i: Index of the argument

Return Value

Boolean: true if the function ignores the values ; false if it uses and does not ignore the values

Remarks

This method is used by the COLUMN, COLUMNS, ROW, and ROWS functions to indicate that values in an cell/range reference are not used (that is, only the indices of the cell reference or range reference is used). This method allows the spreadsheet to ignore circular references created by calls to the COLUMN, COLUMNS, ROW, ROWS functions.

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FunctionInfo Class
FunctionInfo Members