Google Sheets Script:Group Button At Bottom

Question

I'm populating a new sheet with parsed data from another sheet, and then I group rows using shiftRowGroupDepth().

It works well, but I was surprised to find all the group/ungroup buttons at the bottom of a group instead of the top.

I've checked the Group Class in the docs, but I haven't found a method to revert to the default - button at top. Anyone know where this setting is?

question from:https://stackoverflow.com/questions/65626190/google-sheets-scriptgroup-button-at-bottom

Answer 1

Found the answer in another forum, it's:

spreadsheet.getActiveSheet().setRowGroupControlPosition(SpreadsheetApp.GroupControlTogglePosition.BEFORE);