function CopyCellValueByUsingArray() {
var address = "A1:D8";
var top = 2;
var left = 6;
var sheet = SpreadsheetApp.getActiveSheet();
sheet.clearContents();
var sourceCells = sheet.getRange(address);
for(var r = 1;r < sourceCells.getNumRows()+1;r++){
for(var c = 1; c < sourceCells.getNumColumns()+1;c++){
var cell = sourceCells.getCell(r, c);
Logger.log(r +" " + c);
cell.setValue(cell.getA1Notation());
}
}
var valueArray = sourceCells.getValues();
sheet.getRange(top, left,valueArray.length,valueArray[0].length).setValues(valueArray);
}