private void UpdatedEventHandler(object sender, UpdatedEventArgs eventArgs) { foreach (var cellName in eventArgs.Cells) { // This updates the SpreadsheetPanel object with the values of all dependents of cellname. // Converts a cell name to col, row zero-based index. var row = Int32.Parse(cellName.Substring(1)) - 1; var col = cellName[0] - 65; var val = _spreadsheet.GetCellValue(cellName); if (val is FormulaError) { spreadsheetPanel1.SetValue(col, row, "FormulaError. " + ((FormulaError)val).Reason); } else { spreadsheetPanel1.SetValue(col, row, val.ToString()); } DisplayUpdate(spreadsheetPanel1); } }