public void To() { var s = new CellLoc(1, 1); var e = new CellLoc(3, 3); var locs = s.To(e).Sort(); var rlocs = e.To(s).Sort(); Assert.AreEqual(locs.Print(), rlocs.Print()); Assert.AreEqual("([1,1],[1,2],[1,3],[2,1],[2,2],[2,3],[3,1],[3,2],[3,3])", locs.Print()); }
public void Operators() { var c11 = new CellLoc(1, 1); var c12 = new CellLoc(1, 2); var c32 = new CellLoc(3, 2); Assert.IsFalse(c11 == c12); Assert.IsTrue(c11 != c12); Assert.IsTrue(c11 == c12.Left()); Assert.IsTrue(c11.Right() == c12); Assert.IsTrue(c12.Below(2) == c32); Assert.IsFalse(c12 == c32.Above()); object o11 = c11; Assert.IsTrue(c11.CompareTo(o11) == 0); Assert.IsTrue(c11.CompareTo(DateTime.Now) != 0); }
public static string Value(this DataTable dt, CellLoc loc) { return dt.Rows[loc.Row][loc.Col].ConvertTo<string>(); }
public void ToSelf() { var s = new CellLoc(5, 5); var locs = s.To(s); Assert.AreEqual("([5,5])", locs.Print()); }
public void Range() { var x = new CellLoc(1, 1); Assert.AreEqual("([1,1],[1,2],[1,3],[1,4])", x.ColRange(4).Print()); Assert.AreEqual("([1,1],[2,1],[3,1])", x.RowRange(3).Print()); }
public void NegativeRange() { var x = new CellLoc(5, 5); Assert.AreEqual("([5,5],[5,4],[5,3],[5,2],[5,1])", x.ColRange(-5).Print()); Assert.AreEqual("([5,5],[4,5],[3,5],[2,5],[1,5])", x.RowRange(-5).Print()); }