I have a google sheet where i have row 5 as base row. I want to use this row as standard for formatting new rows entered through google form. I have developed code which is working for everything except for the row height. Row height of base row is not copied to the new row. Even I have explicitly and separately written code for that also as shown below. Any help would be highly appreciated.

 var baseRowHeight = responseSheet.getRowHeight(5);
responseSheet.setRowHeight(responseRow, baseRowHeight);

var lastCol = responseSheet.getLastColumn();
responseSheet.getRange(5, 1, 1, lastCol).copyFormatToRange(responseSheet, 1, lastCol, responseRow, responseRow);

I have a google sheet where i have row 5 as base row. I want to use this row as standard for formatting new rows entered through google form. I have developed code which is working for everything except for the row height. Row height of base row is not copied to the new row. Even I have explicitly and separately written code for that also as shown below. Any help would be highly appreciated.

 var baseRowHeight = responseSheet.getRowHeight(5);
responseSheet.setRowHeight(responseRow, baseRowHeight);

var lastCol = responseSheet.getLastColumn();
responseSheet.getRange(5, 1, 1, lastCol).copyFormatToRange(responseSheet, 1, lastCol, responseRow, responseRow);

• google-sheets
• google-apps-script

1 Answer 1

Based on our conversation with the OP in the comment section, my previous answer does not met the expected output of the Original Poster since what he meant with the post is that the row height he needs is below the default value which is 21 and setRowHeight() method cannot alter the default height value if there is a content inside although when you inspect the value through resize row, it will changed as expected but in the UI perspective, it cannot as it is always "Fit to data".

In order for this to work, you need to use the method setRowHeightsForced()

Here's the updated modified code from the OP:

function myFunction(e) {
  var responseSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1')
  var lastCol = responseSheet.getLastColumn(); 
  var responseRow = e.range.getLastRow(); 
  var baseRow = 2; 
  var baseRowHeight = responseSheet.getRowHeight(baseRow); 
  responseSheet.setRowHeightsForced(responseRow,1, baseRowHeight); 
  responseSheet.getRange(baseRow, 1, 1, lastCol).copyFormatToRange(responseSheet, 1, lastCol, responseRow, responseRow);

}