By default, Handsontable treats all cell values as string type. This is because <textarea>
returns a string as its value.
In many cases you will prefer cell values to be treated as number type. This allows to format
numbers nicely and sort them correctly.
To trigger the Numeric cell type, use the option type: 'numeric' in columns array
or
cells function.
Numeric cell type uses Numeral.js as the formatting library. Head over to their website to learn about the formatting syntax.
To use number formatting style valid for your language (i18n), load language definition to Numeral.js. See "Languages" section in Numeral.js docs for more info.
For more examples, head back to the main page.
Handsontable © 2012 Marcin Warpechowski and contributors.
Code and documentation
licensed under the The MIT License.