See Also

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

See Also SpreadsheetGear The Performance Spreadsheet Component Company 

IValues Interface Members

SpreadsheetGear.Advanced.Cells Namespace : IValues Interface

IValues overview

Public Properties

 Property Item Returns the IValue representing the value type, value and formula of the specified cell, or null if the cell does not have a value.

Public Methods

 Method Clear Clears the value in the specified cell if one currently exists.
 Method IsValidNumber Returns true if the specified number is a valid cell number, otherwise false is returned.
 Method SetError Sets the value of the specified cell to the specified error value.
 Method SetFormula Overloaded.  
 Method SetLogical Sets the value of the specified cell to the specified logical value.
 Method SetNumber 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.
 Method SetText Overloaded.  
 Method ValidateNumber 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.

See Also

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

 

 


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.