List of moveRange() Examples

Examples of moveRange()

com.sun.star.sheet.XCellRangeMovement.moveRange()
org.zkoss.zss.engine.RefSheet.moveRange()
Move a range of cells to a new position as specified by nCol(positive to move right, negative to move left) and nRow(positive to move down, negative to move up) @param tRow top row index of the range @param lCol left column index of the range @param bRow bottom row index of the range @param rCol right column index of the range @param nRow number of rows to move @param nCol number of columns to move @return the to be evaluated references(for re-evaluation, at [0]) and all affected references(for re-render, at [1])

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.StartRow = intRow + 1;
                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in the document
                                    xcellrangemovement.moveRange( celladdress, cellrangeaddress );
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex( intRow + 1, 1 );
                                    
                                    // Set the current row, because we want to recalculate all rows below

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in
                                    // the document
                                    xcellrangemovement.moveRange(celladdress,
                                                                 cellrangeaddress);
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex(intRow
                                                                            + 1, 1);

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in
                                    // the document
                                    xcellrangemovement.moveRange(celladdress,
                                                                 cellrangeaddress);
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex(intRow
                                                                            + 1, 1);

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.StartRow = intRow + 1;
                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in the document
                                    xcellrangemovement.moveRange( celladdress, cellrangeaddress );
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex( intRow + 1, 1 );
                                    
                                    // Set the current row, because we want to recalculate all rows below

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in
                                    // the document
                                    xcellrangemovement.moveRange(celladdress,
                                                                 cellrangeaddress);
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex(intRow
                                                                            + 1, 1);

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.StartRow = intRow + 1;
                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in the document
                                    xcellrangemovement.moveRange( celladdress, cellrangeaddress );
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex( intRow + 1, 1 );
                                    
                                    // Set the current row, because we want to recalculate all rows below

View Full Code Here

Examples of com.sun.star.sheet.XCellRangeMovement.moveRange()

                                    cellrangeaddress.EndColumn = 8;
                                    cellrangeaddress.EndRow = intRow + 1;
                                    
                                    // Moves the cell range to another position in
                                    // the document
                                    xcellrangemovement.moveRange(celladdress,
                                                                 cellrangeaddress);
                                    
                                    // Removing the row not needed anymore
                                    xcolumnrowrange.getRows().removeByIndex(intRow
                                                                            + 1, 1);

View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet.moveRange()

    if (nRow == 0 && nCol == 0) { //nothing to do!
      return null;
    }
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.moveRange(tRow, lCol, bRow, rCol, nRow, nCol);
    final List<CellRangeAddress[]> shiftedRanges = nCol != 0 && nRow == 0 ? 
      ((HSSFSheetImpl)sheet).shiftColumnsRange(lCol, rCol, nCol, tRow, bRow, true, false, true, false, Range.FORMAT_NONE):
      nCol == 0 && nRow != 0 ?
      ((HSSFSheetImpl)sheet).shiftRowsRange(tRow, bRow, nRow, lCol, rCol, true, false, true, false, Range.FORMAT_NONE):
      ((HSSFSheetImpl)sheet).shiftBothRange(tRow, bRow, nRow, lCol, rCol, nCol, true); //nCol != 0 && nRow != 0

View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet.moveRange()

    if (nRow == 0 && nCol == 0) { //nothing to do!
      return null;
    }
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.moveRange(tRow, lCol, bRow, rCol, nRow, nCol);
    final List<CellRangeAddress[]> shiftedRanges = nCol != 0 && nRow == 0 ? 
      ((XSSFSheetImpl)sheet).shiftColumnsRange(lCol, rCol, nCol, tRow, bRow, true, false, true, false, Range.FORMAT_NONE):
      nCol == 0 && nRow != 0 ?
      ((XSSFSheetImpl)sheet).shiftRowsRange(tRow, bRow, nRow, lCol, rCol, true, false, true, false, Range.FORMAT_NONE):
      ((XSSFSheetImpl)sheet).shiftBothRange(tRow, bRow, nRow, lCol, rCol, nCol, true); //nCol != 0 && nRow != 0

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.