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...

    <div class="code"><font color="black">FarPoint.Win.Spread.CellType.DateTimeCellType dt </font><font color="blue">= new </font><font color="black">FarPoint.Win.Spread.CellType.DateTimeCellType()</font><font color="blue">;
    </font><font color="black">dt.DateTimeFormat </font><font color="blue">= </font><font color="black">FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined</font><font color="blue">;
    </font><font color="black">dt.UserDefinedFormat </font><font color="blue">= </font><font color="#808080">"HH:mm"</font><font color="blue">;


Need extra support?

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

Learn More

Forum Channels