public void ManyCellsExist() { var sheet = new Sheet(); sheet.Put("A1", "First"); sheet.Put("X27", "Second"); Assert.That(sheet.Get("A1"), Is.EqualTo("First")); Assert.That(sheet.Get("X27"), Is.EqualTo("Second")); }
public void TextCellsAreStored() { var sheet = new Sheet(); const string theCell = "A21"; sheet.Put(theCell, "A string"); Assert.That(sheet.Get(theCell), Is.EqualTo("A string")); }
public void NumericCellsAreIdentifiedAndStored() { var sheet = new Sheet(); const string theCell = "B14"; sheet.Put(theCell, "14"); Assert.That(sheet.Get(theCell), Is.EqualTo("14")); sheet.Put(theCell, " 99 X"); Assert.That(sheet.Get(theCell), Is.EqualTo(" 99 X")); sheet.Put(theCell, " 1234 "); Assert.That(sheet.Get(theCell), Is.EqualTo("1234")); sheet.Put(theCell, " "); Assert.That(sheet.Get(theCell), Is.EqualTo(" ")); }
public void WeHaveAccessToCellLiteralValuesForEditing() { var sheet = new Sheet(); const string theCell = "C21"; sheet.Put(theCell, "Some string"); Assert.That(sheet.GetLiteral(theCell), Is.EqualTo("Some string")); sheet.Put(theCell, " 1234 "); Assert.That(sheet.GetLiteral(theCell), Is.EqualTo(" 1234 ")); sheet.Put(theCell, "=7"); Assert.That(sheet.GetLiteral(theCell), Is.EqualTo("=7")); }