[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Michael Stahl changed: What|Removed |Added Attachment #99358|application/octet-stream|application/zip mime type|| -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 ign_christian changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |WORKSFORME --- Comment #17 from ign_christian --- Mariano, you can only reopen a bug if you can reproduce with same or higher version...not with older.. And don't forget to reset user profile to make sure its freshness. 4.2.5 has arrived for Windows: http://www.libreoffice.org/download/libreoffice-stable/?type=win-x86&version=4.2.5&lang=en-US *) Anyway, curently LO has no 64bit version for Windows -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Mariano Nemec changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- Ever confirmed|0 |1 --- Comment #16 from Mariano Nemec --- (In reply to comment #15) > (In reply to comment #3) > > Created attachment 97656 [details] > > spreadsheet & screenshots, before & after inserting rows > > > > load the spreadsheet and look at the screenshots to test the bug > > Following the test case, I can't reproduce under LO 4.2.5.2 - Ubuntu 12.04 > x86. Perhaps related to Bug 77647 fixing. > > Please REOPENED if anyone can reproduce in latest stable release Christian, maybe this bug was fixed under your "LO 4.2.5.2 - Ubuntu 12.04 x86". But I confirm that this bug still exists in the test ods file, opened with my LO 4.2.4.2 (Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8), which is the latest stable release in my Windows7 64-bit SP1 Operating system. -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 ign_christian changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #15 from ign_christian --- (In reply to comment #3) > Created attachment 97656 [details] > spreadsheet & screenshots, before & after inserting rows > > load the spreadsheet and look at the screenshots to test the bug Following the test case, I can't reproduce under LO 4.2.5.2 - Ubuntu 12.04 x86. Perhaps related to Bug 77647 fixing. Please REOPENED if anyone can reproduce in latest stable 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 ign_christian changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=77647 --- Comment #14 from ign_christian --- As Nancy said, perhaps duplicate to Bug 77647 -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 ign_christian changed: What|Removed |Added OS|Linux (All) |All --- Comment #13 from ign_christian --- I think we need expert opinion here. -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 ign_christian changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED CC||ign_christ...@yahoo.com Version|unspecified |4.2.2.1 release Ever confirmed|1 |0 --- Comment #12 from ign_christian --- Seems that enough informations provided, set UNCONFIRMED -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #11 from Mariano Nemec --- FURTHER COMMENTS: When this bug happens in a large spreadsheet, it causes the program to crash. When the crashed file is restored authomatically at the next start, in all the cells where there were functions, these are substituted by numbers!! This unaspected modification is "invisible": it happens without any warning from the program. On the contrary, using MS Office to open the restored ods file, a warning of defective file is given, and the "modified" cells are highlighted as errors. Now I'm back to using "Apache OpenOffice" vers. 4.1.0, as it does not have this very dangerous bug. -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Mariano Nemec changed: What|Removed |Added Hardware|Other |All -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #10 from Giuseppe Vizziello --- Comment on attachment 99358 --> https://bugs.freedesktop.org/attachment.cgi?id=99358 Workflow video insertion/deletion rows LO vers. 4.2.4.2 Using the command "insert rows above", after Selecting a row with a cell containing a reference to a range, the range is altered. Unexpected results, operating on the same Resulting range, even with the use of "Delete selected rows". The same thing happens with any command that uses the range. -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #9 from Giuseppe Vizziello --- Created attachment 99358 --> https://bugs.freedesktop.org/attachment.cgi?id=99358&action=edit Workflow video insertion/deletion rows -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Nancy changed: What|Removed |Added CC||bugzi...@gyphills.com --- Comment #8 from Nancy --- I've looked at Steffen's attachments now, and am pretty sure it is the same bug. Looking further at the bug lists, #77647 seems to be the same thing, and is listed as fixed in 4.2.5.0. That appears to be scheduled for release in June. I can probably work around the bug until then (just use multiple, smaller inserts that don't overlap the sum range). -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #7 from Nancy --- 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Mariano Nemec changed: What|Removed |Added Version|4.2.2.1 release |unspecified -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #6 from Mariano Nemec --- edit; unistalling 4.2.2.1 -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 --- Comment #5 from Mariano Nemec --- edit; unistalling 4.2.2.1 -- 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
[Libreoffice-bugs] [Bug 77080] SUM result is changed when inserting empty rows
https://bugs.freedesktop.org/show_bug.cgi?id=77080 Mariano Nemec changed: What|Removed |Added Summary|Area of summation (and of |SUM result is changed when |other formula) is changed |inserting empty rows |in wrong manner when| |inserting rows | -- 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