I am currently trying to fill a block with a int from a method that I wrote with the script editor.
And ofcourse I know I can just left click a block and type the number in, but I need to do more than that.
I have no experience in java script, but I code in JAVA, so I could understand a lot of it.
I have the following code inside my method:
var sheet = SpreadsheetApp.getActiveSpreadsheet();
sheet[5][15] = 60 ; // I have stripe down almost everything to where my problem occurred
I am trying to fill row 5, column O with 60. But it isn't working. I tried sheet[5][O] = 60; but this doesn't work neither.
So how can I refer to the location 5,O on the sheet and give it a value?
sheet.getRange("O5").setValue(60);
or
sheet.getRange(5, 15).setValue(60);