/// <summary>
/// Help toolbar button event handler
/// </summary>
/// <param name="Ctrl"></param>
/// <param name="CancelDefault"></param>
void m_HelpButton_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
if (m_helpUrl == null)
{
StringBuilder helpUrl = new StringBuilder(Properties.Resources.HelpURL);
Assembly asm = Assembly.GetExecutingAssembly();
Version version = asm.GetName().Version;
string edition = "Community";
object[] attr = asm.GetCustomAttributes(typeof(AssemblyConfigurationAttribute), false);
if (attr.Length > 0)
{
AssemblyConfigurationAttribute aca = (AssemblyConfigurationAttribute)attr[0];
edition = aca.Configuration;
}
helpUrl.Replace("{major}", version.Major.ToString());
helpUrl.Replace("{minor}", version.Minor.ToString());
helpUrl.Replace("{edition}", edition);
m_helpUrl = helpUrl.ToString();
}
System.Diagnostics.Process.Start(m_helpUrl);
}
//点击菜单事件
private void clearCaseAddressCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
Excel.Workbook workbook = (Excel.Workbook)Globals.FxtAddIn.Application.ActiveWorkbook;
Excel.Worksheet worksheet = workbook.Sheets[2];
worksheet.Activate();
Range rg = worksheet.UsedRange;
rg.AdvancedFilter(XlFilterAction.xlFilterCopy, Type.Missing, worksheet.get_Range("B1"), true);
rg = worksheet.get_Range("b1", "b" + rg.Rows.Count.ToString());
int lRow = rg.get_End(XlDirection.xlDown).Row;
rg = worksheet.get_Range("c1", "C" + lRow.ToString());
rg.Cells[1, 1].Formula = "=Len(B1)";
rg.FillDown();
//排序
rg = worksheet.get_Range("B1", "C" + lRow.ToString());
rg.Sort(rg.Cells[1, 2], XlSortOrder.xlDescending);
//处理
worksheet = workbook.Sheets[1];
worksheet.Activate();
Globals.FxtAddIn.Application.DisplayAlerts = false;
Globals.FxtAddIn.Application.EnableEvents = true;
Range rg1 = worksheet.get_Range("A1", "A" + worksheet.UsedRange.Rows.Count.ToString());
rg1.EntireColumn.Insert(XlInsertShiftDirection.xlShiftDown, false);
rg1.Copy(worksheet.get_Range("A1"));
for (int i = 1; i <= rg.Rows.Count; i++)
{
string sKey = rg.Cells[i, 1].Value;
rg1.Replace("*" + sKey + "*", sKey, Type.Missing, Type.Missing, false, Type.Missing, false, false);
}
Globals.FxtAddIn.Application.DisplayAlerts = true;
MessageBox.Show("处理完成！");
}
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();
}
}
void RoundTripCheckFont_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
if (!HookDocumentClose(Application.ActiveDocument))
{
return;
}
Application.System.Cursor = Word.WdCursorType.wdCursorWait;
try
{
WordDocument doc = new WordDocument(Application.ActiveDocument, OfficeTextDocument.ProcessingType.eWordByWord);
if (m_aRoundTripCheckFontWordProcessor == null)
{
// first get the fonts the user wants to process
FontConvertersPicker aFCsPicker = new FontConvertersPicker(doc);
if (aFCsPicker.ShowDialog() == DialogResult.OK)
{
FontConverters aFCs = aFCsPicker.SelectedFontConverters;
m_aRoundTripCheckFontWordProcessor = new RoundTripCheckWordProcessor(aFCs);
}
}
if (m_aRoundTripCheckFontWordProcessor != null)
{
if (doc.ProcessWordByWord(m_aRoundTripCheckFontWordProcessor))
{
m_aRoundTripCheckFontWordProcessor = null;
}
}
}
catch (Exception ex)
{
DisplayException(ex);
}
Application.System.Cursor = Word.WdCursorType.wdCursorNormal;
}
void FindReplace_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
if (!HookDocumentClose(Application.ActiveDocument))
{
return;
}
try
{
if (m_formFindReplace == null)
{
WordFindReplaceDocument doc = new WordFindReplaceDocument(Application.ActiveDocument);
m_formFindReplace = new FindReplaceForm(doc);
}
m_formFindReplace.Show();
m_formFindReplace.BringToFront();
}
catch (Exception ex)
{
DisplayException(ex);
}
}
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();
}
}
/// <summary>
/// Events when user click button in menu bar plugin
/// </summary>
/// <param name="Ctrl"></param>
/// <param name="CancelDefault"></param>
private void buttonOne_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
if (currentProfileName != Application.Session.CurrentProfileName)
{
WriteDefaultSettings();
}
FormSettings formSettings = new FormSettings(listBLS,
listDisableBLS,
listSafeSenders,
IsSaveErrorLog,
pathToErrorLog,
entryIDSpamFolder,
entryIDStoreSpamFolder,
spamSignWord,
nameSpamChoosedFolder);
formSettings.OutlookApplication = Application;
DialogResult dr = formSettings.ShowDialog();
if (dr == DialogResult.OK)
{
listBLS = formSettings.EnableBLS;
listDisableBLS = formSettings.DisableBLS;
listSafeSenders = formSettings.SafeSenders;
IsSaveErrorLog = formSettings.IsSaveLog;
pathToErrorLog = formSettings.PathToErrorLog;
entryIDSpamFolder = formSettings.EntryIDSpamFolder;
entryIDStoreSpamFolder = formSettings.EntryIDStoreSpamFolder;
spamSignWord = formSettings.SpamSignWord;
nameSpamChoosedFolder = formSettings.NameSpamChoosedFolder;
currentProfileName = Application.Session.CurrentProfileName;
SaveXML();
}
SaveToLog(formSettings.ErrorLog, pathToErrorLog);
}
void ConvertTableField_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
#endif
{
try
{
if (Application.Selection == null)
{
throw new ApplicationException("First select the cells that you want to convert using a system converter");
}
ExcelDocument doc = new ExcelDocument(Application.Selection);
if (m_aSelectionProcessor == null)
{
string strTitle = "Choose the converter for the selected areas/cells";
EncConverters aECs = GetEncConverters;
if (aECs != null)
{
IEncConverter aIEC = aECs.AutoSelectWithTitle(ConvType.Unknown, strTitle);
FontConverter aFC = new FontConverter(new DirectableEncConverter(aIEC));
m_aSelectionProcessor = new OfficeDocumentProcessor(aFC, new SILConverterProcessorForm());
}
}
if (m_aSelectionProcessor != null)
{
if (doc.ProcessWordByWord(m_aSelectionProcessor))
{
m_aSelectionProcessor = null;
}
}
}
catch (Exception ex)
{
DisplayException(ex);
}
}
void _oBtn_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
Excel._Worksheet sheet = (Excel._Worksheet)Application.ActiveWorkbook.ActiveSheet;
_xlsCell = (Excel.Range)Application.ActiveCell;
string _address = _xlsCell.get_AddressLocal(1, 1, Microsoft.Office.Interop.Excel.XlReferenceStyle.xlA1, 0, 0).ToString();
_address = _address.Replace("$", "");
string formular = _xlsCell.Formula.ToString();
if (frm == null)
{
frm = new QDAddIn(_address, Application, formular, _strConnect, _strConnectDes);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
IWin32Window wincurrent = new WindowWrapper((IntPtr)Application.Hwnd);
frm.Show(wincurrent);
}
//else if (frm.DialogResult == System.Windows.Forms.DialogResult.Yes)
//{
// frm.BringToFront();
// frm.GetQueryBuilderFromFomular(formular);
//}
else
{
frm.Close();
frm = new QDAddIn(_address, Application, formular, _strConnect, _strConnectDes);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
IWin32Window wincurrent = new WindowWrapper((IntPtr)Application.Hwnd);
frm.Show(wincurrent);
}
}
// Add text to cell A1 when the menu is clicked.
private void menuCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
Globals.Sheet1.Range["A1"].Value2 = "The menu command was clicked.";
}
private void HandleMenuClickLow(Microsoft.Office.Core.CommandBarButton clickedControl, ref bool cancelDefault)
{
// First we need to find which Button was clicked
string[] idParts = clickedControl.DescriptionText.Split(new[] { StaticHelper.SplitSequence }, StringSplitOptions.RemoveEmptyEntries);
Send(idParts[0], clickedControl.Tag, OlImportance.olImportanceLow);
}
private void AddToolbar()
{
if (newToolBar == null)
{
Office.CommandBars cmdBars = this.Application.ActiveExplorer().CommandBars;
//cmdBars.
newToolBar = cmdBars.Add("Banckle CRM", Office.MsoBarPosition.msoBarTop, false, true);
}
try
{
//Office.
btnBanckle = (Office.CommandBarButton)newToolBar.Controls.Add(1, missing, missing, missing, missing);
btnBanckle.Style = Office.MsoButtonStyle.msoButtonIcon;
btnBanckle.Caption = "Banckle CRM";
btnBanckle.Tag = "Banckle CRM";
btnBanckle.Picture = getImage(Properties.Resources.crm_16x16);
btnBanckle.Click += new Office._CommandBarButtonEvents_ClickEventHandler(btnBanckleClick);
btnSync = (Office.CommandBarButton)newToolBar.Controls.Add(1, missing, missing, missing, missing);
btnSync.Style = Office.MsoButtonStyle.msoButtonIconAndCaption;
btnSync.Caption = "Sync";
btnSync.Tag = "Sync";
btnSync.Picture = getImage(Properties.Resources.sync_16x16);
btnSync.BeginGroup = true;
btnSync.Click += new Office._CommandBarButtonEvents_ClickEventHandler(btnSyncClick);
btnSettings = (Office.CommandBarButton)newToolBar.Controls.Add(1, missing, missing, missing, missing);
btnSettings.Style = Office.MsoButtonStyle.msoButtonIconAndCaption;
btnSettings.Caption = "Settings";
btnSettings.Picture = getImage(Properties.Resources.settings_16x16);
btnSettings.Tag = "Settings";
newToolBar.Visible = true;
btnSettings.Click += new Office._CommandBarButtonEvents_ClickEventHandler(btnSettingsClick);
btnAbout = (Office.CommandBarButton)newToolBar.Controls.Add(1, missing, missing, missing, missing);
btnAbout.Style = Office.MsoButtonStyle.msoButtonIconAndCaption;
btnAbout.Caption = "About";
btnAbout.Picture = getImage(Properties.Resources.banckle_16x16);
btnAbout.BeginGroup = true;
btnAbout.Tag = "About";
btnAbout.Visible = true;
btnAbout.Click += new Office._CommandBarButtonEvents_ClickEventHandler(btnAboutClick);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Error:" + ex.Message, "Error");
}
}
void ThisStoryConvert_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
ThisStoryConvert();
}
void DividendMenuItemClick(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
ribbon_btnDividendClicked();
}
/// <summary>
/// Help toolbar button event handler
/// </summary>
/// <param name="Ctrl"></param>
/// <param name="CancelDefault"></param>
void m_HelpButton_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
System.Diagnostics.Process.Start(Properties.Resources.HelpURL);
}
void WholeDocumentConvert_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
WholeDocumentConvert();
}
void SelectionConvert_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
SelectionConvert();
}
void Reset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
DocumentClosed();
}
void menuItemOpenXWikiPage_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
UIActions.ActionOpenWikiPage();
}
void menuItemNew_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
UIActions.ActionNewSpaceOrPage();
}
private void btnConfigureerNieuwsbrief_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
FrmConfiguration configuratievenster = new FrmConfiguration(this.configuration);
configuratievenster.ShowDialog();
}
void Reset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
#endif
{
m_aSelectionProcessor = null;
}
private void btnCreateCustomItem_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
mail = Application.CreateItem(Microsoft.Office.Interop.Outlook.OlItemType.olMailItem) as Outlook.MailItem;
mail.MessageClass = "IPM.Note.ImportedFormRegion";
mail.Display(missing);
}
void SpellFixerReset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
m_aSF = null;
m_aWordByWordSpellFixerProcessor = null;
m_aWordByWordFontSpellFixerProcessor = null;
}
void Reset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
Reset();
}
void menuItemPublishXWikiPage_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
UIActions.ActionPublishCurrentPage();
}
private void btnStelNieuwsbriefOp_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
Synchroniseer();
SendMassMail();
}
void Reset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
m_aWordByWordProcessor = null;
m_aWordByWordFontProcessor = null;
}
void menuItemAboutXWord_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
UIActions.ActionAboutXWord();
}
void RoundTripReset_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
m_aRoundTripCheckWordProcessor = null;
m_aRoundTripCheckFontWordProcessor = null;
}
void menuItemXWordSettings_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault)
{
UIActions.ActionXWordSettings();
}
