package app;
  

  import kernel.Cell;

  import kernel.Grid;

  import kernel.exception.CellNotFoundException;

  import kernel.exception.CreateCycleException;

  import kernel.function.Average;
  import kernel.function.Sum;
  
  import java.util.ArrayList;
  import java.util.List;

  
  public class Application {
  
      public static void main(String[] args) {

          Grid grid = new Grid();

          // Création
          System.out.println("Création de quelques cases...");
          grid.createCell("A", 1, 10.);
          grid.createCell("B", 1, 0.);
          grid.createCell("A", 2, 5.);
  
          try {
              List<Cell> sumList = new ArrayList<>();
              sumList.add(grid.getCell("A", 1));
              sumList.add(grid.getCell("A", 2));
  
              grid.createCell("A", 3, new Sum(sumList));
  
              List<Cell> averageList = new ArrayList<>();
              averageList.add(grid.getCell("A", 3));
              averageList.add(grid.getCell("B", 1));
  
              grid.createCell("B", 2, new Average(averageList));
          } catch (CellNotFoundException exception) {
              System.out.println(exception.getMessage());

          } catch (CreateCycleException exception) {
              System.out.println(exception.toString());

          }
  
          // Affichage
          List<Cell> cells = grid.getCells();
  
          System.out.println("Affichage des valeurs :");
          for (Cell cell : cells)
              System.out.println(cell.getId() + ": " + cell.getValue());
  
          System.out.println("Affichage des formules :");
          for (Cell cell : cells)
              System.out.println(cell.getId() + ": " + cell.toString());
  
          System.out.println("Affichage des formules développées :");
          for (Cell cell : cells)
              System.out.println(cell.getId() + ": " + cell.getDevelopedFormula());

  
          // Propagation
          try {
              grid.setValue("A", 1, 20.);
          } catch (CellNotFoundException exception) {
              System.out.println("exception");
          }
  
          System.out.println("Affichage des valeurs après modification :");
          for (Cell cell : cells)
              System.out.println(cell.getId() + ": " + cell.getValue());

      }
  }