poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57423] New: shiftRows() produces a corrupted xlsx file
Date Wed, 07 Jan 2015 15:35:34 GMT

            Bug ID: 57423
           Summary: shiftRows() produces a corrupted xlsx file
           Product: POI
           Version: 3.11-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: gillbuzz@10g.pl

Created attachment 32353
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32353&action=edit
java test code

XSSF implementation of Sheet.shiftRows() causes corrupted output xlsx file when
the shift value is bigger than the number of row(s) being shifted. This is
regardless of whether the shift value is negative or positive.

Excel 2010 on opening the output file says:
"Excel found unreadable content" and offers recovering the file by removing the
unreadable content.

This can be observed in examples like the following:
negative shift of 1 row by less than -1
negative shift of 2 rows by less than -2
positive shift of 1 row by 2 or more 
positive shift of 2 rows by 3 or more

Please find java test code attached along with xlsx template file used for

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