Ejemplo n.º 1
0
        public void FakeTablePartExtractionTest()
        {
            const int width  = 20;
            const int height = 40;
            var       table  = new FakeTable(width, height);

            for (var x = 0; x < width; ++x)
            {
                for (var y = 0; y < height; ++y)
                {
                    table.InsertCell(new CellPosition(y + 1, x + 1));
                }
            }

            var positions    = new[] { new CellPosition(1, 1), new CellPosition(40, 20), new CellPosition(10, 10) };
            var stringValues = new[] { "Test Value", "Test Test", "Another text" };

            for (var i = 0; i < positions.Count(); ++i)
            {
                var cell = table.InsertCell(positions[i]);
                cell.StringValue = stringValues[i];
            }

            var tablePart = table.GetTablePart(new Rectangle(new CellPosition(9, 9), new CellPosition(40, 20)));

            tablePart.Cells.Count().Should().Be(32);

            foreach (var row in tablePart.Cells)
            {
                row.Count().Should().Be(12);
            }

            var targetRow = tablePart.Cells.FirstOrDefault(row => row.FirstOrDefault(cell => cell.StringValue == "Another text") != null);

            targetRow.Should().NotBeNull();
// ReSharper disable AssignNullToNotNullAttribute
            var targetCell = targetRow.FirstOrDefault(cell => cell.StringValue == "Another text");

// ReSharper restore AssignNullToNotNullAttribute

            targetCell.Should().NotBeNull();
// ReSharper disable PossibleNullReferenceException
            targetCell.CellPosition.RowIndex.Should().Be(10);
// ReSharper restore PossibleNullReferenceException
            targetCell.CellPosition.ColumnIndex.Should().Be(10);

            targetRow = tablePart.Cells.LastOrDefault();
            targetRow.Should().NotBeNull();
// ReSharper disable AssignNullToNotNullAttribute
            targetCell = tablePart.Cells.LastOrDefault().LastOrDefault();
            // ReSharper restore AssignNullToNotNullAttribute
            targetCell.Should().NotBeNull();

// ReSharper disable PossibleNullReferenceException
            targetCell.StringValue.Should().Be("Test Test");
// ReSharper restore PossibleNullReferenceException
        }
        public void SimpleTestWithArray()
        {
            var model = new[] { "a", "b", "c", "d", "e" };

            var template = new FakeTable(1, 1);
            var cell     = template.InsertCell(new CellPosition(1, 1));

            cell.StringValue = "Template:RootTemplate:A1:A1";

            var templateEngine = new SkbKontur.Excel.TemplateEngine.TemplateEngine(template, logger);

            var target       = new FakeTable(10, 10);
            var tableBuilder = new TableBuilder(target, new TableNavigator(new CellPosition("B2"), logger), new Style(new FakeCell(new CellPosition("A1"))
            {
                StyleId = "(1,1)"
            }));

            templateEngine.Render(tableBuilder, model);

            target.GetCell(new CellPosition("B2")).StringValue.Should().Be("a");
            target.GetCell(new CellPosition("B3")).StringValue.Should().Be("b");
            target.GetCell(new CellPosition("B4")).StringValue.Should().Be("c");
            target.GetCell(new CellPosition("B5")).StringValue.Should().Be("d");
            target.GetCell(new CellPosition("B6")).StringValue.Should().Be("e");

            DebugPrinting(target, new CellPosition(1, 1), new CellPosition(10, 10));
        }
Ejemplo n.º 3
0
        public void FakeTableCellSearchTest()
        {
            const int width  = 20;
            const int height = 40;
            var       table  = new FakeTable(width, height);

            var positions    = new[] { new CellPosition(1, 1), new CellPosition(40, 20), new CellPosition(10, 10) };
            var stringValues = new[] { "Test Value", "Test Test", "Another text" };

            for (var i = 0; i < positions.Count(); ++i)
            {
                var cell = table.InsertCell(positions[i]);
                cell.StringValue = stringValues[i];
            }

            var cells      = table.SearchCellByText("Test");
            var cellsArray = cells as ICell[] ?? cells.ToArray();

            cellsArray.Length.Should().Be(2);
            cellsArray[0].Should().NotBeNull();
            cellsArray[1].Should().NotBeNull();

            cellsArray[0].CellPosition.RowIndex.Should().Be(1);
            cellsArray[0].CellPosition.ColumnIndex.Should().Be(1);
            cellsArray[1].CellPosition.RowIndex.Should().Be(40);
            cellsArray[1].CellPosition.ColumnIndex.Should().Be(20);
        }
Ejemplo n.º 4
0
        public void FakeTableWrongPositionCellInsertionTest(int wrongRowIndex, int wrongColumnIndex)
        {
            const int width  = 20;
            const int height = 40;
            var       table  = new FakeTable(width, height);

            var cell = table.InsertCell(new CellPosition(wrongRowIndex, wrongColumnIndex));

            cell.Should().BeNull();
        }
Ejemplo n.º 5
0
        public void FakeTableCellInsertionTest()
        {
            const int width  = 20;
            const int height = 40;
            var       table  = new FakeTable(width, height);

            var position = new CellPosition(10, 10);
            var cell     = table.InsertCell(position);

            cell.Should().NotBeNull();
        }
Ejemplo n.º 6
0
        public void FakeTableCellManipulationTest()
        {
            const int width  = 20;
            const int height = 40;
            var       table  = new FakeTable(width, height);

            var position = new CellPosition(10, 10);
            var cell     = table.InsertCell(position);

            cell.Should().NotBeNull();

            const string testValue = "Test Value";

            cell.StringValue = testValue;

            cell = table.GetCell(position);

            cell.Should().NotBeNull();
            cell.StringValue.Should().Be(testValue);
        }
        public void StringValuePrintingTest()
        {
            var template = new FakeTable(1, 1);
            var cell     = template.InsertCell(new CellPosition(1, 1));

            cell.StringValue = "Template:RootTemplate:A1:A1";

            var templateEngine = new SkbKontur.Excel.TemplateEngine.TemplateEngine(template, logger);

            var target       = new FakeTable(10, 10);
            var tableBuilder = new TableBuilder(target, new TableNavigator(new CellPosition("B2"), logger), new Style(new FakeCell(new CellPosition("A1"))
            {
                StyleId = "(1,1)"
            }));

            templateEngine.Render(tableBuilder, "TestStringValue");

            target.GetCell(new CellPosition("B2")).StringValue.Should().Be("TestStringValue");

            ((FakeCell)target.GetCell(new CellPosition("B2"))).StyleId.Should().Be("(1,1)");
        }