I have a table with cells that have functions/formulas, like this one:I need a script that creates a new row, copying with 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 Apps Script without having to manually select and copy?
How to automatically insert a new row and retain functions/formulas from last row?
google spreadsheets;google apps script
Use the code below to copy also formula's as normal values. Add the code by selecting Tools from the spreadsheet menu. Then select script editor and add the code. Make sure to press the bug button and authenticate the script.Code// global var ss = SpreadsheetApp.getActive();function onOpen() {  var menu = [{name:Add New Last Row, functionName:addRow}];  ss.addMenu(Extra, menu);}function addRow() {  var sh = ss.getActiveSheet(), lRow = sh.getLastRow();   var lCol = sh.getLastColumn(), range = sh.getRange(lRow,1,1,lCol);  sh.insertRowsAfter(lRow, 1);  range.copyTo(sh.getRange(lRow+1, 1, 1, lCol), {contentsOnly:false});}RemarkSetting the contentOnly to false will yield a standard copy. Setting it to true, will paste only values.The example script you found, does way more then pasting values.....ExampleI've created an example file for you: Add Row With Formula's