Created attachment 98809 [details]
InsertByIndex comparison LO 4.1 - 4.2, before and after
Something works bad with "InsertByIndex", you can see the range is altered when the number of row to insert is equal or greater than 2.
Look at the image for a comparison between LO 4.1.x and LO 4.2
Here is the macro code where the issue is located:
oSheet = ThisComponent.currentController.activeSheet
Try the attached .ods test file:
- there is the formula =SUM(A9:C9)
- use InsertByIndex macro instruction to insert rows above existing ones and you will get an alteration of the range used by =SUM()
- same issue happens using =PRODUCT() and generally operations working on cells range.
Range is changed when when the number of row to insert is equal or greater than 2.
InsertByIndex should work well with no range alteration, like in LO 4.1.x
Operating System: All
Version: 184.108.40.206 release
Last worked in: 220.127.116.11 release
Created attachment 98810 [details]
Test file .ods for InsertByIndex bug
On pc Debian x86-64 with master sources updated today or with 4.2 updated yesterday, I don't reproduce this.
2 rows are inserted above the current row.
I tried LO 4.2.5 pre-release and this issue is no more.
Whatever was my bug, it's gone.
Migrating Whiteboard tags to Keywords: (possibleRegression)