Libreoffice 4.0.0 beta 2 / SUMIFS()

Hi there,

Anyone tried LO 4.0? The current development version is 4.0.0 beta 2 from Download QA builds

I’m interested on feedback on the SUMIFS function (not the SUMIF), if it is already implemented and works OK. I’ve been receiving a lot of spreadsheets at work where this function is used (although most time it isn’t necessary), and have to resort to the excel viewer from m$ in a VM, which is very limited.


Also, does it mess a stable LO install? I’m using oS 11.4/KDE 4.8 and 12.1 64-bit / KDE 4.9.


I tested in oS 12.1 64-bit, the downloaded files where:

LibO-Dev_4.0.0.0.beta2_Linux_x86-64_install-rpm_en-US.tar.gz (libreoffice english version)
LibO-Dev_4.0.0.0.beta2_Linux_x86-64_helppack-rpm_pt-BR.tar.gz (optional, help pack)
LibO-Dev_4.0.0.0.beta2_Linux_x86-64_langpack-rpm_pt-BR.tar.gz (optional, language pack)

It installs in /opt/lodev4.0/, while the stable LO is in /usr/bin and /usr/lib64/libreoffice/, so no conflicts here apparently.

Well, the readme instructions resort to extract the RPMs and install with rpm -Uvh *.rpm for each tarball, but I found it easier for posterior management (removal) to dump all RPMs (except the non-suse integration RPMs) in one directory, add this directory as a RPM source in Yast Repository Management and install from there with Yast Software Management.

To start it I have to run /opt/lodev4.0/program/soffice or change to the …/program/ directory and run ./soffice from a terminal (or make a shortcut, evidently). If I run soffice only, even if I’m in the …/program/ directory, it will bring up the stable version, since it’s what is in the executable path.

And yes, the SUMIFS() function is implemented there, which was the point of this exercise.

Just reporting here in case it helps someone.