Re: [Bug 62711] New: Calling shiftRows corrupts file in POI 4.0

[Tony Falabella <to...@hotmail.com>]

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