public void ScrollRightWithNoFrozenColumnsColumnsDontFit()
{
var data = Utilities.CreateTable(new string[] { "A", "B", "C", "D" },
new List <object[]> {
new object[] { "a1", "b1", "c1", "d1" },
new object[] { "a2", "b2", "c2", "d2" },
new object[] { "a3", "b3", "c3", "d3" },
new object[] { "a4", "b4", "c4", "d4" }
});
var units = new string[] { null, "g/m2", null, null };
var sheet = new Sheet();
sheet.DataProvider = new DataTableProvider(data, units);
sheet.NumberFrozenRows = 1;
sheet.NumberFrozenColumns = 0;
sheet.Width = 60;
sheet.Height = 80;
sheet.ColumnWidths = new int[] { 20, 20, 20, 20 };
sheet.ScrollRight();
// assumes cellpadding of 2 x 10, rowHeight = 35
// Row 0
Assert.IsNull(sheet.CalculateBounds(0, 0)); // hidden
Assert.AreEqual(new CellBounds(0, 0, 20, 35), sheet.CalculateBounds(1, 0));
Assert.AreEqual(new CellBounds(20, 0, 20, 35), sheet.CalculateBounds(2, 0));
Assert.AreEqual(new CellBounds(40, 0, 20, 35), sheet.CalculateBounds(3, 0));
// Row 1
Assert.IsNull(sheet.CalculateBounds(0, 1)); // hidden
Assert.AreEqual(new CellBounds(0, 35, 20, 35), sheet.CalculateBounds(1, 1));
Assert.AreEqual(new CellBounds(20, 35, 20, 35), sheet.CalculateBounds(2, 1));
Assert.AreEqual(new CellBounds(40, 35, 20, 35), sheet.CalculateBounds(3, 1));
// Row 2
Assert.IsNull(sheet.CalculateBounds(0, 2)); // hidden
Assert.AreEqual(new CellBounds(0, 70, 20, 35), sheet.CalculateBounds(1, 2));
Assert.AreEqual(new CellBounds(20, 70, 20, 35), sheet.CalculateBounds(2, 2));
Assert.AreEqual(new CellBounds(40, 70, 20, 35), sheet.CalculateBounds(3, 2));
// Row 3
Assert.IsNull(sheet.CalculateBounds(0, 3));
Assert.IsNull(sheet.CalculateBounds(1, 3));
Assert.IsNull(sheet.CalculateBounds(2, 3));
Assert.IsNull(sheet.CalculateBounds(3, 3));
}
public void ScrollLeftWithOneFrozenColumnColumnsDontFit()
{
var data = Utilities.CreateTable(new string[] { "A", "B", "C", "D" },
new List <object[]> {
new object[] { "a1", "b1", "c1", "d1" },
new object[] { "a2", "b2", "c2", "d2" },
new object[] { "a3", "b3", "c3", "d3" },
new object[] { "a4", "b4", "c4", "d4" }
});
var units = new string[] { null, "g/m2", null, null };
var sheet = new Sheet();
sheet.DataProvider = new DataTableProvider(data, units);
sheet.NumberFrozenRows = 1;
sheet.NumberFrozenColumns = 1;
sheet.Width = 80;
sheet.Height = 80;
sheet.ColumnWidths = new int[] { 10, 20, 30, 40 };
sheet.ScrollRight(); // This will have to scroll right 2 columns because column indexes 1,2,3 won't fit into a width of 80 pixels.
sheet.ScrollLeft();
sheet.ScrollLeft();
// assumes cellpadding of 2 x 10, rowHeight = 35
Assert.AreEqual(new CellBounds(0, 0, 10, 35), sheet.CalculateBounds(0, 0));
Assert.AreEqual(new CellBounds(10, 0, 20, 35), sheet.CalculateBounds(1, 0));
Assert.AreEqual(new CellBounds(30, 0, 30, 35), sheet.CalculateBounds(2, 0));
Assert.AreEqual(new CellBounds(60, 0, 40, 35), sheet.CalculateBounds(3, 0));
// Row 1
Assert.AreEqual(new CellBounds(0, 35, 10, 35), sheet.CalculateBounds(0, 1));
Assert.AreEqual(new CellBounds(10, 35, 20, 35), sheet.CalculateBounds(1, 1));
Assert.AreEqual(new CellBounds(30, 35, 30, 35), sheet.CalculateBounds(2, 1));
Assert.AreEqual(new CellBounds(60, 35, 40, 35), sheet.CalculateBounds(3, 1));
// Row 2
Assert.AreEqual(new CellBounds(0, 70, 10, 35), sheet.CalculateBounds(0, 2));
Assert.AreEqual(new CellBounds(10, 70, 20, 35), sheet.CalculateBounds(1, 2));
Assert.AreEqual(new CellBounds(30, 70, 30, 35), sheet.CalculateBounds(2, 2));
Assert.AreEqual(new CellBounds(60, 70, 40, 35), sheet.CalculateBounds(3, 2));
// Row 3
Assert.IsNull(sheet.CalculateBounds(0, 3));
Assert.IsNull(sheet.CalculateBounds(1, 3));
Assert.IsNull(sheet.CalculateBounds(2, 3));
Assert.IsNull(sheet.CalculateBounds(3, 3));
}
