List of shiftRows() Examples

Examples of shiftRows()

org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows()
Shifts rows between startRow and endRow n number of rows. If you use a negative number, it will shift rows up. Code ensures that rows don't wrap around. Calls shiftRows(startRow, endRow, n, false, false);
Additionally shifts merged regions that are completely defined in these rows (ie. merged 2 cells on a row to be shifted). @param startRow the row to start shifting @param endRow the row to end shifting @param n the number of rows to shift
org.apache.poi.ss.usermodel.Sheet.shiftRows()
Shifts rows between startRow and endRow n number of rows. If you use a negative number, it will shift rows up. Code ensures that rows don't wrap around. Calls shiftRows(startRow, endRow, n, false, false);
Additionally shifts merged regions that are completely defined in these rows (ie. merged 2 cells on a row to be shifted). @param startRow the row to start shifting @param endRow the row to end shifting @param n the number of rows to shift

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

    }


    private void bug53798Work(Workbook wb, File xlsOutput) throws IOException {
        Sheet testSheet = wb.getSheetAt(0);


        testSheet.shiftRows(2, 2, 1);


        saveAndReloadReport(wb, xlsOutput);


        // 1) corrupted xlsx (unreadable data in the first row of a shifted group) already comes about
        // when shifted by less than -1 negative amount (try -2)

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()


        saveAndReloadReport(wb, xlsOutput);


        // 1) corrupted xlsx (unreadable data in the first row of a shifted group) already comes about
        // when shifted by less than -1 negative amount (try -2)
        testSheet.shiftRows(3, 3, -1);


        saveAndReloadReport(wb, xlsOutput);


        testSheet.shiftRows(2, 2, 1);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

        // when shifted by less than -1 negative amount (try -2)
        testSheet.shiftRows(3, 3, -1);


        saveAndReloadReport(wb, xlsOutput);


        testSheet.shiftRows(2, 2, 1);


        saveAndReloadReport(wb, xlsOutput);


        Row newRow = null;
        Cell newCell = null;

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

        // 3) once a negative shift has been made any attempt to shift another group of rows
        // (note: outside of previously negative shifted rows) by a POSITIVE amount causes POI exception:
        // org.apache.xmlbeans.impl.values.XmlValueDisconnectedException.
        // NOTE: another negative shift on another group of rows is successful, provided no new rows in
        // place of previously shifted rows were attempted to be created as explained above.
        testSheet.shiftRows(6, 7, 1);   // -- CHANGE the shift to positive once the behaviour of
                                        // the above has been tested


        saveAndReloadReport(wb, xlsOutput);
    }

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

        assertEquals("[1]!LUCANET(\"Ist\")", cFunc.getCellFormula());
        Cell cRef = sheet.getRow(3).createCell(1);
        cRef.setCellFormula("A3");
        
        // Shift it down one row
        sheet.shiftRows(1, sheet.getLastRowNum(), 1);
        
        // Check the new formulas: Function won't change, Reference will
        cFunc = sheet.getRow(4).getCell(0);
        assertEquals("[1]!LUCANET(\"Ist\")", cFunc.getCellFormula());
        cRef = sheet.getRow(4).getCell(1);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

      Workbook wb = XSSFTestDataSamples.openSampleWorkbook("48495.xlsx");
      
      assertSheetOrder(wb, "Sheet1");
      
      Sheet sheet = wb.getSheetAt(0);
      sheet.shiftRows(2, sheet.getLastRowNum(), 1, true, false);
      Row newRow = sheet.getRow(2);
      if (newRow == null) newRow = sheet.createRow(2);
      newRow.createCell(0).setCellValue(" Another Header");
      wb.cloneSheet(0);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

  }


  private void bug53798Work(Workbook wb, File xlsOutput) throws IOException {
    Sheet testSheet  = wb.getSheetAt(0);


    testSheet.shiftRows(2, 2, 1);


    saveAndReloadReport(wb, xlsOutput);


    // 1) corrupted xlsx (unreadable data in the first row of a shifted group) already comes about
    // when shifted by less than -1 negative amount (try -2)

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()


    saveAndReloadReport(wb, xlsOutput);


    // 1) corrupted xlsx (unreadable data in the first row of a shifted group) already comes about
    // when shifted by less than -1 negative amount (try -2)
    testSheet.shiftRows(3, 3, -1);


    saveAndReloadReport(wb, xlsOutput);


    testSheet.shiftRows(2, 2, 1);

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

    // when shifted by less than -1 negative amount (try -2)
    testSheet.shiftRows(3, 3, -1);


    saveAndReloadReport(wb, xlsOutput);


    testSheet.shiftRows(2, 2, 1);


    saveAndReloadReport(wb, xlsOutput);


    Row newRow = null;
    Cell newCell = null;

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Sheet.shiftRows()

    // 3) once a negative shift has been made any attempt to shift another group of rows
    // (note: outside of previously negative shifted rows) by a POSITIVE amount causes POI exception:
    // org.apache.xmlbeans.impl.values.XmlValueDisconnectedException.
    // NOTE: another negative shift on another group of rows is successful, provided no new rows in
    // place of previously shifted rows were attempted to be created as explained above.
    testSheet.shiftRows(6, 7, 1);  // -- CHANGE the shift to positive once the behaviour of
                    // the above has been tested


    saveAndReloadReport(wb, xlsOutput);
  }

View Full Code Here

0 1 2 3 4 5

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.