This is happening to me as well. The shiftRows function is not working
properly. The row # seems to update properly but the cells within the row
do not have the same row # as the row they reside in so the rows get
corrupted.
In the example below I inserted 1 row (+1) - notice the row go updated but
not the cells within the row (A29 instead of A30).
<row r="30" spans="1:17" ht="16.5" customHeight="1"
x14ac:dyDescent="0.2">
<c r="A29" s="1" t="s">
<v>4</v>
</c><c r="B29" s="1" t="s">
<v>5</v>
</c>
</row>
For me this makes POI 4.0 unusable for my purposes. I'll see if I can come
up with a temp workaround to use 3.x methods for this function but ideally
maybe 4.0.2 can address properly.
--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
