Package: gnumeric Version: 1.12.45-1+b1 Severity: important I just reported this bug on Gnome's bug tracker at https://gitlab.gnome.org/GNOME/gnumeric/issues/423
This Debian bug is filed for reference purposes. ================ In sumif, the condition for an empty cell always returns false. In the attached file the formulas in cells E3 and F3 should produce 1, but both produce 0 instead, which is wrong. The same formulas produce the correct result when the file is read in Libreoffice 6.3.2 on Debian and in Gnumeric 1.10.17 on Ubuntu -- System Information: Debian Release: bullseye/sid APT prefers testing APT policy: (990, 'testing'), (101, 'unstable') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 5.2.0-3-amd64 (SMP w/4 CPU cores) Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=en_US.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8), LANGUAGE=C:en_GB:en:en_US:it:fr:es (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages gnumeric depends on: ii debconf [debconf-2.0] 1.5.73 ii gnumeric-common 1.12.45-1 ii gsfonts 1:8.11+urwcyr1.0.7~pre44-4.4 ii libatk1.0-0 2.34.1-1 ii libc6 2.29-2 ii libcairo2 1.16.0-4 ii libgdk-pixbuf2.0-0 2.40.0+dfsg-1 ii libglib2.0-0 2.62.2-1 ii libgoffice-0.10-10 0.10.45-1 ii libgsf-1-114 1.14.46-1 ii libgtk-3-0 3.24.12-1 ii libpango-1.0-0 1.42.4-7 ii libpangocairo-1.0-0 1.42.4-7 ii libxml2 2.9.4+dfsg1-7+b3 ii procps 2:3.3.15-2+b1 ii pxlib1 0.6.7-1+b1 ii zlib1g 1:1.2.11.dfsg-1+b1 Versions of packages gnumeric recommends: ii evince 3.34.1-1 ii gnumeric-doc 1.12.45-1 ii lp-solve 5.5.0.15-4+b1 Versions of packages gnumeric suggests: ii fonts-liberation 1:1.07.4-10 ii gnumeric-plugins-extra 1.12.45-1+b1 pn libgsf-1-dev <none> ii ttf-mscorefonts-installer 3.7 -- debconf information: * gnumeric/existing-process: true gnumeric/existing-process-title:
bug.gnumeric
Description: ~/bug.gnumeric
