Developer Preview

This page tries to outline what has changed since the original Developer Preview version.
link - developer.microsoft.com/en-us/office/blogs/custom-functions-in-excel-developer-preview/


Excel.CustomFunctions.initialise

As part of the original initialisation process the following line of code needed to be added to the Office.initialise event handler.
This initialisation step was removed when this functionality was released to production.

Office.initialize = function (reason) { 
   return Excel.CustomFunctions.initialise():
}

context.workbook.customFunctions.addAll()

Excel caches previously-registered functions for each add-in.
At some point you could run the following code to remove all the previous registered functions in the cache and replace them with the new ones.
This API has been removed and is no longer available.

Excel.run (function(context) { 
        context.workbook.customFunctions.addAll();
        return context.sync().then(function(){});
});

link - stackoverflow.com/questions/47393203/how-to-reload-excel-custom-functions/47419944#47419944


Excel.Script.customFunctions

To complete the registration of the custom functions defined using "Excel.Script.customFunctions" you need to call "CustomFunctions.addAll()"
link - github.com/exceldemo/mvp/blob/master/custom-functions/custom-functions.md


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext