public void AddressWithTooFewArgumentsReturnsPoundValue() { var function = new OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup.Address(); var args = FunctionsHelper.CreateArgs("One Arg Only"); var result = function.Execute(args, null); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void AddressShouldThrowIfR1C1FormatIsSpecified() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); parsingContext.ExcelDataProvider.Stub(x => x.ExcelMaxRows).Return(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2, (int)ExcelReferenceType.RelativeRowAndColumn, false), parsingContext); }
public void AddressShouldThrowIfR1C1FormatIsSpecified() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = A.Fake <ExcelDataProvider>(); A.CallTo(() => parsingContext.ExcelDataProvider.ExcelMaxRows).Returns(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2, (int)ExcelReferenceType.RelativeRowAndColumn, false), parsingContext); }
public void AddressShouldReturnAddressByWithSpecifiedWorksheet() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); parsingContext.ExcelDataProvider.Stub(x => x.ExcelMaxRows).Return(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2, (int)ExcelReferenceType.RelativeRowAndColumn, true, "Worksheet1"), parsingContext); Assert.AreEqual("Worksheet1!B1", result.Result); }
public void AddressShouldReturnAddressByIndexWithDefaultRefType() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = MockRepository.GenerateStub<ExcelDataProvider>(); parsingContext.ExcelDataProvider.Stub(x => x.ExcelMaxRows).Return(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2), parsingContext); Assert.AreEqual("$B$1", result.Result); }
public void AddressShouldReturnAddressByIndexWithRelativeType() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = A.Fake <ExcelDataProvider>(); A.CallTo(() => parsingContext.ExcelDataProvider.ExcelMaxRows).Returns(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2, (int)ExcelReferenceType.RelativeRowAndColumn), parsingContext); Assert.AreEqual("B1", result.Result); }
public void AddressShouldReturnAddressByIndexWithDefaultRefType() { var func = new AddressFunction(); var parsingContext = ParsingContext.Create(); parsingContext.ExcelDataProvider = A.Fake <ExcelDataProvider>(); A.CallTo(() => parsingContext.ExcelDataProvider.ExcelMaxRows).Returns(10); var result = func.Execute(FunctionsHelper.CreateArgs(1, 2), parsingContext); Assert.AreEqual("$B$1", result.Result); }