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 SpreadsheetGear.IRange.Formula to the same string, the only difference being that setting SpreadsheetGear.IRange.Formula directly is faster. See SpreadsheetGear.IRange.Formula for more information on the parsing of string values to numbers, dates, times, errors, logical values and text.

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. Use IWorkbook.DateTimeToNumber and IWorkbook.NumberToDateTime to convert from a System.DateTime to a number suitable for a cell and back.

The Value property returns the raw data of a cell. Use SpreadsheetGear.IRange.Formula to get the formula of a cell or use SpreadsheetGear.IRange.Text to get the formatted value of a cell.

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

Reference