public void TestGetRanges2()
{
var f = "=A1:B3";
if (MockWorkbook.TestGetRanges(f) != 1)
{
throw new Exception("GetReferencesFromFormula should return 1 range for " + f);
}
}
public void TestGetRanges3()
{
var f = "=SUM(A1:B3)+AVERAGE(C2:C8)";
if (MockWorkbook.TestGetRanges(f) != 2)
{
throw new Exception("GetReferencesFromFormula should return 2 ranges for " + f);
}
}
public void TestGetRanges1()
{
var f = "=A1";
if (MockWorkbook.TestGetRanges(f) != 0)
{
throw new Exception("GetReferencesFromFormula should return no ranges for " + f);
}
}
