IsDateFormat Property (GeneralCellType)

Gets or sets whether the format string being used is a date-time format string.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property IsDateFormat As Boolean

'Usage
 
Dim instance As GeneralCellType
Dim value As Boolean
 
instance.IsDateFormat = value
 
value = instance.IsDateFormat

public virtual bool IsDateFormat {get; set;}

Property Value

True if the GeneralFormatter class's SetFormatString method was called with the isDateFormat parameter set to true; false otherwise
true if date-time; false otherwise

Example

System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.LongDatePattern = "D";
dtf.ShortDatePattern = "M/d/yyyy";
FarPoint.Web.Spread.GeneralCellType g = new FarPoint.Web.Spread.GeneralCellType();
g.DateTimeFormat = dtf;
g.FormatString = dtf.ShortDatePattern
g.IsDateFormat = true;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = g;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;

Visual Basic

Dim dtf As New System.Globalization.DateTimeFormatInfo
Dim b As Boolean
dtf.LongDatePattern = "D"
dtf.ShortDatePattern = "M/d/yyyy"
Dim g As New FarPoint.Web.Spread.GeneralCellType
g.DateTimeFormat = dtf
g.FormatString = dtf.ShortDatePattern
g.IsDateFormat = True
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = g
FpSpread1.ActiveSheetView.Cells(0, 0).Value = DateTime.Now

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GeneralCellType Class
GeneralCellType Members
SetFormatString Method