SpreadsheetGear 2012
IValues Interface Members
Properties  Methods 

The following tables list the members exposed by IValues.

Public Properties
 NameDescription
 PropertyItemReturns the IValue representing the value type, value and formula of the specified cell, or null if the cell does not have a value.  
Top
Public Methods
 NameDescription
 MethodClearClears the value in the specified cell if one currently exists.  
 MethodForEachNumber  
 MethodIsValidNumberReturns true if the specified number is a valid cell number, otherwise false is returned.  
 MethodSetErrorSets the value of the specified cell to the specified error value.  
 MethodSetFormulaOverloaded. Sets the specified cell to the specified formula.  
 MethodSetLogicalSets the value of the specified cell to the specified logical value.  
 MethodSetNumberSets 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.  
 MethodSetTextOverloaded. Sets the value of the specified cell to the specified text.  
 MethodValidateNumberReturns 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.  
Top
See Also

Reference

IValues Interface
SpreadsheetGear.Advanced.Cells Namespace
IValues Interface
ValueType Enumeration

Send Feedback