Office.AutoShowTaskpaneWithDocument only seems to work when hooked up to a button, and in desktop excel

[EdwinStraver]

I am trying to make sure my add-in which has a custom ribbon, and many commands, will automatically open a default taskpane when the add-in is installed.
I used the recommended code with Office.AutoShowTaskpaneWithDocument

However, I note it only works when i put it in the action controller of a button. It does NOT work when I attach it to the action controller of a menu item.

In addition, I don't seem to be able to make it work in Excel for the Web.

Are both these issues by design...or.. ?

Edwin

[guoms1]

Hi @EdwinStraver

Thank you for sharing the details! To help me investigate this issue more effectively, could you please provide:

• A complete add-in project that reproduces the problem (this would be ideal), or
• A code snippet that demonstrates the issue clearly.

Having this will allow me to quickly reproduce and analyze the behavior you’re observing. I appreciate your time and effort in helping us address this!

Looking forward to your response.

Best regards

[EdwinStraver]

No, I dont have a complete add-in project that reproduces the problem....I assume that was a joke.

I follow the documentation from https://learn.microsoft.com/en-us/office/dev/add-ins/develop/automatically-open-on-installation

If I add this code in a manifest file:

Office.AutoShowTaskpaneWithDocument

it works IF the code is associated with a BUTTON. It does NOT work when the code is hooked up to a MENU.
It also does NOT seem to work when I add the add-in to Excel for the web; no taskpane opens automatically.