Google Spreadsheet clearContent() function error

Question

Can anyone tell me why this function isn't working? Produces error "Cannot find function clearContent() in object Sheet"

function removeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var newData = new Array();
  for(i in data){
    var row = data[i];
    var duplicate = false;
    for(j in newData){
      if(row[1] == newData[j][1] && row[2] == newData[j][2] && row[3] == newData[j][3] && row[6] == newData[j][6] && row[7] == newData[j][7] && row[8] == newData[j][8]){        
      duplicate = true;
      }
    }
    if(!duplicate){
      newData.push(row);
    }
  }
  sheet.clearContent();
  sheet.getRange(1, 1, newData.length, newData[4].length).setValues(newData);
};

Thanks in advance.

wchiquito wchiquito · Accepted Answer · 2013-12-29T19:41:56

Check the classes: Sheet and Range.

clearContents() is a method of Sheet.
clearContent() is a method of Range.

Google Spreadsheet clearContent() function error

1 Answers