Created attachment 112614 [details] error logfile generated fron JRE on LO crash How to produce the error 1. Edit function SUMIF, where sum range and range x refer to an other LO spreadsheet. 2. LO crashes after you posted the formula or, if you use the function wizard, after you entered the external reference for range 1 3. JRE generates an error logfile (see attach) Current behavior: as described above Expected behavior: SUMIFS should calculate the value or give an error. Additional Information: 1. I tried comparing the behavior of SUMIFS (with only one range) and SUMIF. While SUMIF give a value back (the correct one), SUMIFS causes the crash.
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: 60143f4f7bc50054dcef923218b8c7c3bc154933 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-21_04:58:34 Program received signal SIGSEGV, Segmentation fault. 0x00007fffaf5580e0 in ScMatrix::GetDimensions(unsigned long&, unsigned long&) const () from /opt/libreofficedev4.5/program/../program/libsclo.so (gdb)
Created attachment 112619 [details] gdbtrace
Not a regression as such, but a bug which has existed since SUMIFS was first implemented in the below commit commit f2cb873631b8b21b54a55beaba532f4bd616a9c6 Author: Marina Plakalovic <makkica@openoffice.org> AuthorDate: Fri Dec 14 23:40:18 2012 +0100 Commit: Eike Rathke <erack@redhat.com> CommitDate: Sat Dec 15 21:42:39 2012 +0100 calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, COUNTIFS Merged from Apache OO with adaptions. http://svn.apache.org/viewvc?rev=1381447&view=rev Original Apache OO committer: Andrew Rist <arist@apache.org> Original Author: Marina Plakalovic <makkica@openoffice.org> Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>
Created attachment 114484 [details] Sample ODS
Specific reproduction instructions: - Open attachment 114484 [details] - Create a second, blank spreadsheet and save it - Select cell A5 of the sample (attachment 114484 [details]) and open the function wizard (the "fx" button) - Click the select range button for "sum_range" - Click on A1 in the blank spreadsheet, and press return
Taking.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3cae8ee10f297e42adf9f3b33809b4e7e3af2840 Resolves: tdf#88672 add missing return if error to not crash It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/15111 for 4-4 https://gerrit.libreoffice.org/15112 for 4-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c9812dc14828b3c8d48f5b765d1798c7cf3a5099&h=libreoffice-4-4 Resolves: tdf#88672 add missing return if error to not crash It will be available in 4.4.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=035764904eed82610e30ae557e568bb3c04286bf&h=libreoffice-4-3 Resolves: tdf#88672 add missing return if error to not crash It will be available in 4.3.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.