private void ConditionFormatDialog_Load(object sender, EventArgs e)
{
cBox_Value.Items.Add("单元格数值");
cBox_Value.SelectedIndex = 0;
//初始化活动单元格的条件格式化信息
Formats = ActiveSheet.GetConditionalFormats(ActiveSheet.ActiveRowIndex, ActiveSheet.ActiveColumnIndex);
if (Formats == null || Formats.Length == 0)
{
ConditionalFormat cf = new ConditionalFormat();
cf.ComparisonOperator = ComparisonOperator.Between;
cf.Style = new NamedStyle();
cf.Style.Font = ActiveSheet.ActiveCell.Font;
cf.Style.BackColor = Color.White;
cf.Style.ForeColor = Color.Black;
Formats = new ConditionalFormat[1] {
cf
};
}
ConditionalFormat format = Formats[0];
if (format.ComparisonOperator != ComparisonOperator.IsTrue &&
format.ComparisonOperator != ComparisonOperator.IsFalse &&
format.ComparisonOperator != ComparisonOperator.IsEmpty)
{
cBox_Value.SelectedIndex = 0;
}
if (cBox_Value.SelectedIndex == 0)
{
expressionControl1.BringToFront();
expressionControl1.ComparisonOperator = format.ComparisonOperator;
if (format.ComparisonOperator == ComparisonOperator.Between ||
format.ComparisonOperator == ComparisonOperator.NotBetween)
{
expressionControl1.StartValue = format.FirstCondition;
expressionControl1.EndValue = format.LastCondition;
}
else
{
expressionControl1.StartValue = format.FirstCondition;
}
}
UpdateExample(format.Style);
}
