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); }