final int lastColumn = range.getLastColumn(); for (int col = firstColumn; col <= lastColumn; col++) { p.createComboBox(new HSSFClientAnchor(0, 0, 0, 0, (short) col, firstRow, (short) (col + 1), firstRow + 1));
public HSSFAutoFilter setAutoFilter(CellRangeAddress range) { InternalWorkbook workbook = _workbook.getWorkbook(); int sheetIndex = _workbook.getSheetIndex(this); NameRecord name = workbook.getSpecificBuiltinRecord(NameRecord.BUILTIN_FILTER_DB, sheetIndex + 1); if (name == null) { name = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, sheetIndex + 1); } // The built-in name must consist of a single Area3d Ptg. Area3DPtg ptg = new Area3DPtg(range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn(), false, false, false, false, sheetIndex); name.setNameDefinition(new Ptg[]{ptg}); AutoFilterInfoRecord r = new AutoFilterInfoRecord(); // the number of columns that have AutoFilter enabled. int numcols = 1 + range.getLastColumn() - range.getFirstColumn(); r.setNumEntries((short) numcols); int idx = _sheet.findFirstRecordLocBySid(DimensionsRecord.sid); _sheet.getRecords().add(idx, r); //create a combobox control for each column HSSFPatriarch p = createDrawingPatriarch(); for (int col = range.getFirstColumn(); col <= range.getLastColumn(); col++) { p.createComboBox(new HSSFClientAnchor(0, 0, 0, 0, (short) col, range.getFirstRow(), (short) (col + 1), range.getFirstRow() + 1)); } return new HSSFAutoFilter(this); }
public HSSFAutoFilter setAutoFilter(CellRangeAddress range) { InternalWorkbook workbook = _workbook.getWorkbook(); int sheetIndex = _workbook.getSheetIndex(this); NameRecord name = workbook.getSpecificBuiltinRecord(NameRecord.BUILTIN_FILTER_DB, sheetIndex+1); if (name == null) { name = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, sheetIndex+1); } // The built-in name must consist of a single Area3d Ptg. Area3DPtg ptg = new Area3DPtg(range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn(), false, false, false, false, sheetIndex); name.setNameDefinition(new Ptg[]{ptg}); AutoFilterInfoRecord r = new AutoFilterInfoRecord(); // the number of columns that have AutoFilter enabled. int numcols = 1 + range.getLastColumn() - range.getFirstColumn(); r.setNumEntries((short)numcols); int idx = _sheet.findFirstRecordLocBySid(DimensionsRecord.sid); _sheet.getRecords().add(idx, r); //create a combobox control for each column HSSFPatriarch p = createDrawingPatriarch(); for(int col = range.getFirstColumn(); col <= range.getLastColumn(); col++){ p.createComboBox(new HSSFClientAnchor(0,0,0,0, (short)col, range.getFirstRow(), (short)(col+1), range.getFirstRow()+1)); } return new HSSFAutoFilter(this); }
final int lastColumn = range.getLastColumn(); for (int col = firstColumn; col <= lastColumn; col++) { p.createComboBox(new HSSFClientAnchor(0, 0, 0, 0, (short) col, firstRow, (short) (col + 1), firstRow + 1));