How to evaluate a spreadsheet formula within a custom function?

by

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 to, you can always copy the code from “ethercalc” as it has a java script versions of the spreadsheet formulas.
https://github.com/audreyt/ethercalc

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. Custom functions intermittently hang with “Error – Loading Data”
  3. Selecting the last value of a column
  4. Custom function throws a “You do not have the permission required to setValue” error
  5. Refresh data retrieved by a custom function in Google Sheet
  6. Custom Functions and Recalculation
  7. Passing cell references to spreadsheet functions
  8. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  9. How to protect the Apps Script code in a Google spreadsheet?
  10. Is there a way to evaluate a formula that is stored in a cell?
  11. Automatic timestamp when a cell is filled out
  12. Apps Script: how to get hyperlink from a cell where there is no formula
  13. How to auto select range from a filter without having to manually enter it?
  14. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  15. You do not have permission to call openById
  16. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  17. Single Google Form for multiple Sheets [duplicate]
  18. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  19. How to replace text in Google Spreadsheet using App Scripts?
  20. How to get the correct range to set the value to a cell?
  21. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  22. Google Apps Script: Dynamically creating spreadsheet menu items
  23. Increment Cell value by one by clicking
  24. email notification if cell is changed
  25. Dynamic selection options in Google Apps Script for forms
  26. Apply multiple font colors to the text in a single Google Sheets cell
  27. To exceed the ImportXML limit on Google Spreadsheet
  28. Determine current user in Apps Script
  29. Google spreadsheet “Cannot call method “getRange” of null”
  30. Is it possible to create macro buttons to navigate in Google Sheets?

Leave a Comment