Only allow float numbers in my cell input without using spreadsheet validation

[Joao Pedro]

Hello.

I have 130k+ cells in my spreadsheet and if I load all those cells with validation my grid takes a lot longer to load. (Something around 8-12 seconds), so I decided to not use validation. 

 

Is there any other way to only allow float numbers in my cells? I'm down to use an 'on-change' trick or something like that.

 

 

Thank you

[Veselin Tsvetanov]

Hi Joao,

Using the change event of the Spreadsheet may not be the most appropriate option for the described scenario, as it does not allow prevention of the changes made. Nevertheless, I could suggest you to use the select event instead and if it is needed, apply the validation run-time on the selected cell (range):

$("#spreadsheet").kendoSpreadsheet({

  select: function(e) {
      // Check here if validation should be applied

    if (true) {

      e.range.validation({

        dataType: "number",

        comparerType: "between",

        from: 0,

        to: 1000,

        allowNulls: true,

        type: "reject",

        messageTemplate: "The value should be a number."

      });

    }

  }

});

Regards,
Veselin Tsvetanov
Progress Telerik