public void Test6() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("Z7", 1.5); Assert.AreEqual(1.5, (double)s.GetCellContents("Z7"), 1e-9); }
public void Test10() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("Z7", "hello"); Assert.AreEqual("hello", s.GetCellContents("Z7")); }
public void Test30() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("A1", "Hello"); s.SetCellContents("A1", new Formula("23")); Assert.AreEqual(23, ((Formula)s.GetCellContents("A1")).Evaluate(x => 0)); }
public void Test29() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("A1", new Formula("A2+A3")); s.SetCellContents("A1", "Hello"); Assert.AreEqual("Hello", (string)s.GetCellContents("A1")); }
public void Test28() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("A1", new Formula("A2+A3")); s.SetCellContents("A1", 2.5); Assert.AreEqual(2.5, (double)s.GetCellContents("A1"), 1e-9); }
public void Test13() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.SetCellContents("Z7", new Formula("3")); Formula f = (Formula)s.GetCellContents("Z7"); Assert.AreEqual(3, f.Evaluate(x => 0), 1e-6); }
public void Test16() { TesttableSpreadsheet s = new TesttableSpreadsheet(); try { s.SetCellContents("A1", new Formula("A2+A3")); s.SetCellContents("A2", 15); s.SetCellContents("A3", 30); s.SetCellContents("A2", new Formula("A3*A1")); } catch (CircularException e) { Assert.AreEqual(15, (double)s.GetCellContents("A2"), 1e-9); throw e; } }
public void Test3() { TesttableSpreadsheet s = new TesttableSpreadsheet(); Assert.AreEqual("", s.GetCellContents("A2")); }
public void Test2() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.GetCellContents("AA"); }
public void Test1() { TesttableSpreadsheet s = new TesttableSpreadsheet(); s.GetCellContents(null); }