Date cell with time removed

Posted by: ashapournami on 8 September 2017, 1:18 pm EST

  • Posted 8 September 2017, 1:18 pm EST

    Hi


     My spread is getting loaded from a datatable


    I have some columns that have datetime as its celltype. Is there a way to remove the time from the cell


    I need only date and no time values.


     


    Thanks


    Asha

  • Replied 8 September 2017, 1:18 pm EST

    Asha,


    If you turn off the DataAutoCellTypes property on the Spread, then you can set up the CellTypes as you like them programatically.


    Dim d as New FarPoint.Win.Spread.CellType.DateTimeCellType
    d.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate
    FpSpread1.Sheets(0).Columns(2).CellType = d

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels