https://bugs.freedesktop.org/show_bug.cgi?id=78522
Priority: medium Bug ID: 78522 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: Macros: [REGRESSION] InsertByIndex works bad Severity: normal Classification: Unclassified OS: All Reporter: mcavaller...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs