You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WorkbookIntelliSenseProvider throws an System.Runtime.InteropServices.COMException (Invalid Index) in the case we're relying on the DNA provider because the worksheet for the WB provider will not be present. This is a bit messy and trips up the debugger. Can we have a flag to indicate whether it is even required to load it, to avoid this spurious exception?
e.g.
public IntelliSenseHelper(IsEnableWBProvider)
{
Logger.Initialization.Verbose("IntelliSenseHelper Constructor Begin");
_syncContextMain = new WindowsFormsSynchronizationContext();
_uiMonitor = new UIMonitor(_syncContextMain);
_display = new IntelliSenseDisplay(_syncContextMain, _uiMonitor);
_providers = new List<IIntelliSenseProvider>
{
new ExcelDnaIntelliSenseProvider(_syncContextMain)
};
// avoid loading and throwing a spurious exception if not needed
if (IsEnableWBProvider) _providers.Add(new WorkbookIntelliSenseProvider());
RegisterIntellisense();
Logger.Initialization.Verbose("IntelliSenseHelper Constructor End");
}
The text was updated successfully, but these errors were encountered:
Hi Govert -
WorkbookIntelliSenseProvider throws an System.Runtime.InteropServices.COMException (Invalid Index) in the case we're relying on the DNA provider because the worksheet for the WB provider will not be present. This is a bit messy and trips up the debugger. Can we have a flag to indicate whether it is even required to load it, to avoid this spurious exception?
e.g.
The text was updated successfully, but these errors were encountered: