IsValidNumber Method (IValues)

Returns true if the specified number is a valid cell number, otherwise false is returned.

Syntax

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
Function IsValidNumber( _
   ByVal number As System.Double _
) As System.Boolean

'Usage
 
Dim instance As IValues
Dim number As System.Double
Dim value As System.Boolean
 
value = instance.IsValidNumber(number)

System.bool IsValidNumber( 
   System.double number
)

function IsValidNumber( 
    number: System.Double
): System.Boolean;

function IsValidNumber( 
   number : System.double
) : System.boolean;

System.bool IsValidNumber( 
   System.double number
)

System.bool IsValidNumber( 
   System.double number
)

Parameters

number: The number to validate.

Return Value

true if the number is a valid cell number, false otherwise.

Remarks

Unlike Value, SetNumber assumes the number being placed in a cell is a valid cell number. A valid cell number is either zero, or a non-zero number which is not suffering from underflow or overflow. Positive infinity, negative infinity and NaN are not valid cell numbers.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IValues Interface
IValues Members
SetNumber Method
ValidateNumber Method