SpreadsheetGear
ValidateNumber Method
See Also  Send Feedback
SpreadsheetGear.Advanced.Cells Namespace > IValues Interface : ValidateNumber Method

number
The number to validate.
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.

Syntax

Visual Basic (Declaration) 
Function ValidateNumber( _
   ByRef number As Double _
) As Boolean
C# 
bool ValidateNumber( 
   ref double number
)

Parameters

number
The number to validate.

Return Value

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 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.