public void HasNextShouldBeTrueIfNotLastCell()
{
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(4, null, 0, 0));
var args = GetArgs(3, "A1:B2", 1);
var navigator = new LookupNavigator(LookupDirection.Vertical, args, GetContext(provider));
Assert.IsTrue(navigator.MoveNext());
}
public void CurrentValueShouldBeFirstCell()
{
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(4, null, 0, 0));
var args = GetArgs(3, "A1:B2", 1);
var navigator = new LookupNavigator(LookupDirection.Vertical, args, GetContext(provider));
Assert.AreEqual(3, navigator.CurrentValue);
}
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());
}
public void MoveNextShouldIncreaseIndex()
{
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(4, null, 0, 0));
var args = GetArgs(6, "A1:B2", 1);
var navigator = new LookupNavigator(LookupDirection.Vertical, args, GetContext(provider));
Assert.AreEqual(0, navigator.Index);
navigator.MoveNext();
Assert.AreEqual(1, navigator.Index);
}
public void NavigatorShouldEvaluateFormula()
{
var provider = MockRepository.GenerateStub <ExcelDataProvider>();
provider.Stub(x => x.GetCellValue(0, 0)).Return(new ExcelCell(3, null, 0, 0));
provider.Stub(x => x.GetCellValue(1, 0)).Return(new ExcelCell(null, "B5", 0, 0));
var args = GetArgs(4, "A1:B2", 1);
var context = GetContext(provider);
var parser = MockRepository.GenerateMock <FormulaParser>(provider);
context.Parser = parser;
var navigator = new LookupNavigator(LookupDirection.Vertical, args, context);
navigator.MoveNext();
parser.AssertWasCalled(x => x.Parse("B5"));
}
