Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / FilterBarCellType Class / AutoFormat Property
Example


In This Topic
    AutoFormat Property
    In This Topic
    Gets or sets whether text is displayed with a format.
    Syntax
    'Declaration
     
    Public Property AutoFormat As Boolean
    'Usage
     
    Dim instance As FilterBarCellType
    Dim value As Boolean
     
    instance.AutoFormat = value
     
    value = instance.AutoFormat
    public bool AutoFormat {get; set;}
    Example
    This example sets the AutoFormat property.
    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;
    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
    See Also