/** * Return absolute row index taking into account region. * * @param region Region which contains row. * @param row Row index in the region. * @return Absolute row index. */ public static int getAbsoluteRow(IGridRegion region, int row) { return row + region.getTop(); }
@Override public ICellStyle getStyle(int row, int column) { int index = cellIndexes[row - region.getTop()][column - region.getLeft()]; return new OpenLCellStyle(index, extendedFormats.get(index), palette, customFormats); }
private void saveStyleIndex(CellValueRecordInterface r, int row, short column) { short styleIndex = r.getXFIndex(); int internalRow = row - tableRegion.getTop(); int internalCol = column - tableRegion.getLeft(); cellIndexes[internalRow][internalCol] = styleIndex; }
public int getHeight() { if (region == null){ return delegate.getHeight(); } return region.getBottom() - region.getTop() + 1; }
@Override public ICell getTopLeftCellFromRegion() { IGridRegion region = getRegion(); return region == null ? this : grid.getCell(region.getLeft(), region.getTop()); }
@Override public ICellFont getFont(int row, int column) { int index = cellIndexes[row - region.getTop()][column - region.getLeft()]; return new OpenLCellFont(getFont(extendedFormats.get(index).getFontIndex()), palette); }
@Override public ICellStyle getStyle(int row, int column) { int index = cellIndexes[row - region.getTop()][column - region.getLeft()]; // For XSSF workbook isn't needed return new XlsCellStyle(stylesTable.getStyleAt(index), null); }
public static IUndoableGridTableAction removeRows(int nRows, int startRow, IGridRegion region, IGrid grid, MetaInfoWriter metaInfoWriter) { int w = IGridRegion.Tool.width(region); int h = IGridRegion.Tool.height(region); int firstToMove = region.getTop() + startRow + nRows; ArrayList<IUndoableGridTableAction> actions = new ArrayList<>(w * (h - startRow)); // resize merged regions -> shift cells by row -> clear cells actions.addAll(resizeMergedRegions(grid, startRow, nRows, REMOVE, ROWS, region, metaInfoWriter)); actions.addAll(shiftRows(firstToMove, nRows, REMOVE, region, grid, metaInfoWriter)); actions.addAll(clearCells(region.getLeft(), w, region.getBottom() + 1 - nRows, nRows, grid, metaInfoWriter)); return new UndoableCompositeAction(actions); } }
/** * Gets the URI to the table by table region. Just calls * {@link XlsSheetGridModel#getRangeUri(int, int, int, int)}. * * @param region Table region. * @return URI to the table in the sheet. (e.g. * <code>file:D:\work\Workspace\org.openl.tablets.tutorial4\rules * \main&wbName=Tutorial_4.xls&wsName=Vehicle-Scoring&range=B3:D12</code>) */ public String getRangeUri(IGridRegion region) { return getRangeUri(region.getLeft(), region.getTop(), region.getRight(), region.getBottom()); }
public synchronized void setFontItalic(int row, int col, boolean italic) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetItalicAction( region.getLeft() + col, region.getTop() + row, italic); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setAlignment(int row, int col, HorizontalAlignment alignment) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetAlignmentAction( region.getLeft() + col, region.getTop() + row, alignment); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFontUnderline(int row, int col, boolean underlined) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetUnderlineAction( region.getLeft() + col, region.getTop() + row, underlined); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFontBold(int row, int col, boolean bold) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetBoldAction( region.getLeft() + col, region.getTop() + row, bold); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setIndent(int row, int col, int indent) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetIndentAction( region.getLeft() + col, region.getTop() + row, indent); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFillColor(int row, int col, short[] color) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetFillColorAction( region.getLeft() + col, region.getTop() + row, color); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFontColor(int row, int col, short[] color) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetColorAction( region.getLeft() + col, region.getTop() + row, color); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setAlignment(int row, int col, HorizontalAlignment alignment) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetAlignmentAction( region.getLeft() + col, region.getTop() + row, alignment, getMetaInfoWriter()); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFontBold(int row, int col, boolean bold) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetBoldAction( region.getLeft() + col, region.getTop() + row, bold, getMetaInfoWriter()); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFillColor(int row, int col, short[] color) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetFillColorAction( region.getLeft() + col, region.getTop() + row, color, getMetaInfoWriter()); ua.doAction(gridTable); actions.addNewAction(ua); }
public synchronized void setFontItalic(int row, int col, boolean italic) { IGridRegion region = getOriginalTableRegion(); IUndoableGridTableAction ua = new SetItalicAction( region.getLeft() + col, region.getTop() + row, italic, getMetaInfoWriter()); ua.doAction(gridTable); actions.addNewAction(ua); }