private void ShowComment() { if (_user == "") { MessageBox.Show("Please login..."); return; } try { Excel._Worksheet sheet = (Excel._Worksheet)ExcelApp.ActiveSheet; _xlsCell = (Excel.Range)ExcelApp.ActiveCell; string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString().Replace("$", ""); if (_xlsCell.Comment != null) { string formular = _xlsCell.Comment.Text(Type.Missing, Type.Missing, Type.Missing); if (frm == null) { frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnect, _user); //frm.User = _user; frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //frm.TopMost = true; frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode)); } //else if (frm.DialogResult == System.Windows.Forms.DialogResult.Yes) //{ // frm.BringToFront(); // frm.GetQueryBuilderFromFomular(formular); //} else { frm.Close(); frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.User = _user; frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //frm.TopMost = true; frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd) } } else { MessageBox.Show("Cell selected is incorrect!"); } } catch (Exception ex) { BUS.CommonControl.AddLog("ErroLog", __documentDirectory + "\\Log", "Addin : " + ex.Message + "\n\t" + ex.Source + "\n\t" + ex.StackTrace); } }
private void ShowDesign() { if (_user == "") { MessageBox.Show("Please login..."); return; } Excel._Worksheet sheet = (Excel._Worksheet)ExcelApp.ActiveSheet; _xlsCell = (Excel.Range)ExcelApp.ActiveCell; string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString(); _address = _address.Replace("$", ""); string formular = _xlsCell.Formula.ToString(); if (frm == null) { frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.User = _user; frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //frm.TopMost = true; //IWin32Window wincurrent = new WindowWrapper((IntPtr)ExcelApp.); frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode)); } //else if (frm.DialogResult == System.Windows.Forms.DialogResult.Yes) //{ // frm.BringToFront(); // frm.GetQueryBuilderFromFomular(formular); //} else { frm.Close(); frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.User = _user; frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //frm.TopMost = true; //IWin32Window wincurrent = new WindowWrapper((IntPtr)ExcelApp.Hwnd); frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode)); } }
private void adxExcelEvents_SheetBeforeDoubleClick(object sender, ADXExcelSheetBeforeEventArgs e) { Excel.Range Target = e.Range as Excel.Range; _address = Target.get_AddressLocal(Target.Row, Target.Column, Excel.XlReferenceStyle.xlA1, 0, 0).Replace("$", ""); if (Target.Formula != null) { string formular = Target.Formula.ToString(); if (formular.Contains("TT_XLB_EB") || formular.Contains("USER TABLE")) { //Target.set_Value(Type.Missing, formular); //Application.Undo(); if (frm != null) { frm.Close(); frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //if (value.Contains("TT_XLB_ED")) // frm.GetQueryBuilderFromFomular(value); //frm.TopMost = true; frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd) } else { frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //if (value.Contains("TT_XLB_ED")) // frm.GetQueryBuilderFromFomular(value); //frm.TopMost = true; // frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd) } frm.Focus(); e.Cancel = true; } } else { if (Target.Text != null) { string formular = Target.Text.ToString(); if (formular.Contains("TT_XLB_EB") || formular.Contains("USER TABLE")) { //Target.set_Value(Type.Missing, formular); //Application.Undo(); if (frm != null) { frm.Close(); frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //if (value.Contains("TT_XLB_ED")) // frm.GetQueryBuilderFromFomular(value); //frm.TopMost = true; frm.Show();//new WindowWrapper((IntPtr)ExcelApp.Hwnd) } else { frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user); frm.Config = _config; frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed); //frm.Pos = _address; //if (value.Contains("TT_XLB_ED")) // frm.GetQueryBuilderFromFomular(value); //frm.TopMost = true; // frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));// } frm.Focus(); e.Cancel = true; } } } }