sheet.addMergedRegion(new CellRangeAddress(1,1,4,1));
/** * @param in the RecordInputstream to read the record from */ public CellRangeAddressList(RecordInputStream in) { this(); int nItems = in.readUShort(); for (int k = 0; k < nItems; k++) { _list.add(new CellRangeAddress(in)); } } /**
protected void createEmpty() { field_3_enclosing_cell_range = new CellRangeAddress(0, 0, 0, 0); field_4_cell_ranges = new CellRangeAddressList(); } protected void read(RecordInputStream in) {
/** * Add a cell range structure. * * @param firstRow - the upper left hand corner's row * @param firstCol - the upper left hand corner's col * @param lastRow - the lower right hand corner's row * @param lastCol - the lower right hand corner's col */ public void addCellRangeAddress(int firstRow, int firstCol, int lastRow, int lastCol) { CellRangeAddress region = new CellRangeAddress(firstRow, lastRow, firstCol, lastCol); addCellRangeAddress(region); } public void addCellRangeAddress(CellRangeAddress cra) {
public String getReferenceText() { CellRangeAddress cra = new CellRangeAddress(_firstRow, _firstRow+_height-1, _firstColumn, _firstColumn+_width-1); return cra.formatAsString(); }
@Override public void merge(int firstRow, int lastRow, int firstCol, int lastCol) { CellRangeAddress cra = new CellRangeAddress(firstRow, lastRow, firstCol, lastCol); context.getCurrentSheet().addMergedRegion(cra); }
public FtrHeader(RecordInputStream in) { recordType = in.readShort(); grbitFrt = in.readShort(); associatedRange = new CellRangeAddress(in); }
/** * Initialize a new url link */ public void newUrlLink() { _range = new CellRangeAddress(0, 0, 0, 0); _guid = STD_MONIKER; _linkOpts = HLINK_URL | HLINK_ABS | HLINK_LABEL; setLabel(""); _moniker = URL_MONIKER; setAddress(""); _uninterpretedTail = URL_TAIL; }
protected void read(RecordInputStream in) { field_1_numcf = in.readShort(); field_2_need_recalculation_and_id = in.readShort(); field_3_enclosing_cell_range = new CellRangeAddress(in); field_4_cell_ranges = new CellRangeAddressList(in); }
/** * Initialize a new document link */ public void newDocumentLink() { _range = new CellRangeAddress(0, 0, 0, 0); _guid = STD_MONIKER; _linkOpts = HLINK_LABEL | HLINK_PLACE; setLabel(""); _moniker = FILE_MONIKER; setAddress(""); setTextMark(""); }
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getHeaderRowCount() < 1) return null; return new CellRangeAddress(table.getStartRowIndex(), table.getStartRowIndex(), table.getStartColIndex(), table.getStartColIndex()); } },
private void addMergedRegionToCurrentSheet(int startRow) { for (com.alibaba.excel.metadata.CellRange cellRangeModel : excelHeadProperty.getCellRangeModels()) { currentSheet.addMergedRegion(new CellRangeAddress(cellRangeModel.getFirstRow() + startRow, cellRangeModel.getLastRow() + startRow, cellRangeModel.getFirstCol(), cellRangeModel.getLastCol())); } }
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getHeaderRowCount() < 1) return null; return new CellRangeAddress(table.getStartRowIndex(), table.getStartRowIndex(), table.getEndColIndex(), table.getEndColIndex()); } },
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getTotalsRowCount() < 1) return null; return new CellRangeAddress(table.getEndRowIndex() - table.getTotalsRowCount() +1, table.getEndRowIndex(), table.getStartColIndex(), table.getEndColIndex()); } },
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getTotalsRowCount() < 1) return null; return new CellRangeAddress(table.getEndRowIndex() - table.getTotalsRowCount() +1, table.getEndRowIndex(), table.getStartColIndex(), table.getStartColIndex()); } },
/** * Removes an array formula * @return the range of the array formula containing the specified cell. Never <code>null</code> */ public CellRangeAddress removeArrayFormula(int rowIndex, int columnIndex) { CellRangeAddress8Bit a = _sharedValueManager.removeArrayFormula(rowIndex, columnIndex); // at this point FormulaRecordAggregate#isPartOfArrayFormula() should return false _formulaRecord.setParsedExpression(null); return new CellRangeAddress(a.getFirstRow(), a.getLastRow(), a.getFirstColumn(), a.getLastColumn()); } }
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (! table.getStyle().isShowFirstColumn()) return null; return new CellRangeAddress(table.getStartRowIndex(), table.getEndRowIndex(), table.getStartColIndex(), table.getStartColIndex()); } },
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getTotalsRowCount() < 1) return null; return new CellRangeAddress(table.getEndRowIndex() - table.getTotalsRowCount() +1, table.getEndRowIndex(), table.getEndColIndex(), table.getEndColIndex()); } },
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (! table.getStyle().isShowLastColumn()) return null; return new CellRangeAddress(table.getStartRowIndex(), table.getEndRowIndex(), table.getEndColIndex(), table.getEndColIndex()); } },
public CellRangeAddressBase getRange(Table table, CellReference cell) { if (table.getHeaderRowCount() < 1) return null; return new CellRangeAddress(table.getStartRowIndex(), table.getStartRowIndex() + table.getHeaderRowCount() -1, table.getStartColIndex(), table.getEndColIndex()); } },