any ideas of why autoFillToNeighbor works only for the first column I use it?
any ideas of why autoFillToNeighbor works only for the first column I use it?
When I run the same code structure to automatically fill-out a column using the first cell as reference it only works for the first one, AW in my case.
function p.Table() {
var app = SpreadsheetApp;
var ss = app.getActive();
var sheets = ss.getSheets();
ss.getRange('AW2').activate();
ss.getCurrentCell().setFormula('=year(Q2)');
ss.getActiveRange().autoFillToNeighbor(app.AutoFillSeries.ALTERNATE_SERIES);
ss.getRange('AX2').activate();
ss.getCurrentCell().setFormula('=month(Q2)');
ss.getActiveRange().autoFillToNeighbor(app.AutoFillSeries.ALTERNATE_SERIES);
ss.getRange('AY2').activate();
ss.getCurrentCell().setFormula('=AF2/1000');
ss.getActiveRange().autoFillToNeighbor(app.AutoFillSeries.ALTERNATE_SERIES);
autoFillToNeighbor()
0
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
The
autoFillToNeighbor()method works on the range class, but the range needs to be a "source range" that is based on multiple cells. Your code is activating one cell. There needs to be a pattern that the code can determine. There is no pattern from one cell. The example in the documentation has two columns of data, and even though the source range doesn't include the neighboring column, it's assumed that the neighbor is part of the analysis. The example fills in a column going down. Are you trying to fill in a row? We need to know what the existing data in your sheet is.– Sandy Good
Sep 7 '18 at 22:15