public void Test6()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("Z7", 1.5);
Assert.AreEqual(1.5, (double)s.GetCellContents("Z7"), 1e-9);
}
public void Test31()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("B1+B2"));
s.SetCellContents("B1", new Formula("C1-C2"));
s.SetCellContents("B2", new Formula("C3*C4"));
s.SetCellContents("C1", new Formula("D1*D2"));
s.SetCellContents("C2", new Formula("D3*D4"));
s.SetCellContents("C3", new Formula("D5*D6"));
s.SetCellContents("C4", new Formula("D7*D8"));
s.SetCellContents("D1", new Formula("E1"));
s.SetCellContents("D2", new Formula("E1"));
s.SetCellContents("D3", new Formula("E1"));
s.SetCellContents("D4", new Formula("E1"));
s.SetCellContents("D5", new Formula("E1"));
s.SetCellContents("D6", new Formula("E1"));
s.SetCellContents("D7", new Formula("E1"));
s.SetCellContents("D8", new Formula("E1"));
ISet <String> cells = s.SetCellContents("E1", 0);
AssertSetEqualsIgnoreCase(new HashSet <string>()
{
"A1", "B1", "B2", "C1", "C2", "C3", "C4", "D1", "D2", "D3", "D4", "D5", "D6", "D7", "D8", "E1"
}, cells);
}
public void Test22()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("B1", new Formula("3.5"));
AssertSetEqualsIgnoreCase(s.GetNamesOfAllNonemptyCells(), new string[] { "B1" });
}
public void Test14()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("A2"));
s.SetCellContents("A2", new Formula("A1"));
}
public void Test18()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("B1", "");
Assert.IsFalse(s.GetNamesOfAllNonemptyCells().GetEnumerator().MoveNext());
}
public void RunRandomizedTest(int seed, int size)
{
TestableSpreadsheet s = new TestableSpreadsheet();
Random rand = new Random(seed);
for (int i = 0; i < 10000; i++)
{
try
{
switch (rand.Next(3))
{
case 0:
s.SetCellContents(randomName(rand), 3.14);
break;
case 1:
s.SetCellContents(randomName(rand), "hello");
break;
case 2:
s.SetCellContents(randomName(rand), randomFormula(rand));
break;
}
}
catch (CircularException)
{
}
}
ISet <string> set = new HashSet <string>(s.GetNamesOfAllNonemptyCells());
Assert.AreEqual(size, set.Count);
}
public void Test10()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("Z7", "hello");
Assert.AreEqual("hello", s.GetCellContents("Z7"));
}
public void Test29()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("A2+A3"));
s.SetCellContents("A1", "Hello");
Assert.AreEqual("Hello", (string)s.GetCellContents("A1"));
}
public void Test26()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", 17.2);
s.SetCellContents("B1", "hello");
AssertSetEqualsIgnoreCase(s.SetCellContents("C1", new Formula("5")), new string[] { "C1" });
}
public void Test30()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", "Hello");
s.SetCellContents("A1", new Formula("23"));
Assert.AreEqual(23, ((Formula)s.GetCellContents("A1")).Evaluate(x => 0));
}
public void Test28()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("A2+A3"));
s.SetCellContents("A1", 2.5);
Assert.AreEqual(2.5, (double)s.GetCellContents("A1"), 1e-9);
}
public void Test15()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("A2+A3"));
s.SetCellContents("A3", new Formula("A4+A5"));
s.SetCellContents("A5", new Formula("A6+A7"));
s.SetCellContents("A7", new Formula("A1+A1"));
}
public void Test13()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("Z7", new Formula("3"));
Formula f = (Formula)s.GetCellContents("Z7");
Assert.AreEqual(3, f.Evaluate(x => 0), 1e-6);
}
public void Test35()
{
TestableSpreadsheet s = new TestableSpreadsheet();
ISet <String> cells = new HashSet <string>();
for (int i = 1; i < 200; i++)
{
cells.Add("A" + i);
AssertSetEqualsIgnoreCase(cells, s.SetCellContents("A" + i, new Formula("A" + (i + 1))));
}
}
public void Test27()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1", new Formula("A2+A3"));
s.SetCellContents("A2", 6);
s.SetCellContents("A3", new Formula("A2+A4"));
s.SetCellContents("A4", new Formula("A2+A5"));
HashSet <string> result = new HashSet <string>(s.SetCellContents("A5", 82.5));
AssertSetEqualsIgnoreCase(result, new string[] { "A5", "A4", "A3", "A1" });
}
public void Test39()
{
TestableSpreadsheet s = new TestableSpreadsheet();
for (int i = 1; i < 200; i++)
{
s.SetCellContents("A" + i, new Formula("A" + (i + 1)));
}
try
{
s.SetCellContents("A150", new Formula("A50"));
Assert.Fail();
}
catch (CircularException)
{
}
}
public void Test16()
{
TestableSpreadsheet s = new TestableSpreadsheet();
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 Test43()
{
TestableSpreadsheet s = new TestableSpreadsheet();
for (int i = 0; i < 500; i++)
{
s.SetCellContents("A1" + i, new Formula("A1" + (i + 1)));
}
ISet <string> sss = s.SetCellContents("A1499", 25.0);
Assert.AreEqual(500, sss.Count);
for (int i = 0; i < 500; i++)
{
Assert.IsTrue(sss.Contains("A1" + i) || sss.Contains("a1" + i));
}
sss = s.SetCellContents("A1249", 25.0);
Assert.AreEqual(250, sss.Count);
for (int i = 0; i < 250; i++)
{
Assert.IsTrue(sss.Contains("A1" + i) || sss.Contains("a1" + i));
}
}
public void Test5()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A1A", 1.5);
}
public void Test4()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents(null, 1.5);
}
public void Test11()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents(null, new Formula("2"));
}
public void Test9()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("AZ", "hello");
}
public void Test7()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents("A8", (string)null);
}
public void Test8()
{
TestableSpreadsheet s = new TestableSpreadsheet();
s.SetCellContents(null, "hello");
}