javascript - Google Script: function that insert new row copying functionsformulas from last row - Stack Overflow

admin管理员组

文章数量:1389779

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 script which create a new row but it doesn't copy functions/formulas. How could I implement this formatting copy task in Google Script without having to manually select and copy?

Thanks for any help!

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 script which create a new row but it doesn't copy functions/formulas. How could I implement this formatting copy task in Google Script without having to manually select and copy?

Thanks for any help!

• javascript
• google-apps-script
• google-sheets

Share Improve this question Follow edited May 23, 2017 at 12:31 CommunityBot 111 silver badge asked Jul 26, 2013 at 21:32 craftApprenticecraftApprentice 2,7772121 gold badges6161 silver badges8787 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 3

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));
}

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

本文标签： javascriptGoogle Script function that insert new row copying functionsformulas from last rowStack Overflow