private void Form1_Load(object sender, EventArgs e)
{
dataGridView2.Columns.Clear();
ss = new CptS321.Spreadsheet(26, 50);
ss.CellPropertyChanged += Form1CellPropertyChanged; //subscription
dataGridView2.CellBeginEdit += editCell;
dataGridView2.CellEndEdit += endEdit;
for (int i = 65; i <= 90; i++) //ASCII codes for capital letters A - Z
{
dataGridView2.Columns.Add(Convert.ToChar(i).ToString(), Convert.ToChar(i).ToString());
}
for (int j = 1; j <= 50; j++) //makes 50 rows
{
DataGridViewRow row = new DataGridViewRow();
row.HeaderCell.Value = j.ToString();
dataGridView2.Rows.Add(row);
}
//CptS321.Spreadsheet ss = new CptS321.Spreadsheet(50, 26); create a local form
//ss.triggerEvent();
}
private void Form1_Load(object sender, EventArgs e)
{
//clear columns
DataSheet.Columns.Clear();
//load CptS321 namespace
target = new CptS321.Spreadsheet(50, 26);
target.CellPropertyChanged += new PropertyChangedEventHandler(ToCellChange);
//creat calumns
char x = 'A';
for (int i = 0; i <= 25; i++)
{
string y = char.ToString(x);
DataSheet.Columns.Add(y, y);
x++;
}
//creat rows
for (int j = 0; j < 50; j++)
{
int temp = j + 1;
DataSheet.Rows.Add();
DataSheet.Rows[j].HeaderCell.Value = temp.ToString();
}
}
public void TestGetCell()
{
this.sheet = new Spreadsheet(50, 26);
this.sheet.GetCell(3, 5).Text = "hello";
Assert.That(this.sheet.GetCell(3, 5).Text, Is.EqualTo("hello"));
}
public void TestSpreadsheetColumnCount()
{
this.sheet = new Spreadsheet(3, 5);
Assert.That(this.sheet.NumberOfColumns, Is.EqualTo(5));
}
public void TestSpreadsheetRowCount()
{
this.sheet = new Spreadsheet(8, 3);
Assert.That(this.sheet.NumberOfRows, Is.EqualTo(8));
}
//Constructor
public Cell2D(int row, int column) : base(row, column)
{
location = Spreadsheet.getLocation(row, column);
}
