Hallo,
we use the recent release version 14.1 of jquery igniteui controls and we have regional issues (again :( ).
We use the loader, set locale and regional to 'de'. Localization is working, but regionalization is not, We have datatype: number columns and iggrid is displaying the numbers with US decimalSeparators ('.') instead of german decimalSeparators(',').
I have no idea what's wrong. This is a critical issue for our development and we invested a lot of time to implement the grid into our software, so please help us fix this issue.
Here a Screenshot and a code example.
They seem to have the same/similar issue: http://www.infragistics.com/community/forums/p/89478/442236.aspx
kind regards.
it seems that regional decimalseparator setting is only working, if you set a e.g. format: "0.00" for the number column. that's a bad solution.
Using the summary, the calculation is wrong if format: "0.00" is used! Critical bug. See: http://jsfiddle.net/maxschaf/xBMDs/1
Screenshot
if I set isGridFormatter:false on Summary columnSettings, the calculation is correct but decimalSeparator is wrong. See: http://jsfiddle.net/maxschaf/67WXc/
if i do not set columnSettings in summaries feature, it's calculating wrong and setting decimalseparator wrong. See http://jsfiddle.net/maxschaf/4Vb9d/1/
that's a mess, please help us and fix it!
Hello,
By default the grid will try to format only date columns automatically. To enable auto formatting of number columns as well you should set the autoFormat grid option to "dateandnumber". Please refer to the API docs for more information.
Thank you for using Infragistics forums!
Best regards,
Stamen Stoychev
omg, setting this options activates regional replacement. thanks. there are some blogpostings about igloader, telling how to "activate" regional settings, but noone ever mentions setting this property on the control.
regarding my second post, this is still bad behavior and should be considered by your developers.
Can you clarify and be more specific, what do you mean by bad behavior?
- loader loaded DE regional settings, autoFormat is implicitly set to date -> number should not be formated by region setting.
If you don't set an e.g. format: "number" it is not formatted as expected, but if you set the format property, it is applying the regional setting on this column, but uiGridSummaries is not applying it.
use my screenshots and code examples and think it through.