ValidateNumber Method

Returns true if the specified number is a valid number; converts numbers suffering from underflow to +0.0; returns false if the number cannot be validated.

[Visual Basic]
Overridable Function ValidateNumber( _
   ByRef number As Double _
) As Boolean

[C#]
virtual bool ValidateNumber( 
   ref double number
);

[C++]
virtual bool ValidateNumber( 
   ref double number
) 

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

Parameters

number

The number to validate.

Return Type

true if the number is valid, false otherwise.

Remarks

Unlike Value, SetNumber assumes the number being placed in a cell is a valid number. A valid number is either +0.0, or a non-zero number which is not suffering from underflow or overflow. If number is suffering from underflow or is equal to -0.0, it will be set to +0.0 and true will be returned. If the number cannot be validated, false is returned.

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  | IsValidNumber 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.