Wednesday, October 26, 2022

Google Sheets Annoyances

I do some extensive Google Apps Script Javascript programming to manage my many Google Sheets spreadsheets. But I readily admit, I am not an expert senior or wizard programmer.

However, it is very irksome that you still can not directly and conveniently iterate over the cells contained in a range (like using the forEach()). Yes, you can easily iterate over the cell values of the range with the getValues() function. 

What if you need to do more with some of the, but not all of the cells contained in a range like formatting or clear the value etc.

So I had to write my own function to retrieve all cells as an array from a 1 dimensional range.

No comments: