Exemple #1
0
 /// <summary>
 /// Handles a request to change the contents of the selected cell.
 /// </summary>
 private void HandleCellContentsSet(string name, string newContents)
 {
     try
     {
         foreach (string cell in spreadsheet.SetContentsOfCell(name, newContents))
         {
             object val = spreadsheet.GetCellValue(cell);
             string toDisplay;
             if (val.GetType().Equals(typeof(FormulaError)))
             {
                 toDisplay = "FormErr";
             }
             else
             {
                 toDisplay = val.ToString();
             }
             window.DisplayValue(cell, toDisplay);
         }
     }
     catch (CircularException e)
     {
         window.ShowCircularExceptionBox();
     }
     catch (Formulas.FormulaFormatException e)
     {
         window.ShowFormulaExceptionBox(e.Message);
     }
 }