protected CompileResult Lookup(LookupNavigator navigator, LookupArguments lookupArgs)
{
object lastValue = null;
object lastLookupValue = null;
int? lastMatchResult = null;
do
{
var matchResult = IsMatch(navigator.CurrentValue, lookupArgs.SearchedValue);
if (matchResult == 0)
{
return(CreateResult(navigator.GetLookupValue(), DataType.String));
}
if (lookupArgs.RangeLookup)
{
if (lastValue != null && matchResult > 0 && lastMatchResult < 0)
{
return(CreateResult(lastLookupValue, DataType.String));
}
lastMatchResult = matchResult;
lastValue = navigator.CurrentValue;
lastLookupValue = navigator.GetLookupValue();
}
}while (navigator.MoveNext());
throw new ExcelFunctionException("Lookupfunction failed to lookup value", ExcelErrorCodes.NoValueAvaliable);
}
protected CompileResult Lookup(LookupNavigator navigator, LookupArguments lookupArgs)
{
object lastValue = null;
object lastLookupValue = null;
int? lastMatchResult = null;
do
{
var matchResult = IsMatch(navigator.CurrentValue, lookupArgs.SearchedValue);
if (matchResult == 0)
{
return CreateResult(navigator.GetLookupValue(), DataType.String);
}
if (lookupArgs.RangeLookup)
{
if (lastValue != null && matchResult > 0 && lastMatchResult < 0)
{
return CreateResult(lastLookupValue, DataType.String);
}
lastMatchResult = matchResult;
lastValue = navigator.CurrentValue;
lastLookupValue = navigator.GetLookupValue();
}
}
while (navigator.MoveNext());
throw new ExcelFunctionException("Lookupfunction failed to lookup value", ExcelErrorCodes.NoValueAvaliable);
}
public void GetLookupValueShouldReturnCorrespondingValueWithOffset()
{
var provider = MockRepository.GenerateStub<ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(2, 2)).Return(new ExcelCell(4, null, 0, 0));
var args = new LookupArguments(3, "A1:A4", 3, 2, false);
var navigator = new LookupNavigator(LookupDirection.Vertical, args, GetContext(provider));
Assert.AreEqual(4, navigator.GetLookupValue());
}