Spreadsheet - Data validation - export to JSON

2 posts, 0 answers
  1. Maciej
    Maciej avatar
    1 posts
    Member since:
    Jan 2011

    Posted 25 May 2016 Link to this post


    I am using the asp.mvc spreadsheet control and I like it very much. It saved me lot of time. I have a small question regarding the data validation.


    1. I set the row and column headers.(Row 1, Column A)

    2. Range B2:Z10 is used for data cells - user will provide decimal values here

    3. I style the sheet, header cells differ from data cells.

    3. For all data cells I set the validation: (From menu I choose Data validation - Criteria: Number, Comparer: greater than, Min:0,)

    4. I save the sheet as Json and store it in the database.

    5. I recreate the spreadsheet from JSON and ask user to fill the data cells(B2:Z10) - Headers and values are set properly, colors too but validation is missing.


    Could you advice me how should I proceed so data cells will be check with validation and user will be forced to put decimal values greater that 0? The step where I store the JSON in the database is obligatory.


    Thank you for your quick response.

  2. Stefan
    Stefan avatar
    346 posts

    Posted 27 May 2016 Link to this post

    Hello Maciej,

    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.

    Let me know if you need additional assistance.

    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top