Hi. Our workflow with book supposed, that context could have several states. Formulas should be calculated depended of context state.
So i have found that cell, that was calculated in previous state will not recalculated, when i change context state.
Can you please suggest some “invalidate” method for force recalc?
public class AsposeTest {
private boolean locked;
public boolean isLocked() {
return locked;
}
public void setLocked(boolean locked) {
this.locked = locked;
}
public class Resolver implements ICustomFunction {
@Override
public Object calculateCustomFunction(String s, ArrayList arrayList, ArrayList arrayList2) {
if (AsposeTest.this.isLocked()) {
return “is locked”;
} else {
return “unlocked”;
}
}
}
public void testRecalculationCell() {
try {
Workbook wb = new Workbook();
Cells cells = wb.getWorksheets().get(0).getCells();
Resolver resolver = new Resolver();
Cell cell = cells.get(“A3”);
cell.setFormula("=MYCUSTOM()");
setLocked(true);
cell.calculate(false, resolver);
assertEquals(“is locked”, cell.getDisplayStringValue());
setLocked(false);
cell.calculate(false, resolver);
assertEquals(“unlocked”, cell.getDisplayStringValue());
} catch (Exception e) {
e.printStackTrace();
assertNull(e);
}
}
}
Best regards. Alexey