PivotGrid: Add Culture support for QueryableDataProvider
Posted on:29 Mar 2017 12:08
We will consider planning this feature for some of our next official releases.
Please follow this feedback item for updates on its progress.
Posted on:27 Mar 2017 19:36
I still can't believe this isn't treated as a bug and hasn't been sorted out yet. As far as an end-user is concerned the pivot grid is displaying an incorrect date. It's only an irritating problem if you're looking at several days worth of data, because that gives you context, but in some cases we are using the grid to view data across several hours on a single day. In that instance it's just wrong because there is no way to tell that the date might be backwards during the first 12 days of the month. Please consider fixing this soon.
Posted on:07 Mar 2017 15:36
Hi Yehudah, please use the Like button on the right hand side to cast a vote for this request.
Posted on:02 Mar 2017 11:06
Posted on:15 Jul 2015 14:40
This issue doesn't appear to be limited to just month names. If I select the original field e.g. "OrderDate" and add it to the rows or columns then this appears in Invariant culture format (e.g. 09/29/2014 00:00:00). I'm hooking the QueryableDataProvider into EF6, so I added an IDbCommandInterceptor to see what is coming back from the database. The value is coming back from the database in a DateTime object, so it must be somewhere in the Telerik code that the conversion is using the invariant culture.
Additionally, when selecting the day group, e.g. "OrderDate - Day" this is currently hardcoded to "Month-Day". I think this should use CultureInfo.DateTimeFormat.MonthDayPattern, because, for example, en-gb should have this as "Day Month".