private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
//Update underlying spreadsheet when a cell in the DataGrid is getting validated
DataGridView mainGrid = sender as DataGridView;
if (e.RowIndex < 0 | e.ColumnIndex < 0)
{
return;
}
if (mainGrid.CurrentCell.Value is null)
{
return;
}
string text = mainGrid.CurrentCell.Value.ToString();
if (text.Length == 0)
{
return;
}
//Update underlying spreaqdsheet cell with value entered into UI. Underlying spreadsheet will do
//logic to determine what to do with the entered text.
spreadSheetApp.GetCell(e.RowIndex, e.ColumnIndex).Text = mainGrid[e.ColumnIndex, e.RowIndex].Value.ToString();
}
// Event for when stuff in the datagridview cell is being changed
private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
// Sets the text of the datagridview cell to the text of the spreadsheetcell
dataGridView1[e.ColumnIndex, e.RowIndex].Value = spreadsheet.GetCell(e.RowIndex, e.ColumnIndex).Text;
}
