You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/01/15 08:34:21 UTC

DO NOT REPLY [Bug 46536] New: XSSFSheet.shiftRows(...) is not working

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: dev@poi.apache.org
        ReportedBy: matthew.knl@gmail.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #3 from Matthew <ma...@gmail.com>  2009-01-14 23:35:35 PST ---
Created an attachment (id=23126)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23126)
error prompt by ms excel 2007


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #7 from Matthew <ma...@gmail.com>  2009-02-05 21:56:26 PST ---
Thanks for your reply!
Now I use a xlsx file for testing, it produces the same error, please check the
attachment file.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #1 from Matthew <ma...@gmail.com>  2009-01-14 23:34:43 PST ---
Created an attachment (id=23124)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23124)
the source excel file.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536


Matthew <ma...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #23235|0                           |1
        is obsolete|                            |




-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #6 from David Fisher <df...@jmlafferty.com>  2009-02-05 09:04:40 PST ---
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


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #8 from Matthew <ma...@gmail.com>  2009-02-05 21:58:14 PST ---
Created an attachment (id=23233)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23233)
xlsx file for test


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #4 from Matthew <ma...@gmail.com>  2009-01-14 23:35:50 PST ---
Created an attachment (id=23127)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23127)
error fixed by ms excel 2007


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536


Matthew <ma...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|major                       |critical




--- Comment #5 from Matthew <ma...@gmail.com>  2009-02-05 00:01:02 PST ---
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!


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536


Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #11 from Yegor Kozlov <ye...@dinom.ru>  2009-02-08 08:40:02 PST ---
Fixed in r742126 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=742126 )
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


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #10 from Matthew <ma...@gmail.com>  2009-02-05 22:07:09 PST ---
Created an attachment (id=23235)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23235)
the xlsx file for test


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #9 from Matthew <ma...@gmail.com>  2009-02-05 22:00:27 PST ---
Created an attachment (id=23234)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23234)
excel error log


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46536] XSSFSheet.shiftRows(...) is not working

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46536





--- Comment #2 from Matthew <ma...@gmail.com>  2009-01-14 23:35:15 PST ---
Created an attachment (id=23125)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23125)
the output excel file.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org