CODEWITHSUNDEEP
office-jsexcel-addins
Amitava Karan
Amitava Karan

Reputation: 677

office.js open taskpane programmatically

I know we can provide a button in the ribbon and set the action as ShowTaskpane. Then the taskpane will open on click of the button. We want to open a taskpane when a cell with formula is selected just like Pivot Table Fields taskpane will appear if you selected a cell within the pivot table.

Any help on this will be appreciated.

Upvotes: 1

Views: 442

Answers (1)

Marc LaFleur
Marc LaFleur

Reputation: 33132

Add-ins cannot be launched conditionally based on the context of selected data. The nearest you could get would be to automatically open a task pane with a document.

I recommend visiting the UserVoice and adding your suggestion.

Upvotes: 1

Related Questions