Text Validation Not working

[Adel Chenni]

If you use the below - r is not passing the valid state

    $("#spreadsheet").kendoSpreadsheet();

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");

    var sheet = spreadsheet.activeSheet();

    sheet.range("A1").value("r");
    sheet.range("A1").validation({
        from: "r",
        comparerType: "equalTo",
        dataType: "text",
        messageTemplate: "Not Valid."
    });

[Stefan]

Hello Adel,

Thank you for your report. I confirm this is an issue with the present version of the Kendo UI Spreadsheet.  I have forwarded your report to our developers for fixing. In addition, I have updated your Telerik points for bringing the problem to our attention.

Regards,
Stefan
Telerik

 

[Veselin Tsvetanov]

Hello Adel,

I would like to update you on the current state of this case.

As we support both formulas and references for the from and to properties, the specified values are always parsed as functions. In order parsing to successfully recognize text value, you will need to double wrap this value in quotes. Therefore, changing the validation rule in the following way should solve the issue observed:

sheet.range("A1").validation({
    from: JSON.stringify("r"),
    comparerType: "equalTo",
    dataType: "text",
    messageTemplate: "Not valid."
});

Regards,
Veselin Tsvetanov
Telerik by Progress