Spreadsheet - Data validation - export to JSON

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

    Posted 25 May Link to this post

    Hello,

    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.

    Scenario:

    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
    Admin
    Stefan avatar
    272 posts

    Posted 27 May 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.

    Regards,
    Stefan
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
Back to Top