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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FunctionInfo Class
FunctionInfo Members