Wrong sum in cell with non-US number format

Getting help Questions
1

Hi,

I have strange issue: I am using pro version of handsontable with formulas plugin. I have some number columns where I set custom number format like this:

numericFormat: {
pattern: ‘0,0.0’,
culture: ‘de-DE’,
thousandSeparated: true
}

In sum row, calculation is wrong when we enter number with comma as decimal separator:

MicrosoftTeams-image.png668×326 31.3 KB

When we enter number with dot as decimal separator, sum is correct.

Any ideas?

BR
Marko

2

Hi
Any update regarding this issue?

3

Sorry for keeping you waiting @bestellungen

Did you rerender the table? As I believe your data has a 0,0 format.

4

Hi Aleksandra,

In meantime I got a suggestion from your colleague Chris to use summary plugin instead.

He sent me following example: http://jsfiddle.net/u9pm62sb/

I am testing it now, if it works as it should, then I will remove formulas completely.

Best regards
Marko

5

Great to know. Please let me know if you’d need anything else.

6

Hi Aleksandra,

How do you mean to rerender the table?

I am afraid that proposed solution is not good for us, because it will affect a lot of already implemented functionality.

7

Hi Marko,

I have just send you an email with a reply on this subject. Can we continue the conversation on emails?

8

Conversation continued on emails.