German number format not working

Getting help Issues
,
1

Hello,

I would like to set european format for numbers (comma instead dot) during first initialization of the handsontable object. I used a following code

type: 'numeric',
            numericFormat: {
                    pattern: '0,0.00',

                    culture: 'de-DE'
            },

but ist is still the . instead, and , instead .

2

Hi @dirk.rost

welcome on our forum.

It seems that your settings are correct, just like in the official demo at Numeric cell type - JavaScript Data Grid | Handsontable

50
50787×378 32.5 KB

 numericFormat: {
        pattern: '0,0.00 ,
        culture: 'de-DE', // use this for EUR (German),
        // more cultures available on http://numbrojs.com/languages.html
      }

If this doesn’t change the format please also check if you are importing the numbro file.

import numbro from 'numbro';
import deDE from 'numbro/languages/de-DE';
import 'handsontable/dist/handsontable.full.min.css';

// register the languages you need
numbro.registerLanguage(deDE);
3

Aleksandra thanks a lot.

UPS! who reading can, is clear in the benefit

wrong import:

https://handsontable.com/docs/7.4.2/components/numbro/

again, thanks a lot

cheers
Dirk

1 Like
4

You’re welcome.

Feel free to open a new thread when needed.

1 Like