Grid.java
3.16 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
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 static final int MAX_LIGNES = 20;
private static final String MAX_COLONNES = "Z";
private Map<String, Cell> cells = new HashMap<>();
public static LanguageEnum language = LanguageEnum.FR;
public void createCell(String column, int line, double value) throws InvalidIntervalException {
column = column.toUpperCase();
if (!validateInterval(column, line))
throw new InvalidIntervalException();
String id = this.getCellId(column, line);
Cell cell = new Cell(column, line, value);
this.cells.put(id, cell);
}
public void createCell(String column, int line, Formula formula) throws CreateCycleException, InvalidIntervalException {
column = column.toUpperCase();
if (!validateInterval(column, line))
throw new InvalidIntervalException();
String id = this.getCellId(column, line);
Cell cell = new Cell(column, line, formula);
this.cells.put(id, cell);
}
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<Cell> getCells() {
return new ArrayList<>(this.cells.values());
}
public List<String> 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;
}
public int getTotalColumn() {
return MAX_COLONNES.charAt(0) - (int) 'A' + 1;
//return convertStringToInt(MAX_COLONNES);
}
public int getTotalLine() {
return MAX_LIGNES;
}
private boolean validateInterval(String column, int line) {
return line >= 1 && line <= MAX_LIGNES && convertStringToInt(column)>=convertStringToInt("A") && convertStringToInt(column)<=convertStringToInt(MAX_COLONNES);
}
private int convertStringToInt(String str){
int ascii=0;
for(int i = 0; i < str.length(); i++){ // while counting characters if less than the length add one
char character = str.charAt(i); // start on the first character
ascii = ascii+(int) character;
}
return ascii;
}
}