poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 63660] New: XSSFSheet.shiftRows() the cell value didn't ref to new row in version 4.1.0
Date Tue, 13 Aug 2019 03:27:22 GMT

            Bug ID: 63660
           Summary: XSSFSheet.shiftRows() the cell value didn't ref to new
                    row in version 4.1.0
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: chaichunyang@gmail.com
  Target Milestone: ---

i'd to use poi 4.1.0 generator a excel file with a List Data

and i get a wrong excel file when i use XSSFSheet.shiftRows(),my excel has some
contents as footer, so i need to shift the row down before insert a new row.
the question is when i shift the row down,the footer cell include the
mergedcell has shift down already,but the cell value didn't move,still in old
cell's position.

i found the nightly build【poi-bin-4.1.1-SNAPSHOT-20190807.tar.gz】may have
solved this problem. 

So. When the version 4.1.1 will be release.  This problem has a great impact on
i use maven to build my project, can i fix this in other way?

thank you very much!

follow the code:

File file = new File("/Users/chaichunyang/Documents/test.xlsx");
Workbook workbook = WorkbookFactory.create(file);
Sheet sheet = workbook.getSheetAt(0);//already confirm this is a XSSFSheet

//shift the row down at 1
sheet.shiftRows(1, sheet.getLastRowNum(), 1);

//create new row at 1
Row newRow = sheet.createRow(1);
//create new cell
Cell newCell = newRow.createCell(0);
//...handle the List

//out a new excel file
workbook.write(new FileOutputStream(new

You are receiving this mail because:
You are the assignee for the bug.
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message