// ZSS-901
public String getAutoFilterBorder() {
StringBuffer sb = new StringBuffer();
final SAutoFilter filter = _sheet.getAutoFilter();
if (filter == null) return "____"; // empty
// must check in top/left/bottom/right order
final CellRegion rgn = filter.getRegion();
final int t = rgn.getRow();
final int l = rgn.getColumn();
final int b = rgn.getLastRow();
final int r = rgn.getLastColumn();
final int r0 = _cell.getRowIndex();
final int c0 = _cell.getColumnIndex();
sb.append(r0 == t && l <= c0 && c0 <= r ? "t" : "_");
sb.append(c0 == l && t <= r0 && r0 <= b ? "l" : "_");
sb.append(r0 == b && l <= c0 && c0 <= r ? "b" : "_");
sb.append(c0 == r && t <= r0 && r0 <= b ? "r" : "_");
return sb.toString();
}
// ZSS-1019
protected void importAutoFilterColumns(
AutoFilter poiFilter, SAutoFilter zssFilter, int numberOfColumn) {
for (int i = 0; i < numberOfColumn; i++) {
FilterColumn srcColumn = poiFilter.getFilterColumn(i);
if (srcColumn == null) {
continue;
}
NFilterColumn destColumn = zssFilter.getFilterColumn(i, true);
destColumn.setProperties(
PoiEnumConversion.toFilterOperator(srcColumn.getOperator()),
srcColumn.getCriteria1(),
srcColumn.getCriteria2(),
srcColumn.isOn());
}
}