date time cell format c#

Posted by: spreadmember on 8 September 2017, 1:22 pm EST

  • Posted 8 September 2017, 1:22 pm EST

    using spread 3.0 component model and c# language
    reg : customisation of date in the datetimecelltype
    i want to customise the date time field as 24 hour format without AM/PM
    like eg: 23:59 (or) 01:59
     and i want to enter only hour and min in that cell format


     


     

  • Replied 8 September 2017, 1:22 pm EST

    You should be able to format the cell type...

    FarPoint.Win.Spread.CellType.DateTimeCellType dt = new FarPoint.Win.Spread.CellType.DateTimeCellType();
    dt.DateTimeFormat FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
    dt.UserDefinedFormat "HH:mm";

     

Need extra support?

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

Learn More

Forum Channels