Last Updated: 26 Feb 2020 14:16 by ADMIN
Created on: 12 Feb 2019 12:26
Category: Spreadsheet
Type: Feature Request
Allow Spreadsheet date validation from and to options to work with formulas
Please see Demo

In first data row (Row 3) I create a range of numeric values from a , middle and maximum value.
Validation works perfectly, e.g. when manipulating the Middle value, I cannot go below minimum cell value and not above maximum cell value, until adjusted.

I want to accomplish the same with dates in second data row (Row 4 when I reference another "C4", it looks like validation works as expected, but the Date Picker is broken.
1 comment
Veselin Tsvetanov
Posted on: 26 Feb 2020 14:16

Hi Kathy,

In order to achieve the desired, you will have to use a formula for the FROM and TO validation fields. Here you will find a modified Dojo sample implementing the above suggestion:

Veselin Tsvetanov
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.