https://issues.apache.org/bugzilla/show_bug.cgi?id=57423
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: gillb...@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
testing.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
