Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1280
UltraGrid valuelist with Datetime
posted

Hello, I have a grid cell formatted as combobox, displaying Valid values through a ValueList. Values are datetime, e.g.

"12/25/2018" for xmas and /07/04/2018" for 4th of July. Everything works good as long as I keep en-US locale: selection of first is parsed as Dec25, selection of second is parsed as 4th of July.

When I switch to another format and I display values according to locale (MM/dd/yyyy): selection of first still results in Dec 25th, while selection of second results in 7th of April.

Things get worse when I use keys for the valid values. 

If I map first as "xmas" and second as "4th July" I get a CellData error exception. 

How can I instruct the grid cell to parse selection according  to the locale? and using keys too?

Thanks in advance for any help you can provide