Cell.java
2.64 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
package kernel;
import kernel.exception.CreateCycleException;
import kernel.exception.InvalidIntervalLineColumnEception;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
public class Cell implements Serializable{
final int MAX_LIGNES=20;
private String column;
private Integer line;
private Double value;
private Formula formula;
private List<Cell> usedIn = new ArrayList<>();
public Cell(String column, Integer line, Double value) throws InvalidIntervalLineColumnEception {
column=column.toUpperCase();
if ((line>= 1 && line<=MAX_LIGNES) || (column.compareTo("A")>=0 && column.compareTo("Z")<=0)){
this.column = column;
this.line = line;
this.setValue(value);
}
else
throw new InvalidIntervalLineColumnEception();
}
public Cell(String column, Integer line, Formula formula) throws CreateCycleException,InvalidIntervalLineColumnEception {
column=column.toUpperCase();
if ((line>= 1 && line<=MAX_LIGNES) || (column.compareTo("A")>=0 && column.compareTo("Z")<=0)){
this.column = column;
this.line = line;
this.setFormula(formula);
}
else
throw new InvalidIntervalLineColumnEception();
}
public Double getValue() {
return this.value;
}
public Formula getFormula() {
return this.formula;
}
public String getDevelopedFormula() {
return this.containFormula() ? this.formula.getDevelopedFormula() : this.getId();
}
public String getId() {
return this.column + this.line.toString();
}
public List<Cell> getUsedIn() {
return this.usedIn;
}
public String toString() {
return this.containFormula() ? this.formula.toString() : this.getId();
}
public void updateValue() {
if (this.containFormula())
this.value = this.formula.eval();
}
public Boolean containFormula() {
return this.formula != null;
}
public void setFormula(Formula formula) throws CreateCycleException {
if (formula.createCycle(this))
throw new CreateCycleException();
else {
this.formula = formula;
for (Cell cell : this.formula.getUtilisedCells())
cell.usedIn.add(this);
this.updateValue();
this.spreadValue();
}
}
public void setValue(Double value) {
this.value = value;
this.formula = null;
this.spreadValue();
}
private void spreadValue() {
for (Cell cell : this.usedIn) {
cell.updateValue();
cell.spreadValue();
}
}
}