Date cell with time removed

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

  • Posted 8 September 2017, 1:18 pm EST


     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.




  • Replied 8 September 2017, 1:18 pm EST


    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
    <FONT size=2>d.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate </FONT>
    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