none
getting Excel undo Stack language independent RRS feed

  • Question

  • We are dependent on LastUseraction of Excel in our code. LastUseraction we are getting it from the CommandBarcontrol.

    Like this.

    var commandBars =
                    (CommandBars)
                        ExcelApplication.GetType().InvokeMember(
                            "CommandBars", BindingFlags.GetProperty |BindingFlags.Public |BindingFlags.Instance,
                            null,
                            ExcelApplication,
                            null,
                            new CultureInfo(1038));
                dynamic commandControl = commandBars["Standard"].FindControl(Id:128);

    var userAction = commandControl.List[1];

    Based on LastUserAction(Ex:-Sort,SubTotals,Pivot,PivotTable Refresh) we are deciding a particular action.So when ExcelApplication is in English it works fine.But once User change the Language our Addin did not work as expected because the LastUserAction does not come in English.

    So is there any option to get the UndoStack independent of Language or any other alternate approach.

    Wednesday, December 7, 2016 4:37 AM

All replies