Issue in order of event handler execution between office 2016 and office 365 Version.

Question

We found an issue in order of event handler execution between office 2016 and office 365 Version. We have create sample excel application to reproduce the issue. During paste operation order of event handler different from Office 2016 and office 365.

Please find the code snippet for your reference.

 public void PrinttheOrderofExecution()
     {



      app = new Excel.Application();
        app.Visible = true;
        workbook = app.Workbooks.Add();
        Excel.Worksheet newWorksheet = null;
        newWorksheet = (Excel.Worksheet)app.ActiveWorkbook.Sheets.Add();
        worksheet = app.ActiveSheet as Worksheet;



        // Put a volatile function on the sheet, which will force a recalculation
        // of this sheet whenever any calculation takes place.
        string cellAddition = "=NOW()";
        Range firstCell = worksheet.Range["A1"];
        firstCell.Formula = cellAddition;



         app.AfterCalculate += new AppEvents_AfterCalculateEventHandler(ExcelEventHandler_AfterCalculate);
        _excelEventDisconnects.Add(() => { app.AfterCalculate -= ExcelEventHandler_AfterCalculate; });



        app.SheetCalculate += new AppEvents_SheetCalculateEventHandler(ExcelEventHandler_SheetCalculate);
        _excelEventDisconnects.Add(() => { app.SheetCalculate -= ExcelEventHandler_SheetCalculate; });



        app.SheetChange += new AppEvents_SheetChangeEventHandler(ExcelEventHandler_SheetChange);
        _excelEventDisconnects.Add(() => { app.SheetChange -= ExcelEventHandler_SheetChange; });



        app.SheetSelectionChange += new AppEvents_SheetSelectionChangeEventHandler(ExcelEventHandler_SheetSelectionChange);
        _excelEventDisconnects.Add(() => { app.SheetSelectionChange -= ExcelEventHandler_SheetSelectionChange; });



        bool eventFired = true;
        string cellValue = "New Value";
        Assert.IsNotNull(worksheet);



        Range cellToCut = (Range)worksheet.Cells[12, 12];
        Range cellToPaste = (Range)worksheet.Cells[14, 14];

        cellToCut.Value = cellValue;
        cellToCut.Select();
        cellToCut.Cut();
        cellToPaste.Select();
        worksheet.Paste();



        Assert.IsTrue(eventFired);
        Thread.CurrentThread.Join();  
  }



  static void ExcelEventHandler_SheetCalculate(object sheet)
    {
        MessageBox.Show(String.Format("SheetCalculate"));
    }
    private void ExcelEventHandler_AfterCalculate()
    {
        MessageBox.Show(String.Format("AfterCalculate"));
    }
    void ExcelEventHandler_SheetSelectionChange(object Sh, Excel.Range Target)
    {
        if (app.CutCopyMode == Microsoft.Office.Interop.Excel.XlCutCopyMode.xlCut)
        {
            MessageBox.Show(String.Format("Sheet Selection Change - Cut Operation"));
        }
        else if (app.CutCopyMode == Microsoft.Office.Interop.Excel.XlCutCopyMode.xlCopy)
        {
            MessageBox.Show(String.Format("Sheet Selection Change - Copy Operation"));
        }
        else
        {
            MessageBox.Show(String.Format("Sheet Selection Change Operation"));
        }
    }



    void ExcelEventHandler_SheetChange(object Sh, Excel.Range Target)
    {
        MessageBox.Show(String.Format("SheetChange Operation"));
    }

Office 2016 version executes the following order

Sheet Calculate
Sheet Change
Sheet Change
After Calculate

Office 365 version executes the following order

Sheet Change
Sheet Change
Sheet Calculate
After Calculate

Why the order of events not same in both office versions? Any help or insight to this would be greatly appreciated.

Answer

Can I have any update on this ticket?

Answer

Could you suggest us? How to rearrange paste event in Office 365?

Issue in order of event handler execution between office 2016 and office 365 Version.

2 answers