Application.java 2.54 KB
package app;

import kernel.Cell;
import kernel.Grid;
import kernel.exception.CellNotFoundException;
import kernel.exception.CreateCycleException;
import kernel.exception.InvalidIntervalLineColumnEception;
import kernel.function.Average;
import kernel.function.Sum;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.ObjectOutputStream;
import java.util.ArrayList;
import java.util.List;

public class Application {

    public static void main(String[] args) throws IOException {
        File fichier = new File("essai.ser");

        // ouverture d'un flux sur un fichier
        ObjectOutputStream oos = new ObjectOutputStream(new FileOutputStream(fichier));

        Grid grid = new Grid();

        // Création
        System.out.println("Création de quelques cases...");

        try {
            grid.createCell("A", 1, 10.);
            grid.createCell("B", 1, 0.);
            grid.createCell("A", 2, 5.);
            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 | CreateCycleException | InvalidIntervalLineColumnEception exception) {
            System.out.println(exception.getMessage());
        }

        // 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());

        // sérialization de l'objet
        oos.writeObject(grid);
        oos.close();
    }
}