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
670 stars 96 forks source link

Excel Function Arguments window issue with custom function #3352

Open shaun-pendrigh opened 1 year ago

shaun-pendrigh commented 1 year ago

Provide required information needed to triage your issue

My add-in uses custom functions. When I open my function using the Excel Function Arguments window (fx) it works fine if there is just one workbook open. However creating a second workbook and opening a function in that instance returns #value for all the string function parameters.

I went back to the yo office example for custom functions and was able to recrate the issue.

I am currently side loading the add-in using a shared folder.

Your Environment

Expected behavior

The Excel Function Arguments window should correctly show the values for each parameter in all workbooks.

Current behavior

If multiple workbooks are open, the value of string parameters are shown as #value in the Excel Function Arguments window

Steps to reproduce

  1. Create and build the yo office custom function with shared runtime using typescript
  2. Load the manifest using the instructions to Sideload Office Add-ins for testing from a network share
  3. Create a workbook and activate the Add-in.
  4. Insert the CONTOSO.LOG function with a message.
  5. Open the function using the Excel Function Arguments window and confirm it displays the parameter correctly.
  6. Create a new workbook, leaving the first one open
  7. Repeat the steps to create and open the function. Note the #value

Context

Users will be confused and consider this an error with the Add-in custom function no doubt resulting in support calls

custom_function first_workbook second_workbook
ghost commented 1 year ago

Thank you for letting us know about this issue. We will take a look shortly. Thanks.

parched commented 1 year ago

Related https://github.com/OfficeDev/office-js/issues/2977?

shaun-pendrigh commented 1 year ago

@parched Looks like the same symptom. But I don't have any other COM add-ins active. And I have narrowed it down to having two workbooks open and provided an example where you should be able to reproduce the issue hopefully. Is there anything else I can provide to assist with moving the issue forward?

jiju-MS commented 1 year ago

Hey, @shaun-pendrigh , thanks for reporting this issue, may I ask is this issue only happened when the type of parameter is “string” or it is happened for any parameter types.

shaun-pendrigh commented 1 year ago

Hi @jiju-MS, yes its only for string parameters

shaun-pendrigh commented 11 months ago

Hi @jiju-MS, has there been any progress on this issue? Is there any way I can escalate it? This error makes it impossible for users to troubleshoot cell reference issues via the Excel Function Arguments window (fx). Figuring out what parameter of a function is linked incorrectly is critical for users to troubleshoot any issues when using a custom function.

erbg commented 9 months ago

Same problem here. Please solve

lucadom commented 2 weeks ago

Same problem here. Any updates about this issue?