Sorry, it is not possible to delete all non-frozen rows
See original GitHub issueClearing a sheet does not work:
ctx.sheet.clear(err => {
console.log("CLEAREDDDDDDDDDD: ", err);
});
info: CLEAREDDDDDDDDDD: Error: HTTP error 400 (Bad Request) - Sorry, it is not possible to delete all non-frozen
rows.
Issue Analytics
- State:
- Created 6 years ago
- Reactions:1
- Comments:5 (1 by maintainers)
Top Results From Across the Web
Keep receiving Sorry, it is not possible to delete all non-frozen ...
You can fix this by moving delete rows to the top of the script after declarations, but before the email formation and send....
Read more >Auto Move and Delete Data when I click on Button in Google ...
"Exception: Sorry, it is not possible to delete all non-frozen rows." /**. * Moves rows from one sheet to another when column E...
Read more >Add rows in Google Sheets, delete, freeze or unlock lines
To cancel the changes and unlock all rows, choose View > Freeze > No rows in the Google Sheet menu. How to delete...
Read more >Remove Freeze for Rows, Columns in Google Sheets
Step 1: Click View → Freeze rows → No frozen rows. Remove Freeze Columns: Step 1: Click View → Freeze columns → No...
Read more >Prevent Excel from Slowing or Freezing when Deleting Rows
Excel can freeze or go into Not Responding mode when you delete rows from a ... Excel has to delete each non -contiguous...
Read more >
Top Related Medium Post
No results found
Top Related StackOverflow Question
No results found
Troubleshoot Live Code
Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free
Top Related Reddit Thread
No results found
Top Related Hackernoon Post
No results found
Top Related Tweet
No results found
Top Related Dev.to Post
No results found
Top Related Hashnode Post
No results found
Have you solved this problem?
Yep - sounds like a google sheets issue.
FYI - I’ve just a published a new version of this module which is a complete rewrite using Google’s V4 Sheets API (v3 is being deprecated on March 3, 2020). Docs available here - https://theoephraim.github.io/node-google-spreadsheet
Thanks! 😄