private void adxExcelAppEvents1_SheetBeforeRightClick(object sender, ADXExcelSheetBeforeEventArgs e)
{
}
private void adxExcelEvents_SheetBeforeDoubleClick(object sender, ADXExcelSheetBeforeEventArgs e)
{
Excel.Range Target = e.Range as Excel.Range;
_address = Target.get_AddressLocal(Target.Row, Target.Column, Microsoft.Office.Interop.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(_address, ExcelApp, formular, _strConnect, _strConnectDes);
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(_address, ExcelApp, formular, _strConnect, _strConnectDes);
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));
}
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(_address, ExcelApp, formular, _strConnect, _strConnectDes);
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(_address, ExcelApp, formular, _strConnect, _strConnectDes);
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));
}
frm.Focus();
e.Cancel = true;
}
}
}
}
