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.
Forums Home / Spread / Spread for ASP.NET (Web Forms)
Posted by: abcefg77789 on 16 January 2018, 1:33 pm EST
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