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