search

OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.
https://learn.microsoft.com/javascript/api/overview
Other
657 stars 93 forks source link

Show result for Excel Custom Function in Function Arguments dialog #2371

Closed beatrixmorar closed 2 years ago

beatrixmorar commented 2 years ago

Hi,

Is it possible to show the formula result for a custom function in the Function Argument dialog, like it is done for the built-in functions in Excel?

Example for SUM built-in function: image

Would like to achieve the same for my custom function: image

JHJ-MS commented 2 years ago

Sorry, this feature is not supported currently. We track feature requests on https://aka.ms/m365dev-suggestions You can add your request here. Feature requests are considered when we go through our planning process. Thanks.

ghost commented 2 years ago

This issue has been automatically marked as stale because it is marked as needing author feedback but has not had any activity for 4 days. It will be closed if no further activity occurs within 3 days of this comment. Thank you for your interest in Office Add-ins!

beatrixmorar commented 2 years ago

Thank you for the quick response. I have added a feature request on the developer platform: https://techcommunity.microsoft.com/t5/microsoft-365-developer-platform/excel-custom-functions-display-formula-result-in-function/idi-p/3064211#M634