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?