Bug 46536 - XSSFSheet.shiftRows(...) is not working
Summary: XSSFSheet.shiftRows(...) is not working
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-14 23:34 UTC by Matthew
Modified: 2009-02-08 08:40 UTC (History)
0 users


Attachments
the source excel file. (8.54 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2009-01-14 23:34 UTC, Matthew 		Details
the output excel file. (6.61 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2009-01-14 23:35 UTC, Matthew 		Details
error prompt by ms excel 2007 (19.98 KB, image/jpeg)
2009-01-14 23:35 UTC, Matthew 		Details
error fixed by ms excel 2007 (34.12 KB, image/jpeg)
2009-01-14 23:35 UTC, Matthew 		Details
xlsx file for test (8.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-02-05 21:58 UTC, Matthew 		Details
excel error log (495 bytes, application/zip)
2009-02-05 22:00 UTC, Matthew 		Details
the xlsx file for test (305.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-02-05 22:07 UTC, Matthew 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Matthew 2009-01-14 23:34:20 UTC 
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!
Comment 1 Matthew 2009-01-14 23:34:43 UTC 
Created attachment 23124 [details]
the source excel file.
Comment 2 Matthew 2009-01-14 23:35:15 UTC 
Created attachment 23125 [details]
the output excel file.
Comment 3 Matthew 2009-01-14 23:35:35 UTC 
Created attachment 23126 [details]
error prompt by ms excel 2007
Comment 4 Matthew 2009-01-14 23:35:50 UTC 
Created attachment 23127 [details]
error fixed by ms excel 2007
Comment 5 Matthew 2009-02-05 00:01:02 UTC 
I have to delay my company project because it rely heavily on this function. I raise the severity to critical and hope POI developers can get this bug resolved. Many thanks!
Comment 6 David Fisher 2009-02-05 09:04:40 UTC 
Hi -

Same comment as for bug 46535.

I am not saying that this is a duplicate, just that I'd like you to try xlsx and provide the repair log.

Regards,
Dave
Comment 7 Matthew 2009-02-05 21:56:26 UTC 
Thanks for your reply!
Now I use a xlsx file for testing, it produces the same error, please check the attachment file.
Comment 8 Matthew 2009-02-05 21:58:14 UTC 
Created attachment 23233 [details]
xlsx file for test
Comment 9 Matthew 2009-02-05 22:00:27 UTC 
Created attachment 23234 [details]
excel error log
Comment 10 Matthew 2009-02-05 22:07:09 UTC 
Created attachment 23235 [details]
the xlsx file for test
Comment 11 Yegor Kozlov 2009-02-08 08:40:02 UTC 
Fixed in r742126

There were several reasons why the resulting file was corrupted.
When shifting cells with formulas, we need to check the following:

1. Update formulas on the sheet to point to the new location. 
2. Remove references to the shifted cells from the calculation chain


Yegor