Related with https://bugs.documentfoundation.org/show_bug.cgi?id=64229 Hi there. I'm using Calc Libreoffice Version: 5.0.1.2.0+ Build ID: 00m0(Build:2). Steps to reproduce: 1. Create /tmp/a.ods with below data: year month amount 2015 1 10 2015 1 20 2015 2 5 2. Create /tmp/b.ods with below function: =SUMIFS('file:///tmp/a.ods'#$Sheet1.C2:C4,'file:///tmp/a.ods'#$Sheet1.B2:B4,1,'file:///tmp/a.ods'#$Sheet1.A2:A4,2015) What I expect? To get a "20" value What I get? Err:504 Tips: -If I use the function assistant after fill the 1st parameter, I get Err:511 -If you use below function in "/tmp/a.ods" it works: =SUMIFS(C2:C4,B2:B4,1,A2:A4,2015)
I can confirm with Version: 5.1.0.0.alpha1+ Build ID: a60db559d409514fb93af0167c543ad2f852b499 TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-16_01:09:20
Seems to be fixed in dev version, I can not reproduce with Version: 5.1.0.0.alpha1+ Build ID: 233b9b0ec95069b5ce98aab942304459ca7344a8, win7 and Version: 5.1.0.0.alpha1+ Build ID: 51df957e1a40d2f3511345c1600c05dd35f34b6b TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-10-19_04:22:32 Please could you test with dev version? You can download it here: http://dev-builds.libreoffice.org/daily/master/
Many thanks for your time. I will try it as soon as possible, but I don't think it will happen till next Monday. Cheers.
Hello Javier, please could you test it? To be sure the bug can be closed. Thank you!
Hi there, still same issue. Steps I followed: 1. Remove stable Libreoffice installation sudo apt-get remove --purge libreoffice-common 2. I installed suggested dev version of Libreoffice: wget -c --tries=0 http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86_64@70-TDF/current/master~2015-11-17_00.57.30_LibreOfficeDev_5.1.0.0.alpha1_Linux_x86-64_deb.tar.gz tar xvfz master~2015-11-17_00.57.30_LibreOfficeDev_5.1.0.0.alpha1_Linux_x86-64_deb.tar.gzcd LibreOfficeDev_5.1.0.0.alpha1_Linux_x86-64_deb/DEBS/ sudo dpkg -i *.deb 3. Then I launched Libreoffice: libreofficedev5.1 Which displays below version number: Version: 5.1.0.0.alpha1+ Build ID: 32d4c03cba399ada807b8ec113a3928aa9e3ff7b TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-11-17_00:57:30 Locale: en-US (en_US.UTF-8) 4. Then I repeated exactly the same steps outlined in my report, and I got identical result
Just in cas is relevant I realize that I was missing JRE: javaldx: Could not find a Java Runtime Environment! Warning: failed to read path from javaldx Then I installed it: sudo apt-get install default-jre Then I re-open the file (b.ods) but same issue. Do you think I should re-install Libreoffice dev again?
I uninsalled and re-installed dev version and same issue
Created attachment 120666 [details] test case Sorry, I've accidentaly tested with test case from bug 64229. Bug is still valid.
Raal, it's ok, many many thanks for your time and great job
The bug is present in the nevest LO5.2.1 version too. (I have tried the Portable version only.) The function SUMIFS() will not work with a reference to an another file. The function results in error code 504. The AOO 4.1.2 can work in this case. Tried with versions LO4.4.7, portable LO5.2.1 Locale: Hungary Op. Sys: Win 7 prof 64 bit.
(In reply to Tibor Kovács from comment #10) > The bug is present in the newest LO5.2.1 version too. (I have tried the > Portable version only.) > The function SUMIFS() will not work with a reference to an another file. > The function results in error code 504. > The AOO 4.1.2 can work in this case. > > Tried with versions LO4.4.7, portable LO5.2.1 > Locale: Hungary > Op. Sys: Win 7 prof 64 bit.
Present in LO 5.3.6.1.
I wonder what would happen if we use , instead of PopMatrix , PopExternalDoubleRef in ScInterpreter::IterateParametersIfs https://github.com/LibreOffice/core/blob/7a761c0ae392ed122cee689adc5a006996539dc0/sc/source/core/tool/interpr1.cxx#L5800 https://github.com/LibreOffice/core/blob/95645cbf0a220c338600130bdeca49743b252972/sc/source/core/tool/interpr6.cxx#L967
oh sorry, when I took a look at commit log in bug 64229, the fix before this regression was already there. so it seems I ended up in making needless comment.
*** This bug has been marked as a duplicate of bug 115162 ***
It seems that solution from is not working: https://gerrit.libreoffice.org/#/c/49264/1