private void _excelApplication_SheetChange(object Sh, Range Target) { if (SelectedItem != null) { SelectedItem.Column = Target.Column; var nextSelected = EditData.Items.IndexOf(SelectedItem) + 1; if (nextSelected < EditData.Items.Count) { SelectedItem = EditData.Items[nextSelected]; } else { IsAutoCommandBegin = false; Auto(); } } else { SelectedItem = EditData.Items.FirstOrDefault(); _excelApplication_SheetChange(Sh, Target); } }
private void ResetProfileItem(WorkSheetProfileItem item) { item.Column = 0; }