public void TestIndexOutOfRange()
{
var sheet = new SimpleSpreadsheet(2, 3);
sheet[0, 0] = 1;
sheet[0, 1] = 2;
try
{
var result = sheet[2, 0];
Assert.Fail();
}
catch (Exception e)
{
Assert.IsTrue(e is IndexOutOfRangeException);
}
try
{
var result = sheet[0, 3];
Assert.Fail();
}
catch (Exception e)
{
Assert.IsTrue(e is IndexOutOfRangeException);
}
}
private static void SuperSafeSpreadSheet()
{
ISpreadSheet Calcspreadsheet = new SimpleSpreadsheet("Calc");
SpreadSheetCommandLogDecorator safesheet =
new SpreadSheetCommandLogDecorator(Calcspreadsheet);
safesheet.Save("Calcspreadsheet.bin");
//update the spreadsheet
UpdateSpreadSheet(safesheet);
//what if this doesn't happen
safesheet.Save("Calcspreadsheet.bin");
//lose it and reload
safesheet = null;
Calcspreadsheet = SimpleSpreadsheet.Load("Calcspreadsheet.bin");
safesheet =
new SpreadSheetCommandLogDecorator(Calcspreadsheet);
safesheet.Restore();
//validate the values are correct
ValidateSheet(safesheet);
}
private static void BatchSpreadSheet()
{
ISpreadSheet Calcspreadsheet = new SimpleSpreadsheet("Calc");
SpreadSheetBatchCommandDecorator batchsheet =
new SpreadSheetBatchCommandDecorator(Calcspreadsheet);
//update the spreadsheet
UpdateSpreadSheet(batchsheet);
//validate the values are correct
ValidateSheet(batchsheet);
}
public void TestNormalUpdate()
{
var sheet = new SimpleSpreadsheet(2, 3);
sheet[0, 0] = 1;
sheet[0, 1] = 2;
Assert.AreEqual(sheet[0, 0], 1);
Assert.AreEqual(sheet[0, 1], 2);
Assert.AreEqual(sheet[0, 2], 0);
Assert.AreEqual(sheet[1, 0], 0);
Assert.AreEqual(sheet[1, 1], 0);
Assert.AreEqual(sheet[1, 2], 0);
}
