public GridTable(int top, int left, int bottom, int right, IGrid grid) { this(new GridRegion(top, left, bottom, right), grid); }
public IGridRegion getRegion() { return height == 1 && width == 1 ? null : new GridRegion(row, column, row + height - 1, column + width - 1); }
public IGridRegion getAbsoluteRegion() { IGridRegion absoluteRegion = getRegion(); if (absoluteRegion == null) { absoluteRegion = new GridRegion(row, column, row, column); } return absoluteRegion; }
@Override public IGridRegion getAbsoluteRegion() { IGridRegion absoluteRegion = getRegion(); if (absoluteRegion == null) { absoluteRegion = new GridRegion(row, column, row, column); } return absoluteRegion; }
public IGridRegion getAbsoluteRegion() { IGridRegion absoluteRegion = getRegion(); if (absoluteRegion == null) { absoluteRegion = new GridRegion(row, column, row, column); } return absoluteRegion; }
private void mergeArrayCells(IWritableGrid sheet, int rowIndex, int columnIndex, int numberOfValues) { // counting begins from 0 int lastMergedColumnIndex = columnIndex + numberOfValues - 1; sheet.addMergedRegion(new GridRegion(rowIndex, columnIndex, rowIndex, lastMergedColumnIndex)); }
private void processHorizConditionsHeaders(IGridRegion displayRowRegion, int firstLookupGridColumn, IGrid grid) throws OpenLCompilationException { IGridRegion hcHeadersRegion = new GridRegion(displayRowRegion, IGridRegion.LEFT, firstLookupGridColumn); IGridTable hcHeaderTable = new GridTable(hcHeadersRegion, grid); validateHCHeaders(hcHeaderTable); }
public static IGridRegion makeRegion(String range) { int idx = range.indexOf(AGrid.RANGE_SEPARATOR); if (idx < 0) { int col1 = getColumn(range); int row1 = getRow(range); return new GridRegion(row1, col1, row1, col1); } String[] rr = StringTool.tokenize(range, AGrid.RANGE_SEPARATOR); int col1 = getColumn(rr[0]); int row1 = getRow(rr[0]); int col2 = getColumn(rr[1]); int row2 = getRow(rr[1]); return new GridRegion(row1, col1, row2, col2); }
/** * Finds common {@link IGridRegion} for incoming regions. * * @param i1 first grid region * @param i2 second grid region * @return intersection of incoming grid regions. <code>null</code> if there is no intersection. */ public static IGridRegion intersect(IGridRegion i1, IGridRegion i2) { int left = Math.max(i1.getLeft(), i2.getLeft()); int right = Math.min(i1.getRight(), i2.getRight()); int top = Math.max(i1.getTop(), i2.getTop()); int bottom = Math.min(i1.getBottom(), i2.getBottom()); return top <= bottom && left <= right ? new GridRegion(top, left, bottom, right) : null; }
public IGridRegion findEmptyRect(int width, int height) { int lastRow = PoiExcelHelper.getLastRowNum(getSheet()); int top = lastRow + 2, left = 1; GridRegion newRegion = new GridRegion(top, left, top + height - 1, left + width - 1); if (IGridRegion.Tool.isValidRegion(newRegion, getSpreadsheetConstants())) { return newRegion; } return null; }
private IGridTable getLookupValuesTable(ILogicalTable originaltable, int firstLookupGridColumn, IGrid grid) { ILogicalTable valueTable = originaltable.getRows(DISPLAY_ROW + 1); IGridRegion lookupValuesRegion = new GridRegion((valueTable.getSource()).getRegion(), IGridRegion.LEFT, firstLookupGridColumn); return new GridTable(lookupValuesRegion, grid); }
public static IGridRegion shiftRight(Point start, int shiftRight) { return new GridRegion(start.getRow(), start.getColumn(), start.getRow(), start.getColumn() + shiftRight); }
public static IGridRegion shiftBottom(Point start, int shiftBottom) { return new GridRegion(start.getRow(), start.getColumn(), start.getRow() + shiftBottom, start.getColumn()); }
private void clearRegion(IWritableGrid grid) { IGridRegion rrTo = grid.getRegionStartingAt(getCol(), getRow()); if (rrTo == null) { return; } toRestore = new GridRegion(rrTo); grid.removeMergedRegion(toRestore); }
public IGridRegion getAbsoluteRegion() { //return delegate.getAbsoluteRegion(); return new GridRegion(delegate.getRow(), delegate.getColumn(), delegate.getRow(), delegate.getColumn()); }
public static GridRegion move(IGridRegion reg, int dx, int dy) { return new GridRegion(reg.getTop() + dy, reg.getLeft() + dx, reg.getBottom() + dy, reg.getRight() + dx); }
private void moveRegion(IWritableGrid wgrid) { IGridRegion rrFrom = wgrid.getRegionStartingAt(colFrom, rowFrom); IGridRegion rrTo = wgrid.getRegionStartingAt(getCol(), getRow()); if (rrTo != null) { toRestore = new GridRegion(rrTo); wgrid.removeMergedRegion(toRestore); } if (rrFrom != null) { GridRegion copyFrom = new GridRegion(rrFrom.getTop() + getRow() - rowFrom, rrFrom.getLeft() + getCol() - colFrom, rrFrom.getBottom() + getRow() - rowFrom, rrFrom.getRight() + getCol() - colFrom); wgrid.addMergedRegion(copyFrom); toRemove = copyFrom; } }
public static boolean canInsertColumns(IGridTable table, int nCols) { IGridRegion region = getOriginalRegion(table); GridRegion newRegion = new GridRegion(region.getTop() - 1, region.getRight() + 1, region.getBottom() + 1, region.getRight() + 1 + nCols); IGridTable[] allGridTables = table.getGrid().getTables(); for (IGridTable allGridTable : allGridTables) { if (!table.getUri().equals(allGridTable.getUri()) && IGridRegion.Tool.intersects(newRegion, allGridTable.getRegion())) { return false; } } return true; }
public static boolean canInsertRows(IGridTable table, int nRows) { IGridRegion region = getOriginalRegion(table); GridRegion newRegion = new GridRegion(region.getBottom() + 1, region.getLeft() - 1, region.getBottom() + 1 + nRows, region.getRight() + 1); IGridTable[] allGridTables = table.getGrid().getTables(); for (IGridTable allGridTable : allGridTables) { if (!table.getUri().equals(allGridTable.getUri()) && IGridRegion.Tool.intersects(newRegion, allGridTable.getRegion())) { return false; } } return true; }
public IGridRegion getRegion() { int left = getGridColumn(0, 0); int top = getGridRow(0, 0); int right = -1; int bottom = -1; if (isNormalOrientation()) { right = getGridColumn(getWidth() - 1, 0); bottom = getGridRow(0, getHeight() - 1); } else { right = getGridColumn(0, getHeight() - 1); bottom = getGridRow(getWidth() - 1, 0); } return new GridRegion(top, left, bottom, right); }