‘Add-in Express for Office and .net’ category archive
Add-in Express and Windows hooks
Andrei Smolin | July 27th, 2021
Once in a couple of years Microsoft contacts us on this or that topic. The last topic was the Excel performance on Windows Desktop. They demonstrated a case where enabling an Add-in Express add-in produced an astounding 90-second delay when selecting another cell while Excel was busy with some long calculation... Read the rest of this entry →
Inner details of DPI scaling in Office COM add-ins
Andrei Smolin | June 17th, 2021
Today, I’m following Microsoft recommendations and using code fragments they provide to investigate the behavior of a System.Windows.Forms.Form (simply a form)... Read the rest of this entry →
Office COM add-ins and DPI awareness: research and analysis
Andrei Smolin | June 10th, 2021
In the first blog of this series, I showed issues related to using several monitors with different DPIs. To get an explanation of those pretty confusing results, let’s check resources available on the web.... Read the rest of this entry →
Issues with Windows mutli-DPI scaling and Office COM add-in panes and forms
Andrei Smolin | May 25th, 2021
Quite often these days you see this configuration: a notebook and an external display or two connected to the notebook. All these displays may have different DPIs. This is a typical environment where DPI-related issues reveal themselves. ... Read the rest of this entry →
Releasing COM objects: Garbage Collector vs. Marshal.RelseaseComObject
Andrei Smolin | July 20th, 2020
Just recently we've got a comment declaring one of our blogs on releasing COM objects "wrong and misleading": the author says Marshal.ReleasingComObject() and related things made him spend "lots of time on writing code that is totally unnecessary" and provides many links supporting the idea that you can use GC.Collect() to get rid of non-released COM objects.... Read the rest of this entry →
New version of Add-in Express sample COM add-in projects
Andrei Smolin | July 1st, 2020
Quick news: we've developed a new version of sample COM add-in projects that we provide in the downloadable archive on the Add-in Express .NET Downloads page... Read the rest of this entry →
How Add-in Express supports Office 365 / Office 2019
Andrei Smolin | June 16th, 2020
You might already know that Office 365 and Office 2019 are, in fact, subsequent builds of Office 2016: in any Office 365 and Office 2019 application, the Application.Version property returns a string that starts with "16"... Read the rest of this entry →
How to solve synchronization conflict when modifying Outlook item in ItemAdd event
Andrei Smolin | February 26th, 2020
I see this issue in the Sent Items folder on an Exchange account having Cached Exchange Mode turned on. Reportedly, turning the Cached Mode off solves the issue. The Outlook version used (Outlook 365 in my case) seems to be irrelevant as Google reports a similar conflict to occur in Outlook 2007... Read the rest of this entry →
Office from Microsoft Store: a spreading source of issues
Andrei Smolin | February 27th, 2019
The number of users having the Office version installed from Microsoft Store increases every day as computer vendors install it by default; see e.g. this support article from Dell. Per-user add-ins and some per-machine add-ins may run into a severe issue with that Office version. The issue is: the add-in uses old versions... Read the rest of this entry →
Support for Office 2019 is added to Add-in Express for Office and .net
Dmitry Kostochko | November 23rd, 2018
Version 9.2 of Add-in Express for Office and .net is published, and we now announce full support for all versions of Office 2000 through 2019 32-bit and 64-bit... Read the rest of this entry →
Problems with ADXTaskPane are solved in Add-in Express for Office v.9
Andrei Smolin | September 24th, 2018
Recently, our mail boxes became overwhelmed with a flow of reports describing how Add-in Express panes appear outside the host application's window. This is a manifestation of how the code calling the SetParent Windows API function can be incompatible with the recent Windows API change supported by Office 2016: Microsoft introduced DPI contexts and related API functions to let you get/set the current context... Read the rest of this entry →
Add-in Express version 9 adds support for multiple monitors in Office
Andrei Smolin | May 8th, 2018
This story started with Windows 10 Fall Creators Update that allowed using different DPIs on different monitors. How does it affect Office extensions? DPI unaware panes/forms are bitmap-stretched by Windows when DPI changes. To avoid this, you need to get notified about the DPI change and resize the form/pane and controls on it, use a different font size, different images (optional) and the form icon... Read the rest of this entry →
Version 9.0 of Add-in Express for Office is out!
Dmitry Kostochko | May 7th, 2018
Long-term customers of Add-in Express know that we usually sim-ship new releases with new versions of Microsoft Office. This time is different. While Microsoft guys are probably still working on the new features of Office 2019, the new major version of Add-in Express for Office and .net is live already... Read the rest of this entry →
Range.Replace() problems in all Excel versions
Andrei Smolin | February 21st, 2018
Range.Replace() and supposedly Range.Find() may work incorrectly in a scenario we describe on the Excel for Developers forum. A workaround is: change Range.Value directly... Read the rest of this entry →
Add-in Express for Office issues on multiple monitors with different DPI settings
Andrei Smolin | December 20th, 2017
Microsoft has published Office 2016 build 8828.2010 through its Office Insider update channel. That build supports multiple monitors with different DPI settings; the support relies on the API changes provided by Windows 10 Creators Update.... Read the rest of this entry →
Excel 2016 crashes if COM add-in creates a command bar control in a built-in context menu
Andrei Smolin | December 7th, 2017
Today's blog is about a recent crash reported by our customer. Our research shows that the crash occurs if your VSTO add-in or COM add-in creates a command bar control on a built-in context menu. We reproduce the crash when customizing the Cells context menu in this way... Read the rest of this entry →