public void TestMethod3() { var spreadsheet = new SS.Spreadsheet(); spreadsheet.SetCellContents("A1", 1); spreadsheet.SetCellContents("A2", 2); spreadsheet.SetCellContents("A3", new Formula("A1 + A2")); spreadsheet.SetCellContents("B1", 3); spreadsheet.SetCellContents("B2", 4); spreadsheet.SetCellContents("B3", new Formula("B1 + B2")); spreadsheet.SetCellContents("C3", new Formula("A3 + B3")); spreadsheet.SetCellContents("D3", new Formula("C3 / 2")); var resolve = _variableResolver(spreadsheet); var a3 = spreadsheet.GetCellContents("A3") as Formula; var b3 = spreadsheet.GetCellContents("B3") as Formula; var c3 = spreadsheet.GetCellContents("C3") as Formula; var d3 = spreadsheet.GetCellContents("D3") as Formula; Assert.IsNotNull(a3); Assert.IsNotNull(b3); Assert.IsNotNull(c3); Assert.IsNotNull(d3); Assert.AreEqual(3d, a3.Evaluate(resolve)); Assert.AreEqual(7d, b3.Evaluate(resolve)); Assert.AreEqual(10d, c3.Evaluate(resolve)); Assert.AreEqual(5d, d3.Evaluate(resolve)); }
public void TestMethod4() { var spreadsheet = new SS.Spreadsheet(); spreadsheet.SetCellContents("A1", "Title"); spreadsheet.SetCellContents("A2", "Tesla #1"); spreadsheet.SetCellContents("A3", "Tesla #2"); spreadsheet.SetCellContents("A4", "Tesla #3"); spreadsheet.SetCellContents("A5", "Total:"); spreadsheet.SetCellContents("B1", "Sales"); spreadsheet.SetCellContents("B2", 75000); spreadsheet.SetCellContents("B3", 85000); spreadsheet.SetCellContents("B4", 90000); spreadsheet.SetCellContents("B5", new Formula("B2+B3+B4")); var resolve = _variableResolver(spreadsheet); var a1 = spreadsheet.GetCellContents("A1") as string; var b2 = spreadsheet.GetCellContents("B2") as double?; var b5 = spreadsheet.GetCellContents("B5") as Formula; Assert.IsNotNull(a1); Assert.IsNotNull(b2); Assert.IsNotNull(b5); Assert.AreEqual("Title", a1); Assert.AreEqual(75000, b2); Assert.AreEqual(75000 + 85000 + 90000d, b5.Evaluate(resolve)); }
public void SetStringContentTwice() { Spreadsheet sheet = new Spreadsheet(); sheet.SetCellContents("A1", "blue"); sheet.SetCellContents("A1", "green"); Assert.AreEqual(sheet.GetCellContents("A1"), "green"); Assert.AreNotEqual(sheet.GetCellContents("A1"), "blue"); }
public void GetCellContentsStringTest() { //Gets the contents of a string-type cell Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("a1", "Hey there"); Assert.AreEqual("Hey there", s.GetCellContents("a1")); }
public void GetCellContentsStringCellExistsTest() { Spreadsheet s = new Spreadsheet(); Assert.AreEqual(true, s.SetContentsOfCell("a1", "Hey there").Contains("a1")); Assert.AreEqual(true, s.SetContentsOfCell("a1", "What's up?").Contains("a1")); Assert.AreEqual("What's up?", s.GetCellContents("a1")); }
public void TestEmptyGetCellContents() { Spreadsheet sheet = new Spreadsheet(); object content = sheet.GetCellContents("A1"); Assert.IsTrue(content.Equals("")); }
public void GetValueDoubleEmptyConstructor() { Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("D1", "5"); Assert.AreEqual(sheet.GetCellContents("D1"), (double)5); Assert.AreEqual(sheet.GetCellValue("D1"), (double)5); }
public void GetValueFormula01() { Spreadsheet sheet = new Spreadsheet(s => true, s => s, "default"); sheet.SetContentsOfCell("D1", "=5"); Assert.AreEqual(sheet.GetCellContents("D1"), new Formula("5")); Assert.AreEqual(sheet.GetCellValue("D1"), (double)5); }
public void TestMethod13() { var spreadsheet = new SS.Spreadsheet(); var resolve = _variableResolver(spreadsheet); var random = new Random(); for (var x = 'A'; x <= 'Z'; x++) { double sum = 0; var expression = ""; const int count = 30; for (var y = 1; y < count; y++) { var cell = x.ToString() + y; var randomNum = random.Next(1, 200); spreadsheet.SetCellContents(cell, randomNum); sum += randomNum; // Adds the cell with a + // expression += (y == count - 1) ? cell : cell + "+"; } var cellName = x + count.ToString(); spreadsheet.SetCellContents(cellName, new Formula(expression)); var formula = spreadsheet.GetCellContents(cellName) as Formula; Assert.IsNotNull(formula); Assert.AreEqual(sum, formula.Evaluate(resolve)); } }
/// <summary> /// Gets the contents of a given cell from the model and places it in the current cell contents box /// for updating /// </summary> private void SetCellContentsBox() { SpreadsheetPanel panel = window.GetSpreadsheetPanel(); // set the location of this textbox int x, y, width, height; panel.GetSelectionLocation(out x, out y, out width, out height); window.UpdateEditBoxLocation(x, y, width, height); // locate the current cell in the grid and convert to a variable panel.GetSelection(out int col, out int row); string cellName = ConvertRowColToCellName(row, col); // set the contents text to the current contents of the cell object contents = sheet.GetCellContents(cellName); if (contents is string || contents is double) { window.ContentsBoxText = contents.ToString(); } else { window.ContentsBoxText = "=" + contents.ToString(); } }
public void GetCellContentsDoubleCellExistsTest() { Spreadsheet s = new Spreadsheet(); Assert.AreEqual(true, s.SetContentsOfCell("a1", "2.0").Contains("a1")); Assert.AreEqual(true, s.SetContentsOfCell("a1", "5.3").Contains("a1")); Assert.AreEqual(5.3, s.GetCellContents("a1")); }
public void TestConstructor() { //just some stuff with filewriting Assert.IsTrue(sheet1.IsValid("any old string")); Assert.IsTrue(sheet1.Normalize("dead") == "dead"); Assert.IsTrue(sheet1.Version == "default"); //test 3 arg constructor sheet1 = new Spreadsheet(s => (s.Length >= 2) ? true : false, s => s.Replace(" ", ""), "version1"); Assert.IsTrue(sheet1.IsValid("A1")); Assert.IsFalse(sheet1.IsValid("A")); Assert.IsTrue(sheet1.Normalize("d e a d") == "dead"); Assert.IsTrue(sheet1.Version == "version1"); sheet1.SetContentsOfCell("A 1","loaded!"); string savePath = "save 1.xml"; sheet1.Save(savePath); sheet1 = new Spreadsheet( savePath, s => (s.Length >= 2) ? true : false, s => s.Replace(" ", ""), "version1"); Assert.AreEqual("loaded!",(string)sheet1.GetCellContents("A1")); }
public void GetCellContentsFormula() { Spreadsheet sheet = new Spreadsheet(); sheet.SetCellContents("A1", "blue"); sheet.SetCellContents("A1", "green"); sheet.SetCellContents("B1", "purple"); sheet.SetCellContents("C1", "red"); sheet.SetCellContents("D1", new Formula("C1 + 2 + X1")); Assert.AreEqual(sheet.GetCellContents("D1"), new Formula("C1+2+X1")); }
public void TestConstructor1() { AbstractSpreadsheet sheet = new Spreadsheet(); Assert.AreEqual("", sheet.GetCellContents("A1")); Assert.AreEqual("", sheet.GetCellContents("B1")); Assert.AreEqual("", sheet.GetCellContents("D1")); Assert.AreEqual("", sheet.GetCellContents("AA1")); Assert.AreEqual("", sheet.GetCellContents("Jim")); Assert.AreEqual("", sheet.GetCellContents("ab1")); }
public void TestMethod15() { var spreadsheet = new SS.Spreadsheet(); spreadsheet.SetCellContents("A1", 2.0); spreadsheet.SetCellContents("C1", new Formula("A1")); var resolve = _variableResolver(spreadsheet); var formula = spreadsheet.GetCellContents("C1") as Formula; Assert.IsNotNull(formula); Assert.AreEqual(formula, new Formula("A1")); Assert.AreEqual(2d, formula.Evaluate(resolve)); }
public void TestMethod7() { var spreadsheet = new SS.Spreadsheet(); spreadsheet.SetCellContents("_kanye_west", 2.0); spreadsheet.SetCellContents("_kanye_north", 45.0); spreadsheet.SetCellContents("C1", new Formula("_kanye_west + _kanye_north")); var resolve = _variableResolver(spreadsheet); var formula = spreadsheet.GetCellContents("C1") as Formula; Assert.IsNotNull(formula); Assert.AreEqual(formula, new Formula("_kanye_west + _kanye_north")); Assert.AreEqual(47.0d, formula.Evaluate(resolve)); }
/// <summary> /// Gets the contents of a given cell from the model and places it in the current cell contents box /// for updating /// </summary> private void SetCellContentsBox(SpreadsheetPanel panel) { // locate the current cell in the grid and convert to a variable panel.GetSelection(out int col, out int row); string cellName = ConvertRowColToCellName(row, col); // set the contents text to the current contents of the cell object contents = sheet.GetCellContents(cellName); if (contents is string || contents is double) { window.ContentsBoxText = contents.ToString(); } else { window.ContentsBoxText = "=" + contents.ToString(); } }
public void TestMethod2() { var spreadsheet = new SS.Spreadsheet(); spreadsheet.SetCellContents("A1", 2.0); spreadsheet.SetCellContents("B1", 45.0); spreadsheet.SetCellContents("C1", new Formula("A1 + B1")); spreadsheet.SetCellContents("D1", new Formula("C1 + A1")); var resolve = _variableResolver(spreadsheet); var d1 = spreadsheet.GetCellContents("D1") as Formula; Assert.IsNotNull(d1); Assert.AreEqual(d1, new Formula("C1 + A1")); Assert.AreEqual(49.0d, d1.Evaluate(resolve)); }
private void changed_size(object sender, EventArgs e) { sss.SetSelection(0, 0); cellTextBox.Location = new System.Drawing.Point(42, 79); cellboxY = 0; cellboxX = 0; if (sheet.GetCellContents("A1") == null) { cellTextBox.Text = ""; cellContentsField.Text = ""; cellValueField.Text = ""; } else { cellContentsField.Text = sheet.GetCellContents("A1").ToString(); cellValueField.Text = sheet.GetCellValue("A1").ToString(); cellTextBox.Text = sheet.GetCellValue("A1").ToString(); } cellNameField.Text = "A1"; }
/// <summary> /// set the name and the contents of the cell /// </summary> private void SetCellNameAndContents() { spreadsheetPanel.GetSelection(out int col, out int row); // get and then set the cell name selectedCellNameTextBox.Text = "" + (char)(col + 65) + (row + 1); object currCellContents = thisSheet.GetCellContents(selectedCellNameTextBox.Text); string stringContents; if (currCellContents is Formula) { stringContents = "=" + currCellContents.ToString(); } else { stringContents = currCellContents.ToString(); } selectedCellContentsTextBox.Text = stringContents; spreadsheetPanel.SetValue(col, row, thisSheet.GetCellValue(selectedCellNameTextBox.Text).ToString()); // get and then set the cell value selectedCellValueTextBox.Text = thisSheet.GetCellValue(selectedCellNameTextBox.Text).ToString(); string cellName = selectedCellNameTextBox.Text; string cellContents = selectedCellContentsTextBox.Text; }
public void CreateSaveLoadSpreadsheet() { Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("D1", "=5"); sheet.SetContentsOfCell("C1", "=4.5"); sheet.SetContentsOfCell("E1", "apples"); sheet.SetContentsOfCell("G1", "-2"); sheet.SetContentsOfCell("H1", "-4"); sheet.SetContentsOfCell("F1", "= G1 + H1"); sheet.Save(@"MyXml2.xml"); Spreadsheet sheet2 = new Spreadsheet(@"MyXml2.xml", s => true, s => s, "default"); Assert.AreEqual(sheet2.GetCellContents("D1"), new Formula("5")); Assert.AreEqual(sheet2.GetCellContents("C1"), new Formula("4.5")); Assert.AreEqual(sheet2.GetCellContents("E1"), "apples"); Assert.AreEqual(sheet2.GetCellContents("G1"), (double)-2); Assert.AreEqual(sheet2.GetCellContents("H1"), (double)-4); Assert.AreEqual(sheet2.GetCellContents("F1"), new Formula("G1 + H1")); Assert.AreEqual(sheet2.GetCellValue("F1"), (double)-6); }
/// <summary> /// Given cell name, moves cursor to contents field, /// and updates name, contents, and value fields /// with values corresponding to cell /// </summary> /// <param name="name"></param> private void UpdateGUIFields(string name) { //move cursor to contents field cellContentsField.Focus(); cellNameField.Text = name; //set CellContentsField from spreadsheet if (sheet.GetCellContents(name) is Formula) { cellContentsField.Text = "=" + sheet.GetCellContents(name).ToString(); } else { cellContentsField.Text = sheet.GetCellContents(name).ToString(); } //set CellValueField from spreadsheet cellValueField.Text = sheet.GetCellValue(name).ToString(); //highlight current contents cellContentsField.SelectionStart = 0; cellContentsField.SelectionLength = cellContentsField.Text.Length; }
public void Test300() { Spreadsheet s = new Spreadsheet(); Assert.AreEqual("", s.GetCellContents("A2")); }
public void Test2800() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("A1", "=A2+A3"); s.SetContentsOfCell("A1", "2.5"); Assert.AreEqual(2.5, (double)s.GetCellContents("A1"), 1e-9); }
public void Test1700() { Spreadsheet s = new Spreadsheet(); try { s.SetContentsOfCell("A1", "=A2+A3"); s.SetContentsOfCell("A2", "15"); s.SetContentsOfCell("A3", "30"); s.SetContentsOfCell("A2", "=A3*A1"); } catch (CircularException e) { Assert.AreEqual(15, (double)s.GetCellContents("A2"), 1e-9); throw e; } }
public void NormalizeTest2() { AbstractSpreadsheet ss = new Spreadsheet(s => true, s => s.ToUpper(), ""); ss.SetContentsOfCell("B1", "hello"); Assert.AreEqual("hello", ss.GetCellContents("b1")); }
public void Test1400() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("Z7", "=3"); Formula f = (Formula)s.GetCellContents("Z7"); Assert.AreEqual(new Formula("3"), f); Assert.AreNotEqual(new Formula("2"), f); }
public void TestRead3() { string path = "read3.xml"; Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("a1", "=1.5+4"); sheet.SetContentsOfCell("b2", "=a2-2.6"); sheet.SetContentsOfCell("c3", "=3.7*e5"); sheet.SetContentsOfCell("d4", "hil"); sheet.SetContentsOfCell("e5", "5.9"); sheet.Save(path); HashSet<string> original = (HashSet<string>)sheet.GetNamesOfAllNonemptyCells(); Spreadsheet sheet2 = new Spreadsheet(path, x => true, s => s, "default"); foreach (string s in original) { Assert.IsTrue(sheet.GetCellContents(s).Equals(sheet2.GetCellContents(s))); Assert.IsTrue(sheet.GetCellValue(s).Equals(sheet2.GetCellValue(s))); } }
public void TestGetCellContents6() { Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("a1", "5.27"); sheet.SetContentsOfCell("b2", "6.000"); sheet.SetContentsOfCell("c3", "hello"); sheet.SetContentsOfCell("d4", "=5 - 4 + x2"); sheet.SetContentsOfCell("e5", "=a1 - b2"); Assert.AreEqual(5.27, sheet.GetCellContents("a1")); Assert.AreEqual(6.0, sheet.GetCellContents("b2")); Assert.AreEqual("hello", sheet.GetCellContents("c3")); Assert.AreEqual(new Formula("5 - 4 + x2"), sheet.GetCellContents("d4")); Assert.AreEqual(new Formula("a1 - b2"), sheet.GetCellContents("e5")); }
public void Test2() { AbstractSpreadsheet s = new Spreadsheet(); s.GetCellContents("AA"); }
public void GetCellContents6() { AbstractSpreadsheet sheet = new Spreadsheet(); Assert.AreEqual("", sheet.GetCellContents("a1")); }
public void Test1() { Spreadsheet s = new Spreadsheet(); s.GetCellContents(null); }
public void Test2() { Spreadsheet s = new Spreadsheet(); s.GetCellContents("1AA"); }
public void Test3() { Spreadsheet s = new Spreadsheet(); Assert.AreEqual("", s.GetCellContents("A2")); }
public void TestGetCellContents5() { Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("a57", "hello"); Assert.AreEqual("hello", sheet.GetCellContents("a57")); }
public void TestException6() { Spreadsheet ss = new Spreadsheet(); ss.GetCellContents("AXYAHNKD23490&8558"); }
public void Test100() { Spreadsheet s = new Spreadsheet(); s.GetCellContents(null); }
public void TestException4() { Spreadsheet ss = new Spreadsheet(); ss.GetCellContents("X1X"); }
public void Test1000() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("Z7", "hello"); Assert.AreEqual("hello", s.GetCellContents("Z7")); }
public void TestGetCellContents() { AbstractSpreadsheet ss = new Spreadsheet(); Assert.AreEqual("", ss.GetCellContents("z1")); }
public void NormalizeTest1() { AbstractSpreadsheet s = new Spreadsheet(); s.SetContentsOfCell("B1", "hello"); Assert.AreEqual("", s.GetCellContents("b1")); }
public void StressTest1() { Spreadsheet sheet = new Spreadsheet(); int SIZE = 1000; // Add a ton of items for (int i = 0; i < SIZE; i++) sheet.SetContentsOfCell("a" + i, 1.0 + i + ""); for (int i = 0; i < SIZE; i++) sheet.SetContentsOfCell("b" + i, "hi" + i); for (int i = 0; i < SIZE; i++) sheet.SetContentsOfCell("c" + i, "=5+" + i); // Make correct HashSet HashSet<string> correct = new HashSet<string>(); for (int i = 0; i < SIZE; i++) correct.Add("a" + i); for (int i = 0; i < SIZE; i++) correct.Add("b" + i); for (int i = 0; i < SIZE; i++) correct.Add("c" + i); // Get all of the names of the cells HashSet<string> output = (HashSet<string>)sheet.GetNamesOfAllNonemptyCells(); // Confirm that the names in the spreadsheet are correct Assert.IsTrue(correct.SetEquals(output)); // Check the cell contents of all the cells for (int i = 0; i < SIZE; i++) Assert.AreEqual(1.0 + i, sheet.GetCellContents("a" + i)); for (int i = 0; i < SIZE; i++) Assert.AreEqual("hi" + i, sheet.GetCellContents("b" + i)); for (int i = 0; i < SIZE; i++) Assert.AreEqual(new Formula("5+" + i), sheet.GetCellContents("c" + i)); // You did it! Assert.IsTrue(true); }
public void SaveTest3() { AbstractSpreadsheet s1 = new Spreadsheet(); Set(s1, "A1", "hello"); s1.Save("save1.txt"); s1 = new Spreadsheet("save1.txt", s => true, s => s, "default"); Assert.AreEqual("hello", s1.GetCellContents("A1")); }
public void TestException1() { Spreadsheet ss = new Spreadsheet(); ss.GetCellContents(null); }
public void Test200() { Spreadsheet s = new Spreadsheet(); s.GetCellContents("1AA"); }
public void TestGetCellContents3() { Spreadsheet sheet = new Spreadsheet(); Assert.AreEqual("", sheet.GetCellContents("a1")); }
public void Test2900() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("A1", "=A2+A3"); s.SetContentsOfCell("A1", "Hello"); Assert.AreEqual("Hello", (string)s.GetCellContents("A1")); }
public void TestGetCellContents4() { Spreadsheet sheet = new Spreadsheet(); sheet.SetContentsOfCell("a1", "0.0"); Assert.AreEqual(0.0, sheet.GetCellContents("a1")); }
public void Test3000() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("A1", "Hello"); s.SetContentsOfCell("A1", "=23"); Assert.AreEqual(new Formula("23"), (Formula)s.GetCellContents("A1")); Assert.AreNotEqual(new Formula("24"), (Formula)s.GetCellContents("A1")); }
public void TestGetCellContents1() { AbstractSpreadsheet sheet = new Spreadsheet(); sheet.GetCellContents(null); }
public void Test600() { Spreadsheet s = new Spreadsheet(); s.SetContentsOfCell("Z7", "1.5"); Assert.AreEqual(1.5, (double)s.GetCellContents("Z7"), 1e-9); }
public void TestGetCellContents2() { AbstractSpreadsheet sheet = new Spreadsheet(); sheet.GetCellContents("hello"); }