public void RowsShouldReturnNbrOfRowsForEntireColumn() { var func = new Rows(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); var result = func.Execute(FunctionsHelper.CreateArgs("A:B"), parsingContext); Assert.AreEqual(1048576, result.Result); }
public void RowsWithInvalidArgumentReturnsPoundValue() { var func = new Rows(); var parsingContext = ParsingContext.Create(); var args = FunctionsHelper.CreateArgs(); var result = func.Execute(args, parsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void RowsShouldReturnNbrOfRowsSuppliedRange() { var func = new Rows(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); var result = func.Execute(FunctionsHelper.CreateArgs("A1:B3"), parsingContext); Assert.AreEqual(3, result.Result); }