public void MatchShouldReturnFirstItemWhenExactMatch_MatchTypeClosestAbove()
{
var func = new Match();
var args = FunctionsHelper.CreateArgs(10, "A1:C1", -1);
var parsingContext = ParsingContext.Create();
parsingContext.Scopes.NewScope(RangeAddress.Empty);
var provider = MockRepository.GenerateStub<ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(WorksheetName,1, 1)).Return(10);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 2)).Return(8);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 3)).Return(5);
parsingContext.ExcelDataProvider = provider;
var result = func.Execute(args, parsingContext);
Assert.AreEqual(1, result.Result);
}
public void MatchShouldReturnIndexOfMatchingValHorizontal_MatchTypeClosestBelow()
{
var func = new Match();
var args = FunctionsHelper.CreateArgs(4, "A1:C1", 1);
var parsingContext = ParsingContext.Create();
parsingContext.Scopes.NewScope(RangeAddress.Empty);
var provider = MockRepository.GenerateStub<ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(WorksheetName,1, 1)).Return(1);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 2)).Return(3);
provider.Stub(x => x.GetCellValue(WorksheetName,1, 3)).Return(5);
parsingContext.ExcelDataProvider = provider;
var result = func.Execute(args, parsingContext);
Assert.AreEqual(2, result.Result);
}