c# – Quick Analysis右键单击上下文菜单会被Quick Analysis默认值覆盖

我正在关注 this example为使用VSTO的excel加载项创建自定义右键单击自定义菜单,并在特定条件下显示它(右键单击Excel命名表的范围内).

当我在命名表范围外右键单击时,我从示例中修改的代码版本就像一个魅力：

但是当您在命名表范围内右键单击时,它不会显示：

我想它与快速分析功能有关,干扰了我的自定义上下文菜单覆盖.这是我在ThisAddin.cs中使用的代码：

void Application_SheetBeforeRightClick(object worksheet,Excel.Range range,ref bool cancel)
{
  GetCellContextMenu().Reset(); // reset the cell context menu BACk to the default
  // If the SELEcted range belongs within a named excel table we display the refresh menu item at the right click context menu.
  if (true) //range.IntersectsWithAnyExcelTable()) <-- this code works fine but I commented it out for the purpose of showing the problem (in this case the custom popup meny should appear ALWAYS):
  {
    const OfficeCore.MsoControlType menuItem = OfficeCore.MsoControlType.msoControlButton;
    var refreshMenuItem = (OfficeCore.CommandBarButton)GetCellContextMenu().Controls.Add(menuItem,missing,1,truE);// where missing = global::System.Type.Missing;
        refreshMenuItem.Style = OfficeCore.MsoButtonStyle.msoButtonCaption;
        refreshMenuItem.Caption = "refresh My Data";
        refreshMenuItem.Click -= refreshMenuItemClick;
        refreshMenuItem.Click += refreshMenuItemClick;
      }
    }

并且不要忘记在加载项启动时订阅事件：

Application.SheetBeforeRightClick += Application_SheetBeforeRightClick;

我怎么能：

>尽管进行了快速分析,但仍显示我的自定义菜单.
>覆盖快速分析刷新按钮功能(afaiu,这是impossible.)