#value! message instead of arguments type in Function Argument box

[maxym2020]

I'm building an Excel add-in with Custom Functions. This function has a description with types for every argument. To create a functions.json file I use YO generator provided by Microsoft. Everything works fine until some COM add-in is installed. In that case, the Function Arguments box shows the wrong argument types.

Expected Behavior

There shouldn't "#VALUE!" message instead of arg type in the Function Arguments box

Current Behavior

"#VALUE!" text instead of arg type

Steps to Reproduce, or Live Example

• Link to live example: __

• Additional details:
  1. Create simples add-in for Excel with shared state using YO generator.
  2. Create simplest custom function with args for Excel add-in.
  3. Install any Excel COM add-in on your computer

Your Environment

• Platform : PC desktop
• Host: Excel
• Office version number: 16.0.14332.20412
• Operating System: win 10 pro 19043.2130
• Browser (if using Office Online): any

[samantharamon]

Thanks for reporting this, @maxym2020.

@yaweizhu-henson, is this something you can assist with?

[donlvMSFT]

Hi @maxym2020 , thanks for report this issue, I'm trying to repro but seems it works well with the first party com add-ins. Could you share which com add-in you are using to reproduce? That could be really helpful.

[maxym2020]

Of course. I took it here: https://www.asap-utilities.com/download-asap-utilities.php ASAP utilities. Home & student version

P.S. I confirm that everything is ok with "pre-added" com addins. ( I tried to turn on Pivot one)

[donlvMSFT]

Hi @maxym2020 , I tried on latest Office CC version, seems this issue is not happened, What's your channel? We could double confirm on that version.

[maxym2020]

@donlvMSFT What do you mean "channel"? To speak live?

[RuizhiSunMS]

@maxym2020 see the last line 'Microsoft Current Channel (OuterRing)', you can get this by 'File -> Account'

[maxym2020]

No third line there

[maxym2020]

@RuizhiSunMS Hi! New updates. I tried to create a new excel add-in using this official manual After that, I added help url to function description: Add two numbers @helpUrl https://somesite.com

Everything was OK. But then I installed ASAP utils add-in. And the help url became broken. And the type of arguments for the LOG function was marked as NUMBER

[maxym2020]

@yaweizhu-henson @donlvMSFT What kind of data can I provide to help with this issue?

[donlvMSFT]

Hi @maxym2020 , we're still trying to repro the issue, but from our environment, couldn't get same result. Do you know which channel or subscription of Office are you in?

[maxym2020]

No, I don't know. The channel row is empty. And I have some corporate subscription.

[donlvMSFT]

Hi, sorry for the late response. We'd like to combine this issue with https://github.com/OfficeDev/office-js/issues/3352. We already opened an internal bug to track this issue: #8009934. Or you can provide the scale of affected users, it will help us re-prioritize this problem. Thanks for your patience!

[JEGUOCEAN]

Hi everyone I was able to reproduce with scriptlab just following the steps I proposed => on first workbook it is ok, on second not, when you reopen function wizard it shows error. It is not the same issue than https://github.com/OfficeDev/office-js/issues/3352. because there is no link with COM addin.

[lucadom]

Same problem here. Any updates about this issue?

[maxym2020]

We still experience this issue. No changes at all.

вт, 27 серп. 2024 р. о 09:23 Luca Dominici @.***> пише:

Same problem here. Any updates about this issue?

— Reply to this email directly, view it on GitHub https://github.com/OfficeDev/office-js/issues/2977#issuecomment-2311668449, or unsubscribe https://github.com/notifications/unsubscribe-auth/A24WQ2TKWDDLZJAOYNS2TU3ZTQLMPAVCNFSM6AAAAABNFMXZ4OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMJRGY3DQNBUHE . You are receiving this because you were mentioned.Message ID: @.***>