Custom function throws a “You do not have the permission required to setValue” error

by

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 to the right of the cell containing the custom function. You can test this with a custom function containing return [[1,2],[3,4]];.

reference : Custom Functions in Spreadsheets

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. “Sign in with Google temporarily disabled for this app” error when trying to authorize a script
  3. Custom functions intermittently hang with “Error – Loading Data”
  4. Selecting the last value of a column
  5. Google App Scripts cannot be given Authorization or Permission
  6. Refresh data retrieved by a custom function in Google Sheet
  7. How to evaluate a spreadsheet formula within a custom function?
  8. Custom Functions and Recalculation
  9. Passing cell references to spreadsheet functions
  10. How do you create a “reverse pivot” in Google Sheets?
  11. Create Google Calendar Events from Spreadsheet but prevent duplicates
  12. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  13. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  14. Retrieving Google Sheets cell border style programmatically
  15. Determining the last row in a single column
  16. Cannot find method getRange(number,number)?
  17. How do I add formulas to Google Sheets using Google Apps Script?
  18. Deleting rows in google sheets using Google Apps Script
  19. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  20. Adding Buttons To Google Sheets and Set value to Cells on clicking
  21. Margins parameters for Google spreadsheet export as PDF
  22. Google Apps Script: Dynamically creating spreadsheet menu items
  23. Script to convert .XLSX to Google Sheet and move converted file
  24. Hidden field in a Google Form
  25. Apply multiple font colors to the text in a single Google Sheets cell
  26. Google Sheet use Importxml error could not fetch url [duplicate]
  27. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  28. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  29. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment