Sript lab custom function feature does not work
Bug Report
- Microsoft® Excel® 2019 MSO (16.0.14131.20278) 32-bit
- Windows
- Prod
How to reproduce: Ribbon -> Script lab -> Funtions
Actual behavior:
When I try to access script lab custom functions feature I am greeted with message. So the issue is not even in some particular function, the whole feature does not work.
Error: { "stack": "RichApi.Error: There was an internal error while processing the request.\n at new n (https://appsforoffice.microsoft.com/lib/beta/hosted/excel-win32-16.01.js:26:235928)\n at n.o.processRequestExecutorResponseMessage (https://appsforoffice.microsoft.com/lib/beta/hosted/excel-win32-16.01.js:26:299150)\n at https://appsforoffice.microsoft.com/lib/beta/hosted/excel-win32-16.01.js:26:297255", "message": "There was an internal error while processing the request.", "name": "RichApi.Error", "code": "GeneralException", "traceMessages": [], "innerError": null, "debugInfo": { "code": "GeneralException", "message": "There was an internal error while processing the request.", "errorLocation": "CustomFunctionManager.register", "statement": "v.register(...);", "surroundingStatements": [ "var workbook = context.workbook;", "var v = Microsoft.ExcelServices.CustomFunctionManager.newObject();", "// >>>>>", "v.register(...);", "// <<<<<" ], "fullStatements": [ "Please enable config.extendedErrorLogging to see full statements." ] }, "httpStatusCode": 500 }
Screenshot:


Custom functions return #Bussy error even while using simple sample code like 'spherevolume'