public void TestingBadReference()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "=Cell678+50";
Assert.AreEqual(test.GetCell(1, 0).ValueStr, "!bad reference");
}
public void TestingSelfReference()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "=A1+5";
Assert.AreEqual(test.GetCell(1, 0).ValueStr, "!self reference");
}
public void TestingIfDefault()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "test";
Assert.AreEqual(test.DetermineDefault(test.GetCell(1, 0)), 0);
}
public void TestingSpreadsheetText()
{
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "12";
test.GetCell(1, 1).Text = "=(A1+13)";
Assert.AreEqual(test.GetCell(1, 1).Text, "=(A1+13)");
}
public void TestingSpreadsheetVale()
{
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(11, 0).Text = "12";
test.GetCell(1, 1).Text = "=(A11+13)";
Assert.AreEqual("25", test.GetCell(1, 1).ValueStr);
}
public void TestingCircularReference()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "=A2";
test.GetCell(2, 0).Text = "=A3";
test.GetCell(3, 0).Text = "=A1";
Assert.AreEqual(test.GetCell(3, 0).ValueStr, "!circular reference");
}
public void TestingColorUndoRedo()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Color = 4286644096;
undoInput.Add("0");
undoInput.Add("0");
undoInput.Add("color");
undoInput.Add("4294967295");
test.AddUndo(undoInput);
test.Undo();
Assert.AreEqual(test.GetCell(1, 0).Color.ToString(), "4294967295");
test.Redo();
Assert.AreEqual(test.GetCell(1, 0).Color.ToString(), "4286644096");
}
public void TestingUndoRedo()
{
List <string> undoInput = new List <string>();
SpreadSheet test = new SpreadSheet(50, 26);
test.GetCell(1, 0).Text = "50";
undoInput.Add("0");
undoInput.Add("0");
undoInput.Add("txt");
undoInput.Add(string.Empty);
test.AddUndo(undoInput);
test.Undo();
Assert.AreEqual(string.Empty, test.GetCell(1, 0).ValueStr);
test.Redo();
Assert.AreEqual(test.GetCell(1, 0).ValueStr, "50");
}
public void TestingGetCellColumn()
{
SpreadSheet test = new SpreadSheet(50, 26);
Assert.AreEqual(test.GetCell(49, 25).ColumnIndex, 25);
}
public void TestingGetCellRow()
{
SpreadSheet test = new SpreadSheet(50, 26);
Assert.AreEqual(test.GetCell(50, 25).RowIndex, 49);
}
