private void ButtonOk_Click(object sender, EventArgs e)
{
ActiveSheet.ClearConditionalFormats(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex);
ConditionalFormat format = Formats[0];
format.ComparisonOperator = expressionControl1.ComparisonOperator;
if (format.ComparisonOperator != ComparisonOperator.IsTrue &&
format.ComparisonOperator != ComparisonOperator.IsFalse &&
format.ComparisonOperator != ComparisonOperator.IsEmpty)
{
if (format.ComparisonOperator == ComparisonOperator.Between ||
format.ComparisonOperator == ComparisonOperator.NotBetween)
{
format.FirstCondition = expressionControl1.StartValue;
format.LastCondition = expressionControl1.EndValue;
if (!string.IsNullOrEmpty(format.FirstCondition) && !string.IsNullOrEmpty(format.LastCondition))
{
ActiveSheet.SetConditionalFormat(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex, 1, 1, format.Style, format.ComparisonOperator, format.FirstCondition, format.LastCondition);
}
}
else
{
format.FirstCondition = expressionControl1.StartValue;
if (!string.IsNullOrEmpty(format.FirstCondition))
{
ActiveSheet.SetConditionalFormat(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex, 1, 1, format.Style, format.ComparisonOperator, format.FirstCondition);
}
}
}
Close();
}