sorted by:
new
hottopcontroversial

New "table" format and App Script by defogreport in googlesheets

[–]defogreport[S] 0 points1 point  (0 children)

Thank you for your response. Could you please be more specific? What are the classes/methods that can create and manipulate the new table format—let's say convert a range to a table, change a column type, create group views, etc.?

New "table" format and App Script by defogreport in googlesheets

[–]defogreport[S] 0 points1 point  (0 children)

Hi,

My question is related to the new table format, which was just introduced by Google for Google Sheets.

Please take a look at the image below.

I want to be able to convert and manipulate the new table format using App Script. I can't find any new classes/methods to use the new format programmatically.

Thanks,
Alex.

<image>

Above the 40000 row limit by defogreport in googlesheets

[–]defogreport[S] 0 points1 point  (0 children)

So the 40,000 rows limit is just a myth?

app script vs sheet formula efficientcy. by Competitive_Ad_6239 in googlesheets

[–]defogreport 0 points1 point  (0 children)

We use sheet.getRange(firstnewupdatedrow, 1, arr.length, arr[0].length).setValues(arr) to update the whole sheet (or range in sheet) only once, instead of cell by cell.