I'd like to use a Google Apps Script custom function in conjunction with arrayFormula so this may be applied to a range. How do I achieve this?
Let's say I have wrote a function that will return current cell coordinates and wish to apply/run the custom function on each cell in a range (A1:A), what syntax should I use?
Cell value:
=arrayFormula(testFunction()) // works only on one cell
Code:
function testFunction(){
return SpreadsheetApp.getActiveRange().getA1Notation();
}