How to set locale for view and edit of cells

Getting help Questions
1

I am using Handsontable to display numerical values. The data is held in a $scope variable. Depending on the users settings I would now like to change the locale of the table. So an american user should see numbers like 123.45 and german users will see them as 123,45. Also when editing the cell as a german user I would like to enter “321,00” to set the variable to 321.00.

I tried to set (as an example for german locale)

language = “de”

but unfortunately this did not work. Instead of several columns only one column was shown.

So I hope you can give me a hint.

thank you very much,
Michael

2

Sorry for a delay @mgerbracht

I’ll check it and be back with any news.

3

Hi again @mgerbracht

Here is a demo that should help you http://jsfiddle.net/zt9pfsg3/

Let me know if it meets your project requirements.

4

Hi Aleksandra,

Yes, thank you very much. I think setting the language to ‘de-DE’ instead of ‘de’ did the trick. I think you should update the following documentation:

http://docs.handsontable.com/0.16.1/demo-numeric.html

Thanks for your solution!
Michael

5

@mgerbracht the version of docs you were checking is 0.16.0 while we’re already at 0.32.0 where the docs are correct

6

Oh, ok sorry, I think I went there following a google link and didn’t see there is a newer version.

7

That’s OK. I am happy that the issue got solved. I am closing this topic.