How to make importJSON leave existing data alone, if calculation not performed?

by Jonathan van Clute   Last Updated August 18, 2017 18:03 PM

I'm using the 3rd party importJSON() function, and I needed a way to make it calculate ONLY when I explicitly requested it. Thanks to this question, I now have a way to do that, but a big problem remains.

Now, any time a calculation is performed (which is On Change), importJSON either calculates if I have it set to do so, or wipes out the existing data that was calculated last time. This means my data is constantly disappearing on me in the middle of trying to use my spreadsheet.

Is there any way to make importJSON() return if not set to calculate, but NOT erase data in previously-calculated cells?

Related Questions

Retrieve last entry via ImportXML

Updated April 06, 2015 17:01 PM