https://bugs.freedesktop.org/show_bug.cgi?id=78522
Priority: medium
Bug ID: 78522
Assignee: [email protected]
Summary: Macros: [REGRESSION] InsertByIndex works bad
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: BASIC
Product: LibreOffice
Created attachment 98809
--> https://bugs.freedesktop.org/attachment.cgi?id=98809&action=edit
InsertByIndex comparison LO 4.1 - 4.2, before and after
Problem description:
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:
sub bug
oSheet = ThisComponent.currentController.activeSheet
oCell=thisComponent.getCurrentSelection()
lrow=oCell.RangeAddress.StartRow
oSheet.getRows.insertByIndex(lrow, 2)
end sub
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.
Current behavior:
Range is changed when when the number of row to insert is equal or greater than
2.
Expected behavior:
InsertByIndex should work well with no range alteration, like in LO 4.1.x
Operating System: All
Version: 4.2.3.3 release
Last worked in: 4.1.6.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
