code.pyret.org icon indicating copy to clipboard operation
code.pyret.org copied to clipboard

#N/A values in sheets make them unable to load (and have bad error)

Open jpolitz opened this issue 4 years ago • 1 comments

There are two issues here:

  1. There's a bad error in Sheets loading when an #N/A value appears; the existing code concatenates a string containing a Google API error object, which renders as the always lovely [object Object].
  2. It's not clear that this needs to be an error at all, but that might be a longer discussion.
image

jpolitz avatar Jan 02 '21 20:01 jpolitz

This is at least improved to this now:

image

jpolitz avatar Jan 02 '21 20:01 jpolitz