Spread Windows Forms 7.0 Product Documentation
IsDateFormat Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > GeneralCellType Class : IsDateFormat Property


Glossary Item Box

Gets or sets whether the format string should be interpreted as a date-time format (true) or a number format (false).

Syntax

Visual Basic (Declaration) 
Public 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 bool IsDateFormat {get; set;}

Property Value

Boolean: true if the value should be treated as a date-time value; false otherwise

Example

This example specifies the format string used to format the date value.

C#Copy Code
FarPoint.Win.Spread.CellType.GeneralCellType genlcell = new FarPoint.Win.Spread.CellType.GeneralCellType();
System.Globalization.DateTimeFormatInfo dtinfo; 
dtinfo = System.Globalization.DateTimeFormatInfo.CurrentInfo;
genlcell.DateTimeFormat = dtinfo;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = genlcell;
fpSpread1.ActiveSheet.Cells[0, 0].Value = DateTime.Now;
Visual BasicCopy Code
Dim genlcell As New FarPoint.Win.Spread.CellType.GeneralCellType()
Dim dtinfo As New System.Globalization.DateTimeFormatInfo()
genlcell.DateTimeFormat = dtinfo.CurrentInfo
FpSpread1.ActiveSheet.Cells(0, 0).CellType = genlcell
FpSpread1.ActiveSheet.Cells(0, 0).Value = DateTime.Now

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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