Move row to very bottom of sheet (Google Sheets Apps Script)

Question

I have a Google Sheet with a specific number of rows, and I want to use a script/macro to move a certain row to the very bottom.

const DESTINATION_INDEX = 4;
function myFunction() {
  const ss = SpreadsheetApp.getActive();
  const foo = ss.getRangeByName('foo');
  foo.getSheet().moveRows(foo, DESTINATION_INDEX);
}

That causes it to end up at row 3 (as the moveRows() documentation and example suggest):

But when DESTINATION_INDEX = 5, it throws Exception: Those rows are out of bounds.

I could work around this by moving foo to the penultimate row, then moving the last row up by one. Or I could do a little insertRowAfter/deleteRows dance.
But is there any way to move a row directly to the bottom? This seems like an oversight in the API.

Answer 1

"moveRows/insertRowAfter/deleteRows" Dance

My first reaction was that Jacktose was wrong and I wrote this to prove it. But as Jacktose comments - this is merely the "dance". I was inclined to delete it, but I'll leave it here (not as an answer to Jacktose) but in case someone wants to use moveRows and they need to know the rest of the steps in the dance.

function wa_164152() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet()

  // get the last row and the number of rows
  var lastRow = sheet.getLastRow() // last row with data
  var maxRows = sheet.getMaxRows() // the last row
  //Logger.log("DEBUG: the last row = "+lastRow+" and the max rows = "+maxRows)

  // variable if rrequired to insert new row
  var newrow = 0
  
  // test if the last row = the number of rows
  // if yes, then insert a new row
  if (lastRow === maxRows){
    // set trigger for new row
    var newrow = 1
    // insert a new row
    sheet.insertRowAfter(maxRows)
  }

  
  // define row to move
  const foo = ss.getRangeByName('foo');
  //Logger.log("DEBUG: foo = "+foo.getA1Notation()+" row = "+foo.getRow())

  // create variable for the destination row 
  var targetrow = lastRow+1
  
  // move the row
  sheet.moveRows(foo, targetrow);

  // check whether a new row was inserted
  if (newrow === 1)
  {
    // delete the last row
    sheet.deleteRow(lastRow+1)
  }

}

---

BEFORE//AFTER