Hello. I needed to build right style’s enumeration. So i have implemented array’s comparator, that applies different border style for two neighbor cells, then reads a border style for result and decide, that border style had biggest priority. But in some step each cell had different cell’s border. Can you help me with this issue?
private static class StyleComparator implements Comparator {
private Cells cells;
private int column;
private StyleComparator(Cells cells) {
this.cells = cells;
this.column = 3;
}
@Override
public int compare(Integer o1, Integer o2) {
Style cs1 = cells.getCellStyle(3, column);
cs1.setBorder(BorderType.BOTTOM_BORDER, o1, Color.getBlack());
cells.get(3, column).setStyle(cs1);
Style cs2 = cells.getCellStyle(4, column);
cs2.setBorder(BorderType.TOP_BORDER, o2, Color.getBlack());
cells.get(4, column).setStyle(cs2);
cs1 = cells.getCellStyle(3, column);
Integer result1 = cs1.getBorders().getByBorderType(BorderType.BOTTOM_BORDER).getLineStyle();
cs2 = cells.getCellStyle(4, column);
Integer result2 = cs2.getBorders().getByBorderType(BorderType.TOP_BORDER).getLineStyle();
assertEquals(result1, result2);
cells.get(6, column).putValue(result1);
column += 2;
if (result1.equals(o1)) {
return 1;
} else if (result1.equals(o2)) {
return -1;
} else {
return 0;
}
}
}
public void bordersTest() throws Exception {
Workbook wb = new Workbook();
Cells cells = wb.getWorksheets().get(0).getCells();
List styles = Arrays.asList(
CellBorderType.NONE,
CellBorderType.THIN,
CellBorderType.MEDIUM,
CellBorderType.DASHED,
CellBorderType.DOTTED,
CellBorderType.THICK,
CellBorderType.DOUBLE,
CellBorderType.HAIR,
CellBorderType.MEDIUM_DASHED,
CellBorderType.MEDIUM_DASH_DOT,
CellBorderType.DASH_DOT_DOT,
CellBorderType.MEDIUM_DASH_DOT_DOT,
CellBorderType.SLANTED_DASH_DOT,
CellBorderType.DASH_DOT
);
Collections.sort(styles, new StyleComparator(cells));
for (Integer style : styles) {
System.out.println(style);
}
wb.save(“D:\out.xlsx”);
}