DateCalendarCellType not show Japanese character

Posted by: abcefg77789 on 16 January 2018, 1:33 pm EST

    • Post Options:
    • Link

    Posted 16 January 2018, 1:33 pm EST

    DateCalendarCellType not show Japanese character(eg. 月、火、水、木、金、。。).

    It show today with japanese character ( 今日: January 17, 2018).

    But DateTimeCellType shows japanese day correctly .

    Please kindly advice me.

  • Posted 17 January 2018, 5:41 pm EST

    Hello,

    DateCalendarCellType uses Ajax extenders and is different from DateTimeCellType. I used the following code to show the date in Japanese format:

    
     CultureInfo jpn = new CultureInfo("ja-JP");
                DateTimeFormatInfo jpnDateFormat = jpn.DateTimeFormat;
    
                FarPoint.Web.Spread.Extender.DateCalendarCellType dc = new FarPoint.Web.Spread.Extender.DateCalendarCellType();
                dc.Animated = true;
                dc.DateFormat = jpnDateFormat.ShortDatePattern;
                dc.EnableOnClient = true;
                AjaxControlToolkit.MaskedEditExtender mee = new AjaxControlToolkit.MaskedEditExtender();
                mee.Mask = "9999/99/99";
                mee.MaskType = AjaxControlToolkit.MaskedEditType.Date;
                dc.Extenders.Add(mee);
                dc.ShowEditor = true;
                FpSpread1.ActiveSheetView.Cells[0, 1].CellType = dc;
                FpSpread1.ActiveSheetView.Cells[0, 1].Value = DateTime.Now;
    
    

    It shows the date in Calendar cell as “yyyy/MM/dd”.

    Currently Spread only supports Korean and Chinese localization strings.

    Thanks,

    Deepak Sharma

Need extra support?

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

Learn More

Forum Channels