SpreadsheetGear 2010
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 SpreadsheetGear.IRange.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

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

See Also

Copyright © 2003-2010 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.