Cell.java
2.38 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
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 {
private static final long serialVersionUID = 1L;
final int MAX_LIGNES = 20;
private String column;
private int line;
private double value;
private Formula formula;
private List<Cell> usedIn = new ArrayList<>();
public boolean IntervallCondition(String column, int line){
return line >= 1 && line <= MAX_LIGNES && column.compareTo("A") >= 0 && column.compareTo("Z") <= 0;
}
public Cell(String column,int line, double value) throws InvalidIntervalLineColumnEception {
column = column.toUpperCase();
if (IntervallCondition(column,line)) {
this.column = column;
this.line = line;
this.setValue(value);
} else
throw new InvalidIntervalLineColumnEception();
}
public Cell(String column, int line, Formula formula)
throws CreateCycleException, InvalidIntervalLineColumnEception {
column = column.toUpperCase();
if (IntervallCondition(column,line)) {
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;
}
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();
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();
}
}
}