Theo Ephraim

So this is how the google api works - reading from a merged cell, other than the top-left one - will return empty. The way to deal with this is...

Haven't implemented it yet, but it should be pretty straightforward. Feel free to open a PR!

It should be throwing an error of some kind - so either you need to wrap your calls in try catches, or have a global uncaught error handler registered. I...

Hi @christopherreay - do you have any idea if this seemed to be an issue with the google API or this module?

All good - I'll take a look. Thanks!

Good idea :) 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,...

It looks like this is because your sheet is linked to a google form. https://support.google.com/docs/thread/12158043?hl=en I think there may still be a way to delete a row, but apparently it's...

Currently not supported, although it should be pretty straightforward to add support. See docs here: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#AddConditionalFormatRuleRequest and the method just waiting for someone to implement it :D https://github.com/theoephraim/node-google-spreadsheet/blob/master/lib/GoogleSpreadsheetWorksheet.js#L680

Hello! Sorry this took so long to respond. Certainly open to a PR. I haven't thought through the implications - it may be tricky... but maybe not! Feel free to...

What do you think desired behaviour would be - ie how do you want to set the cell value. Probable by escaping with a single apostrophe like the UI on...