Created attachment 99271 [details]
the attached spreadsheet demonstrates the bug, pls run the script BugDemo
Since several years I am using a LibreOfficeBasic - script to manage my stock account.
After the installation of XUBUNTU 14.04 (LibreOffice 4.2.3 – rc3 – 0ubuntu2) there was a malfunction. It persists when I changed to LibreOffice 188.8.131.52 from the LibreOffice-Homepage.
The bug occurs in connection with the methods
Given a spreadsheet table with blocks of rows containing the same numbers of rows and the sum-function for each column of the block in the last rows of a block. If you want to insert free space on top of the table in order to insert a new block using one of the above mentioned methods the blocks will be moved down and the cell addresses in the sum-function should be changed accordingly.
That is true for the second and all following blocks but not for the first one. The start address of this sum-function is not affected by the movement of the block.
Hi Fritz, thanks for reporting.
It seems working fine with:
Version: 184.108.40.206.beta1 Build ID: 2e39c7e59c8fc8b16a54c3d981dceef27fb0c07f
I can't verify with:
Version: 220.127.116.11.0+Build ID: 585077d4f681582386baa10acff53abdd280552b
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-25_19:53:59
because I can find a bug in it, that crash in Menu/Tools/Macros/Run Macro
Issues in relation with insert rows have been solved in this bug:
Please if you are not agree, or you can reproduce in version 4.2.5 or higher, reopen it.
*** This bug has been marked as a duplicate of bug 77647 ***