Custom Functions

VBA User Defined Functions cannot be used with Excel Online or Excel on iOS.
Custom functions are Excel user defined functions that can be used on any platform.
They can be written using TypeScript (or JavaScript).
Excel custom functions are not supported in Office 2019 (one-time purchase).


Latest Production

This will refer to the latest production version

<script src="https://appsforoffice.microsoft.com/lib/1/hosted/custom-functions-runtime.js" 
        type="text/javascript"> </script>

Previous Version

<script src="https://appsforoffice.microsoft.com/lib/1.1/hosted/custom-functions-runtime.js" 
type="text/javascript"> </script>

The JSON file contains the meta data of the user defined functions.


Documentation

link - docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview
link - docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-json?view=office-js
link - github.com/OfficeDev/Excel-Custom-Functions/issues/
link - youtube.com/watch?v=dtR54AX0zQ0
They can leverage Azure Function calculations in the cloud


Possible Enhancements

Additionally, the HTML page referenced by the <Page> element in the manifest won't be needed for most platforms because Excel will run the JavaScript directly.
To prepare for this change, ensure your custom functions do not use the webpage DOM.


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopNext