🚀 go-pugleaf

Recently, I needed to do some heavy duty shuffling of data in a table. I ended up using copy and paste in spite of warnings about how unreliable it can be. 50,000 copies and pastes later, I'm feeling pretty confident that on OS X they work mighty well. (I did them in 10.2.8, but I'm now using 10.3.1.) One thing about doing them in JavaScript is that you don't have to worry about activating the application because triggering the script activates the application.

So, this morning, faced with a client who can't decide which order he wants a table (increasing or decreasing), I decided to flex my new-found muscle and write a script to reverse the order of the rows in a table.

Here it is. It starts by assuming you have an insertion point active in some cell of the table:

//DESCRIPTION: Reverses the order of all rows in a table

myTable = app.selection[0].parent.parent;
myLim = myTable.rows.length;
if (myLim > 1) {
 for (n=myLim - 2; n > -1; n--) {
  myTable.rows[n].select();
  app.cut();
  myTable.rows[n].remove();
  myTable.rows.add(LocationOptions.atEnd);
  myTable.rows[-1].select();
  app.paste();
 }
}