I'll just bump this to clarify that I obviously meant "Is this possible in the *Google Sheets API*..." Also, for posteriority, I've gotten in touch with Google Workspace Developer Support. According to their support representative, it's indeed not possible to increase the dimensions of a worksheet over the API without new cells inheriting all formatting and data validation of their existing, neighboring cells.
On Wednesday, 20 October 2021 at 18:48:17 UTC+2 Dorian Kind wrote: > Hi, > > from what I can tell, adding new rows or columns to a worksheet always > replicates the formatting settings of the last existing row or column for > any new cells being created. This happens irrespective of whether the new > rows or columns where added via setting a sheet's gridProperties or by > using explicit appendDimension requests. > > For some use cases, it would be preferable for any new cells being created > to have no formatting set. Is this possible in the Google Ads API, or do we > need to send another request to remove formatting for the new cells? > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/b5b52c00-fa92-440e-b788-14e8247822c8n%40googlegroups.com.
