Good day.
I have founded a some issue, that blocked my development. I need to check a some parameter of custom function for belonging a referred area. There is example:
public static class ISCELL implements ICustomFunction {
public static Integer CONTEXT_REFERRED_AREAS = 4;
private static ReferredArea getReferredArea(ArrayList contextObjects, int index) {
ReferredAreaCollection areas = (ReferredAreaCollection) contextObjects.get(CONTEXT_REFERRED_AREAS);
return areas == null || areas.getCount() <= index ? null : areas.get(index);
}
protected static boolean isCellRef(ArrayList contextObjects, int index) {
return getReferredArea(contextObjects, index) != null;
}
@Override
public Object calculateCustomFunction(String s, ArrayList paramValues, ArrayList contextObjects) {
if (“ISCELL”.equals(s)) {
return isCellRef(contextObjects, 0) ? 1 : 0;
}
return null;
}
}
public void formulaTest() {
try {
Workbook wb = new Workbook(“D://test.xls”);
Worksheet sheet = wb.getWorksheets().get(0);
wb.calculateFormula(true, new ISCELL());
assertEquals(1, (int)sheet.getCells().get(“B3”).getValue());
} catch (Exception e) {
e.printStackTrace();
assertNull(e);
}
}
May be i have selected wrong way for checking a referred area.