(From my answer on Web Apps.) One can get a reference to the passed range by parsing the formula in the active cell, which is the cell containing the formula. This makes the assumption that the custom function is used on its own, and not as a part of a more complex expression: e.g., =myfunction(A1:C3), … Read more
The proper way to make that a custom function to recalculate is to change a parameter of it. Regarding the use of NOW() and other similar built-in functions as paremeters of custom functions, from Custom functions in Google Sheets Custom function arguments must be deterministic. That is, built-in spreadsheet functions that return a different result … Read more
I created a custom import function that overcomes all limits of IMPORTXML I have a sheet using this in about 800 cells and it works great. It makes use of Google Sheet’s custom scripts (Tools > Script editor…) and searches through content using regex instead of xpath. function importRegex(url, regexInput) { var output=””; var fetchedUrl … Read more
Spreadsheet functions from Apps-Script Not possible – This has been asked many times. Suggest you check the google-apps-script issue list to see if anything has changed. But last I checked, there is no way to do it, and they have no plan to add it. https://code.google.com/p/google-apps-script-issues/issues/list Ethercalc – java script spreadsheet formulas If you need … Read more
They both do the same, but udiff-assoc compares the DATA with the user supplied function, while diff-uassoc compares the INDEX with the user supplied function. As an answer to @lonsesomeday : as indicated by the ‘u’, diff_assoc will use internal functions for all comparisons, and udiff_uassoc uses provided callbacks for index and data comparison. http://www.php.net/manual/en/function.array-diff-uassoc.php … Read more
Ok, it seems like my problem was that google behaves in a weird way – it doesn’t re-run the script as long as the script parameters are similar, it uses cached results from the previous runs. Hence it doesn’t re-connect to the API and doesn’t re-fetch the price, it simply returns the previous script result … Read more
from the documentation : Custom functions return values, but they cannot set values outside the cells they are in. In most circumstances, a custom function in cell A1 cannot modify cell A5. However, if a custom function returns a double array, the results overflow the cell containing the function and fill the cells below and … Read more
Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range: =INDEX(G2:G, COUNT(G2:G))
This seems to be a issue on Google’s server. There is already an active report about Google sheets custom functions stuck in loading. You may want to click the star icon on the top left of the issue report to indicate that you are also being affected by the issue. Other related issues: Apps script … Read more
I think all of the answers here cover the core of what the lambda function does in the context of sorted() quite nicely, however I still feel like a description that leads to an intuitive understanding is lacking, so here is my two cents. For the sake of completeness, I’ll state the obvious up front: … Read more