/// <summary> /// This method was called from the host instance after selection changed. /// </summary> /// <param name="selectedRange">active selection</param> private void Application_SheetSelectionChangeEvent(NetOffice.COMObject sh, Excel.Range selectedRange) { try { // we check for auto translation and skip selections with more than 256 cells for this simple example if (checkBoxAutoTranslate.Checked && selectedRange.Count <= 256) { ClearError(); textBoxTranslation.Text = string.Empty; foreach (var item in selectedRange) { string requestedText = item.Text as string; if (!String.IsNullOrWhiteSpace(requestedText)) { string translatedText = Client.DataService.Translate( comboBoxSourceLanguage.SelectedItem as string, comboBoxTargetLanguage.SelectedItem as string, requestedText); textBoxTranslation.Text += translatedText + " "; } } } sh.Dispose(); selectedRange.Dispose(); } catch (Exception exception) { ShowError(string.Format("An errror occured. Details: {0}", exception.Message)); } }
private void WorkSheetSelectionChangeEvent(NetOffice.COMObject Sh, Excel.Range Target) { if (Globals.sheet.Name == "BPM批次新增使用者") { if (Target.Column == 3) { if (organizationUnitSelector == null) { organizationUnitSelector = new OrganizationUnitSelector(); } if (Target.Value2.HasValue()) { organizationUnitSelector.selectedOrganizationUnitId = Target.Value2.ToString(); } organizationUnitSelector.ShowDialog(); if (organizationUnitSelector.selectedOrganizationUnitId.HasValue()) { Target.Value2 = organizationUnitSelector.selectedOrganizationUnitId; organizationUnitSelector.selectedOrganizationUnitId = ""; } } } }
void WorksheetActivateEvent(NetOffice.COMObject Sh) { Globals.sheet = (Excel.Worksheet)Sh; }