Spread for ASP.NET 7.0 Product Documentation
IsDateFormat Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > GeneralCellType Class : IsDateFormat Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Overridable Property IsDateFormat As Boolean
Visual Basic (Usage)Copy Code
Dim instance As GeneralCellType
Dim value As Boolean
 
instance.IsDateFormat = value
 
value = instance.IsDateFormat
C# 
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

C#Copy Code
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 BasicCopy Code
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.