Check for Excel error messagesĮxcel has a number of built-in error messages which are returned to a cell if there is calculation error. For more information about runtime logging, see Debug your add-in with runtime logging.
The statements cover a variety of errors, including errors pertaining to your add-in's XML manifest file, runtime conditions, or installation of your custom functions. Runtime logging delivers console.log statements to a separate log file you create to help you uncover issues. If you're testing your add-in in Office on Windows, you should enable runtime logging. To debug custom functions add-ins that don't use a shared runtime, see Custom functions debugging. To debug custom functions add-ins that use a shared runtime, see Configure your Office Add-in to use a shared runtime: Debug. Also, check for common mistakes such as leaving promises unresolved. To resolve issues, you can enable runtime logging to capture errors and refer to Excel's native error messages.
To start, open a terminal and set the OfficeWebAddinDeveloperExtras property for the relevant Office application as follows:ĭefaults write OfficeWebAddinDeveloperExtras -bool trueĭefaults write OfficeWebAddinDeveloperExtras -bool trueĭefaults write OfficeWebAddinDeveloperExtras -bool trueĭefaults write that Excel custom functions are available on the following platforms.Įxcel custom functions are currently not supported in the following: If you don't have an Office on Mac build, you can get one by joining the Microsoft 365 developer program. To be able to debug Office Add-ins on Mac, you must have Mac OS High Sierra AND Mac Office Version 16.9.1 (Build 18012504) or later. If you have add-in that shows UI in a task pane or in a content add-in, you can debug an Office Add-in using Safari Web Inspector. Debugging with Safari Web Inspector on a Mac This article describes how to debug add-ins running on a Mac.
Because add-ins are developed using HTML and JavaScript, they are designed to work across platforms, but there might be subtle differences in how different browsers render the HTML.
0 kommentar(er)
