https://issues.apache.org/bugzilla/show_bug.cgi?id=46536
Summary: XSSFSheet.shiftRows(...) is not working
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I use following codes to shift rows, the result output file cannot be opened by
MS Excel 2007. (In fact, it can be opened but which need to be recovered by MS
Excel 2007.) And the result content is not as expected.
--
Workbook wb = new XSSFWorkbook("original2.xlsm");
Sheet sheet = wb.getSheet("Test");
sheet.shiftRows(1, sheet.getLastRowNum(), 3, false, true);
FileOutputStream output = new FileOutputStream("output2.xlsm");
wb.write(output);
--
Thanks!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]