SpreadsheetGear The Performance Spreadsheet Component Company 
Value Property
See Also 
SpreadsheetGear Namespace > IRange Interface : Value Property
Gets the value of the specified range as a System.String, System.Double, System.Boolean, SpreadsheetGear.ValueError, object[,] or null; or sets the value of the specified cell as a System.String, System.Double, System.Int32, System.Int64, System.Int16, System.Boolean, System.DateTime, SpreadsheetGear.ValueError, System.Decimal, System.DBNull, object[,] or null.

Syntax

C# 
virtual object Value {get; set;}

Remarks

An empty cell returns a value of null.

Setting Value to null or to an empty string clears the value from the cell.

Setting Value to a string has the same affect as setting Formula to the same string, the only difference being that setting Formula directly is faster.

Dates and times are stored internally as a System.Double. Setting Value to a System.DateTime converts the date and/or time to a System.Double.

The Value property returns the raw data of a cell. Use Text to get the formatted value of a cell.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also