Hello Kendo Spreadsheet Team,
I'm looking for a way to apply validation along this line of thinking:
"If Cell A1 is null, then A2 is allowed to be null"
"If Cell A1 is not null, then A2 is not allowed to be null"
However I have not been able to find an effective way of accomplishing this. I want to selectively allowNulls depending on whether or not another column (not the one currently being validated) has a value or not. I cannot seem to accomplish that by simply assigning allowNulls a boolean value:
Scenario 1: allowNulls=true
validation won't run on any of the empty cells so I cannot get the invalid warning marker to indicate the field needs a value conditional on another cell
Scenario 2: allowNulls=false
all blank cells will be marked red regardless of whatever excel logic you put in the 'from:' section. completely empty rows will have their cells be marked as invalid
Any thoughts on how this can be accomplished?