public void Test_Constant_Formula()
{
Sheet sheet = new Sheet();
sheet["A1"] = "=7";
Assert.That(sheet.GetLiteral("A1"), Is.EqualTo("=7"));
Assert.That(sheet["A1"], Is.EqualTo("7"));
}
public void Test_malformed_formula()
{
Sheet sheet = new Sheet();
sheet["B1"] = " =7";
Assert.That(sheet["B1"], Is.EqualTo(" =7"));
Assert.That(sheet.GetLiteral("B1"), Is.EqualTo(" =7"));
}
public void Many_cells_can_exist()
{
Sheet sheet = new Sheet();
sheet["A1"] = "First";
sheet["X27"] = "Second";
sheet["ZX901"] = "Third";
Assert.That(sheet["A1"], Is.EqualTo("First"));
Assert.That(sheet["X27"], Is.EqualTo("Second"));
Assert.That(sheet["ZX901"], Is.EqualTo("Third"));
sheet["A1"] = "Fourth";
Assert.That(sheet["A1"], Is.EqualTo("Fourth"));
Assert.That(sheet["X27"], Is.EqualTo("Second"));
Assert.That(sheet["ZX901"], Is.EqualTo("Third"));
}
public void Test_that_numeric_strings_are_identified(string input, string expected)
{
Sheet sheet = new Sheet();
String theCell = "A21";
sheet[theCell]= input;
AssertCellValue(sheet, theCell, expected);
}
public void Test_Parentheses(string value)
{
Sheet sheet = new Sheet();
sheet["A1"] = string.Format("=({0})", value);
Assert.That(sheet["A1"], Is.EqualTo(value));
}
public void testMultiply()
{
Sheet sheet = new Sheet();
sheet["A1"] = "=2*3*4";
Assert.That(sheet["A1"], Is.EqualTo("24"));
}
public void testDeepParentheses()
{
Sheet sheet = new Sheet();
sheet["A1"] = "=((((10))))";
Assert.That(sheet["A1"], Is.EqualTo("10"));
}
public void testAdd()
{
Sheet sheet = new Sheet();
sheet["A1"] = "=71+2+3";
Assert.That(sheet["A1"], Is.EqualTo("76"));
}
private static void AssertCellValue(Sheet s, string cell, string value)
{
Assert.That(s[cell], Is.EqualTo(value));
}
public void Text_cells_should_be_stored(string input, string expected)
{
Sheet sheet = new Sheet();
sheet["A21"] = input;
Assert.That(sheet["A21"], Is.EqualTo(expected));
}
public void Cells_should_be_empty_by_default()
{
Sheet sheet = new Sheet();
Assert.That(sheet["A1"], Is.Empty);
Assert.That(sheet["ZX347"], Is.Empty);
}
public void Test_That_We_Have_Access_To_Cell_Literal_Values_For_Editing(string expected, string input)
{
Sheet sheet = new Sheet();
String theCell = "A21";
sheet[theCell] = input;
Assert.That(sheet.GetLiteral(theCell), Is.EqualTo(expected));
}
