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
681 stars 95 forks source link

For custom functions on web version of excel does not show any help regarding parameters #4878

Closed vivek-insight closed 1 month ago

vivek-insight commented 1 month ago

We have created custom functions for excel. When we add a new function on Excel desktop using the Excel Function Arguments window (fx) or write the formula in cell we are getting help regarding formulas parameters. But when we do same in Excel Web we are not getting any help regarding parameter. I am currently using manifest file reference from shared folder.

Your Environment

Expected behavior

Excel Web should display custom function parameters on Function Argument popup as shown in Excel desktop. Excel_Desktoppopup

Or if this is not possible then at least we should get parameter help when writing formula on cell as we are getting in Excel desktop. Excel_desktop

Current behavior

We are not getting help regarding formula parameters on Excel Web Excel_WebPopup Excel_web

Steps to reproduce

  1. Create and build the yo office custom function with reactjs.
  2. Upload manifest file on excel web
  3. Add custom function, now you can notice that we are not getting any help with parameters.
shanshanzheng-dev commented 1 month ago

Hi @vivek-insight Thanks for reporting this issue. could you share us your test code or manifest so that we can repro your issue? Thanks.

vivek-insight commented 1 month ago

Hi @shanshanzheng-dev please find attached manifest file manifest..zip

shanshanzheng-dev commented 1 month ago

Hi @vivek-insight We're working on this feature. We'll update progress once it deploys to production. Thanks.

XuanZhouMSFT commented 1 month ago

Hi @vivek-insight, thanks for the waiting. The fixes should be available in build >= 16.0.18125.42302 in Excel online. Please have a try. Feel free to let us know whether it still repro on your side. Thanks so much.