public void VLOOKUP_False_Type()
{
string formula = "VLOOKUP(I8,[1]Sheet3!A$3:B$84,2,FALSE)";
bool finalParam = LinkAnalysis.TypeofFinalParameter(formula);
Assert.AreEqual(false, finalParam);
}
public void HLOOKUP_Three()
{
string formula = "HLOOKUP(Assumptions!$H$12,IDC!$I$40:$M$56,2+F42)";
int numParams = LinkAnalysis.NumberOfParameters(formula);
Assert.AreEqual(3, numParams);
}
public void One_VLOOKUP_Count()
{
string formula = "IF(VLOOKUP(I8,A5:B100,2,TRUE))";
int numParams = LinkAnalysis.NumberOfParameters(formula);
Assert.AreEqual(4, numParams);
}
public void VLOOKUP_Default()
{
string formula = "VLOOKUP(I8,[1]Sheet3!A$3:B$84,2)";
int numParams = LinkAnalysis.NumberOfParameters(formula);
Assert.AreEqual(3, numParams);
}
public void No_VLOOKUP_Count()
{
string formula = "SUM(A1:A17)";
var allLookups = LinkAnalysis.ReturnLookups(formula);
Assert.AreEqual(0, allLookups.Count);
}
public void Double_Nested_VLOOKUP_Count()
{
string formula = "IF(VLOOKUP(I8,A5:B100,2,TRUE),1,VLOOKUP(I8,A5:B100,3,FALSE))";
var allLookups = LinkAnalysis.ReturnLookups(formula);
Assert.AreEqual(2, allLookups.Count);
}
public void VLOOKUP_True_Count()
{
string formula = "VLOOKUP(I8,[1]Sheet3!A$3:B$84,2,TRUE)";
int numParams = LinkAnalysis.NumberOfParameters(formula);
Assert.AreEqual(4, numParams);
}
protected void Analyze(LambdaExpression expression)
{
var analyzer = new LinkAnalyzer(new MockPortabilityTester());
Analysis = analyzer.Analyze(expression, null);
}
protected void Analyze(Binding binding, object context)
{
var analyzer = new LinkAnalyzer(new MockPortabilityTester());
Analysis = analyzer.Analyze(binding.BindingLambda, context);
}