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 adxExcelEvents_SheetSelectionChange(object sender, object sheet, object range) { Excel.Range Target = range as Excel.Range; if (frm != null && frm.Status == "I") { _address = Target.get_AddressLocal(Target.Row, Target.Column, Excel.XlReferenceStyle.xlA1, 0, 0); string address = _address.Replace("$", ""); string value = ""; try { value = Target.Value.ToString(); }//(type) catch { } frm.SetValueFocus(address, value); } }
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 ShowAnalysis() { Excel._Worksheet sheet = ExcelApp.ActiveSheet as Excel.Worksheet; _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 (frmdrill == null) { frmdrill = new QDAddinDrillDown(_config, _address, ExcelApp, formular, _strConnectDes, _user); frmdrill.User = _user; frmdrill.Config = _config; frmdrill.FormClosed += new FormClosedEventHandler(frmdrill_FormClosed); //frm.Pos = _address; //frm.TopMost = true; frmdrill.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode)); } //else if (frmdrill.DialogResult == System.Windows.Forms.DialogResult.Yes) //{ // frmdrill.BringToFront(); // frmdrill.GetQueryBuilderFromFomular(formular); //} else { frmdrill.Close(); frmdrill = new QDAddinDrillDown(_config, _address, ExcelApp, formular, _strConnectDes, _user); frmdrill.User = _user; frmdrill.Config = _config; frmdrill.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frmdrill_FormClosed); //frm.Pos = _address; //frm.TopMost = true; frmdrill.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd) } } else { MessageBox.Show("Cell selected is incorrect!"); } }
public string RangeAddress(Excel.Range rng) { return(rng.get_AddressLocal(false, false, Excel.XlReferenceStyle.xlA1)); }
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; } } } }
public void ShowFields() { 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 (formular.Contains("TVC_QUERY") && formular.Contains("USER TABLE")) { string tablename = "data"; try { Excel.Range rangeTableName = ExcelApp.get_Range("A" + _xlsCell.Row); tablename = rangeTableName.Value.ToString(); } catch { } string tmp = formular.Replace("USER TABLE(", ""); formular = tmp.Substring(0, tmp.Length - 1); SQLBuilder _sqlBuilder = new SQLBuilder(processingMode.Details); if (!formular.Contains("TVC_QUERY")) { Parsing.Formular2SQLBuilder(formular, ref _sqlBuilder); } else { Parsing.TVCFormular2SQLBuilder(formular, ref _sqlBuilder); } DataTable dt_list = new DataTable(); if (_sqlBuilder.SelectedNodes.Count > 0) { //CommoControl commo = new CommoControl(); //string connnectString = commo.CreateConnectString(Properties.Settings.Default.Server // , Properties.Settings.Default.User // , Properties.Settings.Default.Pass // , Properties.Settings.Default.DBName); //a.THEME = this.THEME; dt_list.TableName = tablename; dt_list.Columns.Add("Name"); dt_list.Columns.Add("Code"); for (int i = 0; i < _sqlBuilder.SelectedNodes.Count; i++) { Node colum = _sqlBuilder.SelectedNodes[i]; string desc = colum.Description; int dem = 0; for (int j = i - 1; j >= 0; j--) { Node node = _sqlBuilder.SelectedNodes[j]; if (node.Description == colum.Description) { dem++; } } if (dem > 0) { desc = colum.Description + dem; } dt_list.Rows.Add(new string[] { colum.Description, desc }); } TVCDesigner.MainForm frm = new TVCDesigner.MainForm(dt_list, null, null); frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode)); } } }