2

I have very simple script (custom function) '''

/**
 * Return order amount in words.
 *
 * @param {amount} is order amount
 * @param {currency} is order currency: BYN, RUB, EURO
 * @return The order amount in words.
 * @customfunction
 */

function orderAmountInWords(amount, currency) {
  return AmountInWords.FloatToSamplesInWordsRus(amount, currency);
}
'''

Until yesterday everything was working fine But yesterday something broke

I see "Loadding..." and a tip "Error loading data" in the place where the result of the function should be

The only guess as to the cause is that I was trying to restore a previous version of the spreadsheet. The function from the library works fine in other spreadsheet and in debug mode. I deleted the restored versions, removed the script and created it again, but nothing changed It looks like the link between spreadsheet and script is lost, but autocomplete works

Maybe I should copy all the data to a new spreadsheet, but that spreadsheet is connected to appsheet application so I don't like the idea of making changes in another app.

Rubén
  • 34,714
  • 9
  • 70
  • 166
JustAmateur
  • 21
  • 3
  • `AmountInWords.FloatToSamplesInWordsRus()` must be coming from a library. Have you added the library as a resouce in script editor? On the left under Library +. – TheWizEd Mar 03 '22 at 13:10
  • Of course, I added No problems with Library – JustAmateur Mar 03 '22 at 14:36
  • 1
    There seems to be an issue with custom functions today. See this article https://groups.google.com/g/google-apps-script-community/c/SR46fIb3OTU or this https://groups.google.com/g/google-apps-script-community/c/D9rPBvOr5L0 or this https://groups.google.com/g/google-apps-script-community/c/IuBHIZ4QBWw – TheWizEd Mar 03 '22 at 14:42
  • Today another very strange situation happened: I opened this spreadsheet from another computer, but I logged in through the same account and chrome browser. And everything worked. I returned to my home - and again I see the same picture: "Loading..." – JustAmateur Mar 03 '22 at 14:48
  • The same library works fine in another spreadsheet – JustAmateur Mar 03 '22 at 14:50
  • It seems that there are several people having the same problem, you may want to check this [thread](https://stackoverflow.com/questions/71340032/custom-functions-intermittently-hang-with-error-loading-data) – Gabriel Carballo Mar 04 '22 at 01:56
  • 1
    Started working for me today – Mrchief Mar 04 '22 at 16:14
  • 1
    Does this answer your question? [Custom functions intermittently hang with "Error - Loading Data"](https://stackoverflow.com/questions/71340032/custom-functions-intermittently-hang-with-error-loading-data) – Gabriel Carballo Mar 07 '22 at 16:46

0 Answers0