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 2015/04/30 11:11:47 UTC

[Bug 57423] shiftRows() produces a corrupted xlsx file

https://bz.apache.org/bugzilla/show_bug.cgi?id=57423

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
I verified that Excel complains about such a sheet. Analysis indicates that the
cause is that we do not fix the order of rows in the data structure
XSSFSheet->worksheet->sheetdata, which holds an array of rows. 

The shifting currently leaves this array unordered, which seems to be fine for
LibreOffice/OpenOffice, but causes Excel to complain.

Unfortunately fixing seems to be a bit harder as the XmlBeans interfaces does
not easily allow to change array contents without actually cloning the whole
object, let's see if there is a way to do it correctly.

-- 
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