Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to remove data validations?

I want to remove all data validations from a sheet, tried following but it does not get rid of them. Anyway to do this through apps script?

var ss = SpreadsheetApp.getActiveSpreadsheet();
var accountSheet = ss.getSheetByName("Account A");
accountSheet.getRange(1,1,274,61).clear();
like image 731
MorningSleeper Avatar asked Feb 09 '16 10:02

MorningSleeper


1 Answers

accountSheet.getRange(1,1,274,61).setDataValidation(null)

That should do the job.

like image 186
msullivan Avatar answered Oct 02 '22 18:10

msullivan