Google Docs - Duplicate Row Down Script

script.js

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
	var menuEntries = [ {name: "Duplicate Selected Row Down", functionName: "duplicate_row_down"},];
	ss.addMenu("Utilities",menuEntries);
}

function duplicate_row_down (){
	var sh = SpreadsheetApp.getActiveSheet();
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var d = ss.getActiveSelection();
	sh.insertRowAfter(d.getLastRow());
	
	// copy formula
	var new_range = sh.getRange(d.getLastRow()+1, 1, 1, d.getLastColumn())
	new_range.setFormulasR1C1(d.getFormulasR1C1());
	
    // copy formatting
	d.copyTo(new_range, {formatOnly:true});
	
}