Exemplo n.º 1
0
        private void menuCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
        {
            CommandBarButtonClass menu = (CommandBarButtonClass)Ctrl.Control;

            ws = (Excel.Worksheet) this.Application.ActiveSheet;
            wb = (Excel.Workbook) this.Application.ActiveWorkbook;

            //ws.Cells[1,1] = "The menu command was clicked." + menu.Tag;

            if (menu.Tag == menuTags.About.ToString())
            {
                aboutClicked();
            }
            else if (menu.Tag == menuTags.ImportData.ToString())
            {
                importDataClicked();
            }
            else if (menu.Tag == menuTags.InsertColumnHeader.ToString())
            {
                insertColumnHeadingClicked();
            }
            else if (menu.Tag == menuTags.GenerateUFL.ToString())
            {
                generateUFLClicked();
            }
            else if (menu.Tag == menuTags.SaveDetails.ToString())
            {
                saveDetails();
            }
            else if (menu.Tag == menuTags.SaveAsDetails.ToString())
            {
                resetFileFormatId();
                saveDetails();
            }
            else if (menu.Tag == menuTags.LoadDetails.ToString())
            {
                loadDetails();
            }
        }
Exemplo n.º 2
0
        private void menuCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
        {
            CommandBarButtonClass menu = (CommandBarButtonClass)Ctrl.Control;

            ws = (Excel.Worksheet) this.Application.ActiveSheet;
            //wb = (Excel.Workbook)this.Application.ActiveWorkbook;

            //ws.Cells[1,1] = "The menu command was clicked." + menu.Tag;

            if (menu.Tag == menuTags.UpdateData.ToString())
            {
                updatePIData();
            }
            else if (menu.Tag == menuTags.GetPIData.ToString())
            {
                getPIData();
                //something
            }
            else if (menu.Tag == menuTags.AboutPIDataEdit.ToString())
            {
                aboutClicked();
            }
        }