Exemplos de OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup Address.Execute em C# (CSharp)

Exemplo n.º 1

Arquivo: RefAndLookupTests.cs Projeto: nxoxn/EPPlus

		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);
		}

Exemplo n.º 2

Arquivo: RefAndLookupTests.cs Projeto: princeoffoods/EPPlus

 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);
 }

Exemplo n.º 3

Arquivo: RefAndLookupTests.cs Projeto: nxoxn/EPPlus

		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);
		}

Exemplo n.º 4

Arquivo: RefAndLookupTests.cs Projeto: yosmanyhs/EPPlus-1

        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);
        }

Exemplo n.º 5

Arquivo: RefAndLookupTests.cs Projeto: princeoffoods/EPPlus

 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);
 }

Exemplo n.º 6

Arquivo: RefAndLookupTests.cs Projeto: princeoffoods/EPPlus

 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);
 }

Exemplo n.º 7

Arquivo: RefAndLookupTests.cs Projeto: nxoxn/EPPlus

		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);
		}

Exemplo n.º 8

Arquivo: RefAndLookupTests.cs Projeto: nxoxn/EPPlus

		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);
		}

Exemplo n.º 9

Arquivo: RefAndLookupTests.cs Projeto: yosmanyhs/EPPlus-1

        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);
        }

Exemplo n.º 10

Arquivo: RefAndLookupTests.cs Projeto: yosmanyhs/EPPlus-1

        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);
        }