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

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


    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

    // 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

    // 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

    Workbook wb = XSSFTestDataSamples.openSampleWorkbook("53798.xlsx");


    Sheet testSheet  = wb.getSheetAt(0);
    // 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, -2);
    
    Row newRow = null; Cell newCell = null;
    // 2) attempt to create a new row IN PLACE of a removed row by a negative shift causes corrupted 
    // xlsx file with  unreadable data in the negative shifted row. 
    // NOTE it's ok to create any other row.

View Full Code Here

    // 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
    
    //saveReport(wb, new File("/tmp/53798.xlsx"));
    Workbook read = XSSFTestDataSamples.writeOutAndReadBack(wb);
    assertNotNull(read);

View Full Code Here

  
  public void testBug53798a() throws IOException {
    Workbook wb = XSSFTestDataSamples.openSampleWorkbook("53798.xlsx");


    Sheet testSheet  = wb.getSheetAt(0);
    testSheet.shiftRows(3, 3, -1);
        for (Row r : testSheet) {
          r.getRowNum();
        }
    testSheet.shiftRows(6, 6, 1);

View Full Code Here

    Sheet testSheet  = wb.getSheetAt(0);
    testSheet.shiftRows(3, 3, -1);
        for (Row r : testSheet) {
          r.getRowNum();
        }
    testSheet.shiftRows(6, 6, 1);
    
    //saveReport(wb, new File("/tmp/53798.xlsx"));
    Workbook read = XSSFTestDataSamples.writeOutAndReadBack(wb);
    assertNotNull(read);

View Full Code Here

       
       // Test the last Row number it currently correct
       assertEquals(2, sheet.getLastRowNum());
       
       // Shift the first row to the end
       sheet.shiftRows(0, 0, 3);
       assertEquals(3, sheet.getLastRowNum());
       assertEquals(-1,         sheet.getRow(0).getLastCellNum());
       assertEquals("Cell A,2", sheet.getRow(1).getCell(0).getStringCellValue());
       assertEquals("Cell A,3", sheet.getRow(2).getCell(0).getStringCellValue());
       assertEquals("Cell A,1", sheet.getRow(3).getCell(0).getStringCellValue());

View Full Code Here

       assertEquals("Cell A,2", sheet.getRow(1).getCell(0).getStringCellValue());
       assertEquals("Cell A,3", sheet.getRow(2).getCell(0).getStringCellValue());
       assertEquals("Cell A,1", sheet.getRow(3).getCell(0).getStringCellValue());
       
       // Shift the 2nd row up to the first one
       sheet.shiftRows(1, 1, -1);
       assertEquals(3, sheet.getLastRowNum());
       assertEquals("Cell A,2", sheet.getRow(0).getCell(0).getStringCellValue());
       assertEquals(-1,         sheet.getRow(1).getLastCellNum());
       assertEquals("Cell A,3", sheet.getRow(2).getCell(0).getStringCellValue());
       assertEquals("Cell A,1", sheet.getRow(3).getCell(0).getStringCellValue());

View Full Code Here

       assertEquals(-1,         sheet.getRow(1).getLastCellNum());
       assertEquals("Cell A,3", sheet.getRow(2).getCell(0).getStringCellValue());
       assertEquals("Cell A,1", sheet.getRow(3).getCell(0).getStringCellValue());


       // Shift the 4th row up into the gap in the 3rd row
       sheet.shiftRows(3, 3, -2);
       assertEquals(2, sheet.getLastRowNum());
       assertEquals("Cell A,2", sheet.getRow(0).getCell(0).getStringCellValue());
       assertEquals("Cell A,1", sheet.getRow(1).getCell(0).getStringCellValue());
       assertEquals("Cell A,3", sheet.getRow(2).getCell(0).getStringCellValue());
       assertEquals(-1,         sheet.getRow(3).getLastCellNum());

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.