/// <summary>
/// Open a file and fill the speadsheet window with the file information
/// </summary>
/// <param name="window"></param>
/// <param name="sheet"></param>
/// <param name="title"></param>
public Controller(ISpreadsheetView window, Spreadsheet sheet, string title)
{
Inititalize(window, sheet, title);
int[] temp;
// Fill all nonempty cell with value in the source file
foreach (string cell in sheet.GetNamesOfAllNonemptyCells())
{
GetCellNumber(cell, out int col, out int row);
temp = new int[2] {
col, row
};
view.SelectedCellAddress = temp;
view.SetCellValueOnPanel(temp, sheet.GetCellValue(cell).ToString());
}
HandleSelectionChanged(new int[2] {
0, 0
});
}