Remove a data validator from the sheet

Remove a data validator from the sheet

Posted by: adisa.craig on 29 August 2019, 12:02 pm EST

• 

  adisa.craig

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 August 2019, 12:02 pm EST

  Is 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.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 August 2019, 2:44 am EST

  Hi 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:
  
  https://codesandbox.io/s/spread-js-starter-9kqq3

  Regards