0

We have Excel VSTO add-in, which works all excel version except Excel 365, plugin UI does not show correctly, user have to drag and expand it then only it is visible.

Is there any particular setting which we have to do, so that whatever UI we have designed in visual studio, same will be shown for Excel 365 like all other excel?

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
Amol Vaidya
  • 11
  • 4
  • Could you be more specific? What UI are you talking about? Is it a custom ribbon? Dialog boxes? Task panes? – Eugene Astafiev Sep 28 '22 at 22:03
  • Hi, it is every thing on side panels (all controls that are available), I could not able to add snap as it is not allowed for me now, so can't explain better than this. – Amol Vaidya Oct 03 '22 at 02:57
  • What code do you use for displaying the side panel and controls on it? Could you be more specific? – Eugene Astafiev Oct 03 '22 at 12:22
  • Hi, Eugene, there is a form with different common controls like buttons, edit boxes, radio buttons, date time pickets, labels etc are there on forms (more than single). – Amol Vaidya Oct 04 '22 at 04:38
  • You need to describe the issue better. – Eugene Astafiev Oct 04 '22 at 13:16
  • Hi Eugene, it is a simple VSTO dialog which is shown on side panel upon click on a button on ribbon. Ribbon controls are all ok, but on side panel dialog panel on which controls are dragged, it is not getting properly shown, it's size is changed. Now since we don't have special custom controls, there is no reason to have altered behavior in excel 365 and all rest of excel versions. – Amol Vaidya Oct 07 '22 at 08:31
  • Hi Eugene what details of code or dialog you are expecting? – Amol Vaidya Oct 07 '22 at 08:31
  • From your post it is not clear how the UI looks like on a side panel and and what you get as a result. – Eugene Astafiev Oct 07 '22 at 08:44
  • Hi Eugene, I have added same question on ms community, link is bellow, I cannot add snapshot here with current reps https://learn.microsoft.com/en-us/answers/questions/1022572/vsto-excel-plugin-designed-is-not-visible-or-colla.html – Amol Vaidya Oct 10 '22 at 10:29
  • I've posted my answer. You need to check scaling levels and pay attention to the layout of you controls on a user control. – Eugene Astafiev Oct 10 '22 at 13:00

1 Answers1

0

Your task pane is just represented by a user control with .net controls placed on it. Most probably the issue is related to scaling which may different on machines. Now latest Office versions support per-monitor scaling which means the UI can be scaled per-monitor, not OS.

Another possible problematic area is the layout of controls. You need to use containers and flow the controls depending on the available dimensions. There can be a minimum width and height for the controls.

The Office extensibility model doesn't provide any mechanisms beside standard .net tools for debugging the code.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45