SpreadsheetGear 2012
SetNumber Method (IValues)






Specifies the row of the cell to set.
Specifies the column of the cell to set.
Specifies the number to place into the specified cell.
Sets the value of the specified cell to the specified number and marks the workbook as needing calculation; the number is assumed to be a valid double precision floating point number.
Syntax
'Declaration
 
Sub SetNumber( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal number As System.Double _
) 
'Usage
 
Dim instance As IValues
Dim row As System.Integer
Dim column As System.Integer
Dim number As System.Double
 
instance.SetNumber(row, column, number)
void SetNumber( 
   System.int row,
   System.int column,
   System.double number
)
procedure SetNumber( 
    row: System.Integer;
    column: System.Integer;
    number: System.Double
); 
function SetNumber( 
   row : System.int,
   column : System.int,
   number : System.double
);
void SetNumber( 
   System.int row,
   System.int column,
   System.double number
) 
void SetNumber( 
   System.int row,
   System.int column,
   System.double number
) 

Parameters

row
Specifies the row of the cell to set.
column
Specifies the column of the cell to set.
number
Specifies the number to place into the specified cell.
Remarks

See the IValues overview for warnings about using this method.

See IValues.ValidateNumber for information about validating numbers before placing them in a cell.

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

See Also

Reference

IValues Interface
IValues Members
ValidateNumber Method
IsValidNumber Method
Number Property
DateTimeToNumber Method

Send Feedback