IssueTracker

Accurate row height cannot be accessed when a cell has "Text Wrapping" enabled.
the "getRowHeight" function in the "Sheet" class will return the underlying row height, not the actual visible row height.

Repro Steps:
1. Create a spreadsheet
2. In a cell, enable "Text Wrapping".
3. Add enough content to that cell so the text wraps to a new line (see attached image)
4. Run the following  script.

function testRowHeights() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  sheet = spreadsheet.getSheets()[0];
  numRows = sheet.getLastRow();
  for( i = 1; i <= numRows; ++i ){
    rowHeight = sheet.getRowHeight(i);
    Logger.log( "row " + i.toString() + " height : " + rowHeight.toString()  );
  }
}

Observe outputted row height does not match visible row height.
Should there be a new function available called getVisibleRowHeight() ?


I'm only trying to access this information so I can manually set the row height for Excel export.
It would be even nicer if the Excel export automatically set correct row heights (see attached image)