search

GCalToolkit / Sheets2GCal

Issue Tracker for Sheets2GCal Google Sheets Add-on
0 stars 1 forks source link

Script error... maybe #14

Closed Zed7TS closed 2 years ago

Zed7TS commented 2 years ago

Hi, everytime I update this pops up: ScriptError: Exception: Request failed for https://content-sheets.googleapis.com returned code 400. Truncated server response: { "error": { "code": 400, "message": "Range (S2GCal!A10997:H10997) exceeds grid limits. Max rows: 10996, max columns: 26", "status": ... (use muteHttpExceptions option to examine full response)

It looks like it's working anyway. Anyone knows what it could be causing this?

GCalToolkit commented 2 years ago

Hi, how many rows actually contain data, and how many columns exist in your sheet? I'm not sure if Google automatically adds rows/columns when required so have you tried manually adding extra rows and columns yourself?

GCalToolkit commented 2 years ago

Update - can you try again? I think I've fixed the problem and Sheets2GCal should now work as expected.

Zed7TS commented 2 years ago

works fine now! Thank you!