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 .
Hi @dirk.rost
welcome on our forum.
It seems that your settings are correct, just like in the official demo at https://handsontable.com/docs/javascript-data-grid/numeric-cell-type/
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);
Aleksandra thanks a lot.
UPS! who reading can, is clear in the benefit
wrong import:
again, thanks a lot
cheers
Dirk
You’re welcome.
Feel free to open a new thread when needed.