A bad sample from the VSTO team (Microsoft)

Microsoft Office add-in developers are aware of the setting for displaying ribbon UI errors. So, I keep it set everywhere to prevent releasing the code that may lead to UI errors on end users machines. Here is where you can find the option for enabling that:



See How to: Show Add-in User Interface Errors for more information.

And recently after latest updates for Microsoft Office, I suddenly started getting annoying error message boxes in Excel with UI errors. I have got Excel with the following build numbers installed on my machine:

Microsoft Excel 2016 - 16.0.9330.2073 - 32-bit
 

Here is how it looks like in Excel, the error message bombs users twice when they try to open the File menu (the File backstage tab) and go back, or just open another workbook - a lot of cases:


As you see on the screenshot, the caption says that an error message is caused by the VSTO design-time adapter for Excel. Then I checked the list of COM add-ins in Excel and found a problematic one:


The Publisher is listed there - Microsoft Corporation. Well done!


P.S. As a result, you may observe an empty ribbon tab in Excel:



If you faced with such cases and don't know what to do with these issues I'd suggest contacting add-in developers. In our case, we got two add-ins from the VSTO team (Microsoft Corporation) so it makes sense to report the problem to the Excel team. I strongly believe they will be interested in fixing these issues.

The following screenshot shows the place where you can submit your feedback to the Excel developers:


  

The File menu (the backstage UI) provides the Feedback entry for users who want to send any feedback (positive or negative) or simply suggest anything.

Popular

Microsoft Word: How to get a selected word when you do a right click

Image
One of the widely spread tasks in word is to get the current word for processing it further. For example, you typed a single word and what to do some actions against it, or search in the dictionary (database) for such entries. I.e. do whatever you need. When you do the right click on the word you may see the context menu with the Synonyms entry: Do you look for a similar implementation? If so, this article will give you a good start! The Word object model provides the Selection class. Unfortunately it doesn't provide any information about the currently selected word, i.e. where exactly the user did the right click. As one of the possible ways, to get the job done you may use the MoveStart* and MoveEnd* methods of the Selection class. I included asterisks intentionally to draw your attention to the fact that you may find other methods / variations useful. So here I will give you the basics. The MoveStartUntil method of the Selection class moves the start position
Continue reading »

What does 'Embargo' mean for IT professionals? - Part I

Image
     I am, like any other Windows based developer, extensively use services and software provided by the U.S. companies. But recently I started to see a strange message stating that the country where I live (Belarus now) is sanctioned by the United States and my IP addresses are blocked. So, we can't use their services any longer. Most probably, and I suspect that such decision was made based on the Russia-Ukraine war. Because earlier this year I could open any page on the web site without any issue. But how we, developers, are related to the war or even politician games?  For example, I see the following text on the Pluralsight.com web site: Because your IP address or billing address is associated with a country that is sanctioned by the United States, by U.S. law we are required to block your access to Pluralsight.com. If you believe you are receiving  this message in error, please contact ...@pluralsight.com The exact picture is shown on the screenshot:
Continue reading »