onChange: prevent certain input

[harrygates]

How would I go about allowing only numbers to be input? I tried the following in the onChange event, but I'm not sure how to call the line: "this.editproxy.finishEditing(true);" or if there is maybe a better way.

handsontable is awesome and I'd like to thank you for creating such a lightweight javascript spreadsheet!

onChange: function (data) {
if (first) {
first = false;
return;
}
$("#dataTable-console").text(JSON.stringify(data));
var newValue = data[0][3];
if(isNaN(newValue)) {
alert("only numbers allowed!");
alert(data[0][0] + '\t' + data[0][1] + '\t' + data[0][2]);
this.editproxy.finishEditing(true);
}
}

[harrygates]

I was able to achieve the desired result using the following:

onChange: function (data) {
if (first) {
first = false;
return;
}
$("#dataTable-console").text(JSON.stringify(data));
var newValue = data[0][3];
alert(newValue);
if(isNaN(newValue)) {
alert("only numbers allowed!");
alert(data[0][0] + '\t' + data[0][1] + '\t' + data[0][2]);
$("#dataTable").handsontable("setDataAtCell",data[0][0], data[0][1], data[0][2]);
}
}
});

[harrygates]

The latest code changes seems to have broken the "setDataAtCell" method above. The data remains what was entered, even with text.

[warpech]

You are right gatesh, thanks for noticing. I submitted a fix. Please check again

[harrygates]

Thanks, warpech! Works great now.