You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using batchUpdateByDataFilter with a gridRange to update a sheet.
I can get the request to work, but I've noticed that I cannot match the shape of my gridRange to the shape of my values, unless the shape of my values is square (equal length for rows and columns).
I don't know if this is expected behavior or not, but the fact that I'm able to pass a gridRange with independent lengths for width and height seems to suggest that its not. Is this a bug or expected?
Invalid dataFilterValueRange[0]: dataFilterValueRange.dataFilter matched range Sheet2!$A$1:$C$1 whose rows cannot fit the data described in data.values[0]
For this example I have to increment the endRowIndex up to 3 for the request to succeed.
Are bounded gridRanges required to be square?
UPDATE
Testing a little bit more and I've found that I can not issue an update when passing a greater than 26 rows, suggesting that I am bounded to an equivalent column width, even when I issue the command with and unbounded range.
Returned 400
Invalid dataFilterValueRange[0]: dataFilterValueRange.dataFilter matched range Sheet2!$A$1:$Z$1000 whose dimension_unspecified cannot fit the data described in data.values.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I'm using
batchUpdateByDataFilter
with agridRange
to update a sheet.I can get the request to work, but I've noticed that I cannot match the shape of my gridRange to the shape of my values, unless the shape of my values is square (equal length for rows and columns).
I don't know if this is expected behavior or not, but the fact that I'm able to pass a gridRange with independent lengths for width and height seems to suggest that its not. Is this a bug or expected?
Example request body
results in a 400 with this response
For this example I have to increment the
endRowIndex
up to 3 for the request to succeed.Are bounded gridRanges required to be square?
I can see in the documentation, the only examples are for square, half-bounded, or fully unbounded ranges.
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/other#gridrange
UPDATE
Testing a little bit more and I've found that I can not issue an update when passing a greater than 26 rows, suggesting that I am bounded to an equivalent column width, even when I issue the command with and unbounded range.
Returned 400
v2.62.0 / Python 3.10 on Windows 10
Beta Was this translation helpful? Give feedback.
All reactions