Newer
Older
ClosedXML / ClosedXML_Tests / Excel / PageSetup / PageBreaksTests.cs
@Rozhkov Alexey Rozhkov Alexey on 13 Jan 2017 1 KB Fix test names
using System.Diagnostics;
using ClosedXML.Excel;
using NUnit.Framework;

namespace ClosedXML_Tests.Excel
{
    [TestFixture]
    public class PageBreaksTests
    {
        [Test]
        public void RowBreaksShiftWhenInsertedRowAbove()
        {
            var wb = new XLWorkbook();
            IXLWorksheet sheet = wb.AddWorksheet("Sheet1");

            sheet.PageSetup.AddHorizontalPageBreak(10); 
            sheet.Row(5).InsertRowsAbove(1);
            Assert.AreEqual(11, sheet.PageSetup.RowBreaks[0]);
        }        

        [Test]
        public void RowBreaksNotShiftWhenInsertedRowBelow()
        {
            var wb = new XLWorkbook();
            IXLWorksheet sheet = wb.AddWorksheet("Sheet1");

            sheet.PageSetup.AddHorizontalPageBreak(10); 
            sheet.Row(15).InsertRowsAbove(1);
            Assert.AreEqual(10, sheet.PageSetup.RowBreaks[0]);
        }        

        [Test]
        public void ColumnBreaksShiftWhenInsertedColumnBefore()
        {
            var wb = new XLWorkbook();
            IXLWorksheet sheet = wb.AddWorksheet("Sheet1");

            sheet.PageSetup.AddVerticalPageBreak(10); 
            sheet.Column(5).InsertColumnsBefore(1);
            Assert.AreEqual(11, sheet.PageSetup.ColumnBreaks[0]);
        }        

        [Test]
        public void ColumnBreaksNotShiftWhenInsertedColumnAfter()
        {
            var wb = new XLWorkbook();
            IXLWorksheet sheet = wb.AddWorksheet("Sheet1");

            sheet.PageSetup.AddVerticalPageBreak(10);
            sheet.Column(15).InsertColumnsBefore(1);
            Assert.AreEqual(10, sheet.PageSetup.ColumnBreaks[0]);
        }        
    }
}