Summary: | XSSFSheet.shiftRows(...) is not working | ||
---|---|---|---|
Product: | POI | Reporter: | Matthew <matthew.knl> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | critical | ||
Priority: | P2 | ||
Version: | 3.5-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Attachments: |
the source excel file.
the output excel file. error prompt by ms excel 2007 error fixed by ms excel 2007 xlsx file for test excel error log the xlsx file for test |
Description
Matthew
2009-01-14 23:34:20 UTC
Created attachment 23124 [details]
the source excel file.
Created attachment 23125 [details]
the output excel file.
Created attachment 23126 [details]
error prompt by ms excel 2007
Created attachment 23127 [details]
error fixed by ms excel 2007
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! 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 Thanks for your reply! Now I use a xlsx file for testing, it produces the same error, please check the attachment file. Created attachment 23233 [details]
xlsx file for test
Created attachment 23234 [details]
excel error log
Created attachment 23235 [details]
the xlsx file for test
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 |