Google Script: Function That Insert New Row Copying Functions/formulas From Last Row

I have a table which cells have functions/formulas, like this one: I need a script that create a new row copying to it the functions/formulas of the last used row. I find this sc

Solution 1:

You can copy formulas just as easily you copy values, just use Range.getFormula() and Range.setFormula() instead of .getValue() and .setValue(). See documentation on spreadsheet service.

Inserting a row below the last one is pretty basic, use insertRowAfter and getLastRow in a simple script.

---

EDIT : in case you don't find it, here is an example of another simple way to do it, copying everything in one step

function duplicateLastRow(){
  var ss = SpreadsheetApp.getActiveSheet();
  ss.insertRowAfter(ss.getLastRow());
  ss.getRange(ss.getLastRow(),1,1,ss.getLastColumn()).copyTo(ss.getRange(ss.getLastRow()+1,1));
}

Solution 2:

Method Sheet.appendRow allow append row in one command as atomic action.