package kernel; import kernel.exception.CellNotFoundException; import kernel.exception.CreateCycleException; import kernel.exception.InvalidIntervalException; import java.io.Serializable; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class Grid implements Serializable { private static final long serialVersionUID = 1L; private Map cells = new HashMap<>(); public static LanguageEnum language = LanguageEnum.FR; private List listLine = new ArrayList<>(); private List listColumn = new ArrayList<>(); public void createCell(String column, int line, double value) throws InvalidIntervalException { String id = this.getCellId(column, line); Cell cell = new Cell(column, line, value); this.cells.put(id, cell); this.saveDifferentLineColumn(column, line); } public void createCell(String column, int line, Formula formula) throws CreateCycleException, InvalidIntervalException { String id = this.getCellId(column, line); Cell cell = new Cell(column, line, formula); this.cells.put(id, cell); this.saveDifferentLineColumn(column, line); } public void setValue(String column, int line, double value) throws CellNotFoundException { this.getCell(column, line).setValue(value); } public void setFormula(String column, int line, Formula formula) throws CellNotFoundException, CreateCycleException { this.getCell(column, line).setFormula(formula); } public Cell getCell(String column, int line) throws CellNotFoundException { Cell cell = this.cells.get(this.getCellId(column, line)); if (cell != null) return cell; else throw new CellNotFoundException(); } public List getCells() { return new ArrayList<>(this.cells.values()); } public List getCellsId() { return new ArrayList<>(this.cells.keySet()); } public double getValue(String column, int line) throws CellNotFoundException { return this.getCell(column, line).getValue(); } public String getFormulaAsString(String column, int line) throws CellNotFoundException { return this.getCell(column, line).toString(); } public String getDevelopedFormula(String column, int line) throws CellNotFoundException { return this.getCell(column, line).getDevelopedFormula(); } private String getCellId(String column, int line) { return column + line; } private void saveDifferentLineColumn(String column, int line) { if (!this.listLine.contains(line)) this.listLine.add(line); if (!this.listColumn.contains((int) column.charAt(0))) this.listColumn.add((int) column.charAt(0) - (int) 'A' + 1); } public List getTotalColumn() { return listColumn; } public List getTotalLine() { return listLine; } }