Paste numbers in handsontable

Tags: #<Tag:0x00007f8b1d8fe7d8>
#1

Hello,
Can you please tell me if it is possible to configure handsontable so that when inserting from the buffer into the handsontable, number with a space = “123 123”, so that handsontable understands that this is a number.
By default when inserting number with space, it perceives it as a string, but if you insert a number without a space, it perceives its number

#2

Hi @dmitry.yudin95

you can use the beforeValidate hook to allow spaces in the numeric cell type. Here’s an example https://jsfiddle.net/pnsmqtzd/

#3

Ok thank you
I want to clarify more
for example, numbers are copied from Excel, which can be in various formats, for example - 123,123,123.51 or 2 581,65.
is there any general mechanism in the hansontable that would understand different formats and understand the number or not? So as not to program this logic ourselves

#4

Quoting our tutorial from https://handsontable.com/docs/8.1.0/demo-numeric.html

You can input float-typed values in the numeric editor only using a dot or a comma as a decimal separator. For example, both 500000.5 , 500000,5 will be accepted.

Anything more than that requires extra logic within the cell validator.

#5