https://bugs.freedesktop.org/show_bug.cgi?id=77080
--- Comment #7 from Nancy <[email protected]> --- This may be the same bug I just found. I have a spreadsheet with some cells containing sums of other cells. If I insert new rows above the sum range, the sum range is not adjusted correctly. The end of the range is correctly increased by the number of rows added, but the beginning of the range stays at the original value. The effect is that the formula now sums too many rows. I insert the rows by selecting several rows, then using Insert > Rows in the menu. The number of rows inserted does not seem to matter. If rows are deleted instead, both the start and end of the sum range are adjusted correctly. I found this in 4.2.3.3. I upgraded to 4.2.4.2, hoping that it had been fixed, but it's still there. I am using Windows 7. I tested this with version 4.0.1.2 on my old XP computer, and it does NOT have this bug. As I write this, I've done a little more playing around, and this seems to happen only if the rows I have selected in order to do the insert overlap the sum range. Example: Cell E14 contains =SUM(E4:E13) I want to add 7 rows after row 1, so I select rows 2-8 and then choose Insert > Rows in the menu. 7 rows are added; cell E14 is now E21 and contains =SUM(E4:E20) It should contain =SUM(E11:E20), since the rows I added are outside the sum range. -- 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
