Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property AutoFormat As Boolean | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FilterBarCellType Dim value As Boolean instance.AutoFormat = value value = instance.AutoFormat | |
| C# | |
|---|---|
public bool AutoFormat {get; set;} | |
Example
This example sets the AutoFormat property.
| C# | Copy Code |
|---|---|
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo(); dtf.LongDatePattern = "D"; dtf.ShortDatePattern = "M/d/yyyy"; FarPoint.Win.Spread.CellType.FilterBarCellType fbcell = new FarPoint.Win.Spread.CellType.FilterBarCellType(); fbcell.AutoFormat = true; fbcell.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime; fbcell.DateTimeFormatInfo = dtf; fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar; fpSpread1.Sheets[0].FilterBar.Cells[0].CellType = fbcell; fpSpread1.Sheets[0].Cells[0, 0].Value = DateTime.Now; | |
| VB.NET | Copy Code |
|---|---|
Dim dtf As New System.Globalization.DateTimeFormatInfo dtf.LongDatePattern = "D" dtf.ShortDatePattern = "M/d/yyyy" Dim fbcell As New FarPoint.Win.Spread.CellType.FilterBarCellType() fbcell.AutoFormat = True fbcell.ContextMenuType = FarPoint.Win.Spread.CellType.FilterBarContextMenuType.DateTime fbcell.DateTimeFormatInfo = dtf FpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar FpSpread1.Sheets(0).FilterBar.Cells(0).CellType = fbcell FpSpread1.Sheets(0).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