79726531

Date: 2025-08-05 18:53:35
Score: 1
Natty:
Report link

This is a bug in the API. It draws the table correctly, but when labeling each column, it uses the startRowIndex instead of the startColumnIndex to determine the column.

For example, if you pass this table range:

{
  "startRowIndex": 8,
  "endRowIndex": 10,
  "startColumnIndex": 0,
  "endColumnIndex": 2
}

Then the table is drawn like this:

Screenshot of a Google Spreadsheet, with a table at A9:B10 a the column labels offset at I9:J9

Note that the column labels start at I, i.e. column index 8, which is what was passed for startRowIndex.

Workaround

A workaround in the meantime is to only add tables on the diagonal running from the top-left to bottom-right of the sheet. In other words, always make startRowIndex and startColumnIndex the same.

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: kviLL