Related with https://bugs.documentfoundation.org/show_bug.cgi?id=64229
I'm using Calc Libreoffice Version: 220.127.116.11.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:
What I expect?
To get a "20" value
What I get?
-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:
I can confirm with Version: 18.104.22.168.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: 22.214.171.124.alpha1+ Build ID: 233b9b0ec95069b5ce98aab942304459ca7344a8, win7
and Version: 126.96.36.199.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.
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_188.8.131.52.alpha1_Linux_x86-64_deb.tar.gz
tar xvfz master~2015-11-17_00.57.30_LibreOfficeDev_184.108.40.206.alpha1_Linux_x86-64_deb.tar.gzcd LibreOfficeDev_220.127.116.11.alpha1_Linux_x86-64_deb/DEBS/
sudo dpkg -i *.deb
3. Then I launched Libreoffice:
Which displays below version number:
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]
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
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 18.104.22.168.
I wonder what would happen if we use , instead of PopMatrix , PopExternalDoubleRef
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: