I’m currently evaluating spreadsheet calculation engines that can be deployed to a server and used to calculate pre-built spreadsheets which are then emailed out once populated with data. These spreadsheets may contain several Add-In formulae that we have developed that make calls to an API and return data. Some of these API calls return multiple results. When calculated in Excel, we set the first value as the result of the calling cell with the other values inserted into sequential cells. In the example below, MyCustomFunc is called from A3 and returns 6 values. The first result would be set as the value of A3, with the other results being inserted sequentially into A4:A8.
MyCustomFunc.png (2.1 KB)
Could you please provide answers to the following questions about the support File Formats offers for this scenario:
- Does your product allow the creation of custom functions so that we can calculate our Add-In formula?
- If yes, does it allow us to set the results from within our custom function to cells other than the calling cell, as in the example above, without entering the formula as an array formula?