ctTable.getAutoFilter().setRef(ref);
ctTable.getAutoFilter().setRef(filterRef);
@Override public XSSFAutoFilter setAutoFilter(CellRangeAddress range) { CTAutoFilter af = worksheet.getAutoFilter(); if(af == null) { af = worksheet.addNewAutoFilter(); } CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn()); String ref = norm.formatAsString(); af.setRef(ref); XSSFWorkbook wb = getWorkbook(); int sheetIndex = getWorkbook().getSheetIndex(this); XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); if (name == null) { name = wb.createBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); } name.getCTName().setHidden(true); CellReference r1 = new CellReference(getSheetName(), range.getFirstRow(), range.getFirstColumn(), true, true); CellReference r2 = new CellReference(null, range.getLastRow(), range.getLastColumn(), true, true); String fmla = r1.formatAsString() + ":" + r2.formatAsString(); name.setRefersToFormula(fmla); return new XSSFAutoFilter(this); }
ctTable.getAutoFilter().setRef(ref);
ctTable.getAutoFilter().setRef(filterRef);
public void processTable(XLXContext context, String tableStartRef) { int col = table.getEndCellReference().getCol(); long currentRow = context.getCurrentRow() - 1; int totalsRowCount = (int) table.getCTTable().getTotalsRowCount(); CTAutoFilter filter = table.getCTTable().getAutoFilter(); if(filter != null){ String autoFilterRef = new CellReference((int) (currentRow - totalsRowCount),col).formatAsString(); table.getCTTable().getAutoFilter().setRef(tableStartRef + ":" + autoFilterRef); } String tableEndRef = new CellReference((int)currentRow,col).formatAsString(); table.getCTTable().setRef(tableStartRef + ":" + tableEndRef); context.processTable(table); }
autoFilter.setRef(reference.formatAsString());
public XSSFAutoFilter setAutoFilter(CellRangeAddress range) { CTAutoFilter af = worksheet.getAutoFilter(); if(af == null) af = worksheet.addNewAutoFilter(); CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn()); String ref = norm.formatAsString(); af.setRef(ref); XSSFWorkbook wb = getWorkbook(); int sheetIndex = getWorkbook().getSheetIndex(this); XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); if (name == null) { name = wb.createBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); name.getCTName().setHidden(true); CellReference r1 = new CellReference(getSheetName(), range.getFirstRow(), range.getFirstColumn(), true, true); CellReference r2 = new CellReference(null, range.getLastRow(), range.getLastColumn(), true, true); String fmla = r1.formatAsString() + ":" + r2.formatAsString(); name.setRefersToFormula(fmla); } return new XSSFAutoFilter(this); }
@Override public XSSFAutoFilter setAutoFilter(CellRangeAddress range) { CTAutoFilter af = worksheet.getAutoFilter(); if(af == null) { af = worksheet.addNewAutoFilter(); } CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn()); String ref = norm.formatAsString(); af.setRef(ref); XSSFWorkbook wb = getWorkbook(); int sheetIndex = getWorkbook().getSheetIndex(this); XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); if (name == null) { name = wb.createBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex); } name.getCTName().setHidden(true); CellReference r1 = new CellReference(getSheetName(), range.getFirstRow(), range.getFirstColumn(), true, true); CellReference r2 = new CellReference(null, range.getLastRow(), range.getLastColumn(), true, true); String fmla = r1.formatAsString() + ":" + r2.formatAsString(); name.setRefersToFormula(fmla); return new XSSFAutoFilter(this); }