Posted 29 August 2019, 3:02 am ESTIs there a way for me to delete a data validation? I used the reset() function but the spread JSON still shows the validator as being present. Also if I run the getDataValidator() function on the selection where the validator was I still can get its id and other parameters.
Remove a data validator from the sheet
Posted by: adisa.craig on 29 August 2019, 3:02 am EST
Marked as Answer
Replied 29 August 2019, 5:44 pm ESTHi Adisa,
To clear validator from a cell range you could pass 'null' to setDataValidator() method. Please refer to the following code snippet:
sheet.setDataValidator(rowIndex, colIndex, rowCount, colCount, null); // clear validator from sprecified range
You may also refer to the following sample which demonstrates the same: