How to create a custom function that returns data to multiple cells

Question

I need to create a custom function in Google Apps Script that will allow me to input the location of certain cells and then the function would output into new cells. This is what I tried sofar:

function SetRange(RowNum) {
  var app = SpreadsheetApp;
  var ss = app.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();

  sheet.getActiveCell(),setValue(45)
  sheet.getRange(RowNum,24),setValue(51);

  }

I get the error that "SetValue is not defined. I am building this program as I learn so there are some facts that veteran programmers would know that I do not. Thanks again for all your help

It should be .setValue(45) not ,setValue(45). Note the use of period rather than comma. — Jack Brown
– Jack Brown, Commented Jan 26, 2018 at 16:23
I fixed that and got the following:Error You do not have permission to call setValue (line 6). — Charlie Cannon
– Charlie Cannon, Commented Jan 26, 2018 at 16:31
I see you are writing a custom function! Custom functions can only modify the cell they are being called from. More details here — Jack Brown
– Jack Brown, Commented Jan 26, 2018 at 16:41

Wicket · Accepted Answer · 2018-01-27 06:38:06Z

2

Custom functions could return an array of values but can't use setValue() or setValues().

Example

function demo(){
  var output = [
    [1,2],
    [3,4]
  ]
  return output;
}

If we add =demo() to A1, the result will be:

  |  A  |  B  |
--+-----+-----+
 1|    1|    2|
 2|    3|    4|

answered Jan 27, 2018 at 6:38

Wicket

39.6k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a custom function that returns data to multiple cells

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related