FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Cell Class : Value Property |
This property gets or sets the raw unformatted data in a cell. The data handled with this property is placed directly in the data model and is not parsed or formatted.
This property is available at run time only.
The Value property may be null if the cell is empty (that is, contains no data). Before a check box cell (CheckBoxCellType) is set, it contains no data, so appears the same as unchecked.
Besides using this property, you can get or set the value in a cell using several methods available at the sheet level (with the SheetView object). For more information, see Handling Data Using Sheet Methods.
Remember that the data may be displayed differently in a cell depending on the cell type. For more information, see Understanding Cell Type Effects on Displaying Data.
Compare the values returned from the Value property with the values returned from the Text property. For example, for date-time cells, the Text property returns the formatted date and time value; the Value property returns a DateTime object.
FarPoint.Web.Spread.Cell mycell;
mycell=FpSpread1.Cells[0,0];
mycell.CellType=new FarPoint.Web.Spread.DateTimeCellType();
mycell.Value=System.DateTime.Now;
Dim mycell As FarPoint.Web.Spread.Cell mycell=FpSpread1.Cells(0,0) mycell.CellType=New FarPoint.Web.Spread.DateTimeCellType() mycell.Value=Date.Now
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional
Cell Class
Cell Members
Text Property
Handling Data Using Sheet Methods
Understanding Cell Type Effects on Displaying Data