Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Excel Custom Task Pane not showing

I'm showing a custom task pane in an excel VSTO add-in, I'm building it and showing it as thus:

var ctrl = new CellTaskPane();
var pane = CustomTaskPanes.Add(ctrl, "Custom Sheet");
pane.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight;
pane.DockPositionRestrict = Office.MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNoChange;
pane.Visible = true;

This is being done in the ThisAddin.cs file and it working just fine on my machine, both under a Debug session and with the add-in installed via the click-once installer.

However, installing the add-in on a colleague's machine is proving troublesome.

The add-in is functioning and the context menu / ribbon is working perfectly, but the pane just refuses to show.

I have a toggle button on the ribbon which toggles the Visible property on the pane and even clicking that isn't forcing the pane to show.

Any help on this would be greatly appreciated, Google is proving useless for this.

Thanks.


I should mention that CellTaskPane is just a UserControl as per the docs on MSDN: http://msdn.microsoft.com/en-us/library/aa942846.aspx

like image 256
Clint Avatar asked Jul 04 '14 15:07

Clint


People also ask

How do you show the task pane in Excel?

To make the Task Pane visible, press Ctrl+ F1 and then choose one of the Task Panes from the Task Pane dropdown list at the top right corner of the Task Pane.

How do I turn on task pane?

On the Tools menu, click Options. The Options dialog box appears. On the View tab, under Show, click to select the Startup Task Pane check box, and then click OK. The Startup task pane appears when you restart the Office program.

Where is the controls task pane?

By default, the Microsoft task pane opens on the right side of the Office program window. If you are running a compatible version of Microsoft Office, you can use the Ctrl + F1 keyboard shortcut to open the task pane. You may also click the View option in the program menu, and then select Task Pane.

Which pane is available in Task Pane?

The Task Pane is a rectangular window that appears docked on the right side of your PowerPoint window. It acts as an open menu allowing you to select from a range of commands and functions.


1 Answers

Turns out it wasn't anything we were doing directly!

There was another add-in installed (third party) which for some bizarre reason was interfering with the pane being shown (no idea why or how).

Shame that Excel doesn't show any sort of error or at least throw an exception.

Ah well.

like image 50
Clint Avatar answered Sep 29 '22 00:09

Clint