void RemoveCellVauleRuleCondition(CellValueRule cellVauleRule)
{
if (this.cellValues.ContainsKey(cellVauleRule))
{
this.RemoveConditionsByRange(cellVauleRule.Ranges, this.cellValues[cellVauleRule].ToArray());
}
}
/// <summary>
/// Creates a new object that is a copy of the current instance.
/// </summary>
/// <returns>
/// A new object that is a copy of this instance.
/// </returns>
public override object Clone()
{
CellValueRule rule = base.Clone() as CellValueRule;
rule.value1 = this.value1;
rule.value2 = this.value2;
return(rule);
}
static string GetExpectedFormula(CellValueRule cellValueRule, int index)
{
if ((cellValueRule != null) && (cellValueRule.Condition != null))
{
if (cellValueRule.Condition is RelationCondition)
{
RelationCondition condition = cellValueRule.Condition as RelationCondition;
if (((index != 10) && (index != 11)) || ((condition.Item1 == null) || !(condition.Item1 is RelationCondition)))
{
if (((index != 20) && (index != 0x15)) || ((condition.Item2 == null) || !(condition.Item2 is RelationCondition)))
{
if (((index == 0) && (condition.Item1 != null)) && (condition.Item1.ExpectedFormula != null))
{
return("=" + condition.Item1.ExpectedFormula);
}
if (((index == 1) && (condition.Item2 != null)) && (condition.Item2.ExpectedFormula != null))
{
return("=" + condition.Item2.ExpectedFormula);
}
}
else
{
condition = condition.Item2 as RelationCondition;
if (((index == 20) && (condition.Item1 != null)) && (condition.Item1.ExpectedFormula != null))
{
return("=" + condition.Item1.ExpectedFormula);
}
if (((index == 0x15) && (condition.Item2 != null)) && (condition.Item2.ExpectedFormula != null))
{
return("=" + condition.Item2.ExpectedFormula);
}
}
}
else
{
condition = condition.Item1 as RelationCondition;
if (((index == 10) && (condition.Item1 != null)) && (condition.Item1.ExpectedFormula != null))
{
return("=" + condition.Item1.ExpectedFormula);
}
if (((index == 11) && (condition.Item2 != null)) && (condition.Item2.ExpectedFormula != null))
{
return("=" + condition.Item2.ExpectedFormula);
}
}
}
else if (((index == 0) && (cellValueRule.Condition != null)) && (cellValueRule.Condition.ExpectedFormula != null))
{
return("=" + cellValueRule.Condition.ExpectedFormula);
}
}
return(null);
}
void AddCellValueRuleCondtion(CellValueRule cellValueRule)
{
if (cellValueRule != null)
{
List <DummyCellValue> dummyCellvalues = DummyCellValue.GetDummyCellvalues(cellValueRule);
if (dummyCellvalues.Count > 0)
{
this.cellValues.Add(cellValueRule, dummyCellvalues);
this.AddConditionsByRange(cellValueRule.Ranges, dummyCellvalues.ToArray());
}
}
}
public static List <DummyCellValue> GetDummyCellvalues(CellValueRule cellValueRule)
{
List <DummyCellValue> list = new List <DummyCellValue>();
if (cellValueRule != null)
{
int[] numArray = new int[] { 0, 1, 10, 11, 20, 0x15 };
foreach (int num in numArray)
{
if (GetExpectedFormula(cellValueRule, num) != null)
{
list.Add(new DummyCellValue(cellValueRule, num));
}
}
}
return(list);
}
public DummyCellValue(CellValueRule cellValueRule, int index)
{
this.cellValueRule = cellValueRule;
this.index = index;
}