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;
}