We have a customer in Japan complaining that the date displayed on the Grid is not showing in the correct format.
The Short Date in Regional Options for US English OS has date with slashes like 2/9/2010. The Long Date is Tuesday, February 09, 2010. You can see this in the image below. Compare this with the image further down which is for Japanese language OS
The Short Date for Japanese OS is one with slashes and the Long Date is one with some Japanese letters, as seen in the 2nd image
When the date renders on UltraGrid in US English OS, we get the short date format i.e. the one with slashes but that date renders in Japanese OS, it seems to be using Japanese OSs long date format i.e. the one with Japanese characters.
Our customer is asking that we use the Japanese short date for format for rendering on the UltraGrid just like we are doing in US English . Of course they do not understand that this is how Infragistics Grid is rendering.
I am wondering if this a defect. Hopefully there is some Grid setting that would let me do this and I do not have to write masks etc.
Next two images show how date formats as rendered on Grid in US English OS and Japanese OS.
Japanese OS
while in US English OS:
Hi,
We were able to duplicate this behavior and I have forwarded this thread over to Infragistics Developer support so they can look into it.
My guess is that this is not the grid doing this. When you don't specify a Format on the column, the grid just calls the ToString method on the value. So using the long date format is probably the default on the Japanese OS.But just in case I am wrong, we will check it out.
In the mean time, you can set the Format on the column to "d" to force it to always use the short date format.
Thanks Mike! I am awaiting to hear from Infragistics.
I understand that "d" format results in 2/12/2010 instead of 02/12/2010 for US English i.e the 0 padding is missing. The default US English that is rendered on UltraGrid provides the 0 padding and we do not want to lose that padding.
I am interested what you find out about how the formatting is done in Japanese OS.
Appreciate your help!
Perhaps there's another format that includes the padding that you could use?
Date and Time Format Strings
Hi Mike,
You had said
Did you hear from them?
In the meantime, the same Japanese customer is complaining that the date in Japanese gets truncated on the calendar. See image below. Another possible defect?
vrn said: You had said We were able to duplicate this behavior and I have forwarded this thread over to Infragistics Developer support so they can look into it. Did you hear from them?
Yes, my understanding is that they wrote this up for developer review. You should have received some sort of notification about that. I will ping them again and make sure they send you an e-mail to let you know what's going on.
vrn said:In the meantime, the same Japanese customer is complaining that the date in Japanese gets truncated on the calendar. See image below. Another possible defect?
Possibly... but that calendar you are seeing here is the Microsoft MonthCalendar control. So we don't have any control over that and if this is a bug, it's likely a bug in their control. You can try putting the MonthCalendar control on a form to see if you get the same results.
If that's the case, then the thing to do would be to use the UltraCalendarCombo control and set it as the EditorControl on the column. That UltraCalendarCombo is a nicer UI and does not use the MonthCalendar.