IsValidNumber Method

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

[Visual Basic]
Overridable Function IsValidNumber( _
   ByVal number As Double _
) As Boolean

[C#]
virtual bool IsValidNumber( 
   double number
);

[C++]
virtual bool IsValidNumber( 
   double number
) 

[C++/CLI]
virtual bool IsValidNumber( 
   double number
) 

Parameters

number

The number to validate.

Return Type

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

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IValues Interface  | IValues Members  | SetNumber Method  | ValidateNumber Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.