0

Column A :

Number
1
2
...
31

Hello,

Actually I'm looking for a mean to add empty row under conditions with a short running time on Google Apps Script. So I first tried to test a very simple example :

function insertRow(){
    var ss = SpreadsheetApp.getActive();
    var sh = ss.getSheets()[5];

    var temp = sh.getRange("A1:A"+sh.getRange("A1").getDataRegion().getLastRow()).getValues();
    Logger.log("Temp : " + temp);

    i = 0;
    while (i < temp.length && temp[i][0] != ""){
      if(temp[i][0] == 20){
        var old1 = temp.slice(0,i);
        var old2 = temp.slice(i);
        Logger.log("Old1 : " + old1+"\nOld2 : " +old2);
        old1.push([""]);
        temp = old1.concat(old2);
        Logger.log(temp);
      }
      i++;
    }
  }

But it adds me infinite row in my array and I'm blowing my minds to understand.

At the end, to make my script working,

I have to put sh.getRange(1,1,temp.length,temp[0].length).setValues(temp);

I want to use setValues() Format because making work this if statement cell by cell could take a very long time if there is too much data.

Can you please, help me on this ?

BigBenne
  • 117
  • 8

0 Answers0