Пример #1
0
        private void OKBouton_Click(object sender, EventArgs e)
        {
            int myInt = Convert.ToInt16(SampleSizeTextBox.Text);

            Globals.ThisAddIn.mExcelSimulation.mNSimul = myInt;
            if (mvRangeBool)
            {
                Globals.ThisAddIn.mExcelSimulation.mExcelRange = mvRange;
            }

            Globals.ThisAddIn.mExcelSimulation.mAllInfoBool = mvAllInfoBool;;
            if (mvWorksheetBool)
            {
                Globals.ThisAddIn.Application.Worksheets.Add();
                mvSheetNum = Globals.ThisAddIn.Application.Sheets.Count;
                Excel.Worksheet myWorksheet = Globals.ThisAddIn.Application.ActiveSheet;
                if (myWorksheet != null)
                {
                    string myString;
                    if (!mvAllInfoBool)
                    {
                        myString = "A" + Convert.ToString(myInt + 1);
                    }
                    else
                    {
                        myString = "E" + Convert.ToString(myInt + 1);
                    }

                    Globals.ThisAddIn.mExcelSimulation.mExcelRange = mvRange = myWorksheet.Range["A2", myString];
                }
            }
            if (mvWorkbookBool)
            {
                Globals.ThisAddIn.Application.Workbooks.Add();
                Excel.Worksheet myWorksheet = Globals.ThisAddIn.Application.ActiveSheet;
                if (myWorksheet != null)
                {
                    mvSheetNum = 1;
                    string myString;
                    if (!mvAllInfoBool)
                    {
                        myString = "A" + Convert.ToString(myInt + 1);
                    }
                    else
                    {
                        myString = "E" + Convert.ToString(myInt + 1);
                    }
                    Globals.ThisAddIn.mExcelSimulation.mExcelRange = mvRange = myWorksheet.Range["A2", myString];
                }
            }
            Globals.ThisAddIn.mExcelSimulation.mRangeBool     = mvRangeBool;
            Globals.ThisAddIn.mExcelSimulation.mWorksheetBool = mvWorksheetBool;
            Globals.ThisAddIn.mExcelSimulation.mWorkbookBool  = mvWorkbookBool;
            cExcelCompute myCompute = new cExcelCompute();

            myCompute.Simulation(myInt, Globals.ThisAddIn.mAddInModel);
            Close();
        }
Пример #2
0
        private void OKBouton_Click(object sender, EventArgs e)
        {
            Globals.ThisAddIn.mExcelEstimation.mYtRange = mvYtRange;
            Globals.ThisAddIn.mExcelEstimation.mXtRange = mvXtRange;

            cExcelCompute myCompute = new cExcelCompute();

            Hide();
            ComputingForm myWaitForm = new ComputingForm();

            myWaitForm.Show();
            Globals.ThisAddIn.mDefaultInitPointBool = DefaultRadioButton.Checked;
            myCompute.Estimation(Globals.ThisAddIn.mAddInModel);
            myWaitForm.Close();

            Close();
        }