Package: gnumeric Version: 1.12.48-1+b1 Severity: serious In certain circumstances, that I haven't yet identified precisely, a cell containing the SUM function applied to a range of values above it appears to be recalculated including its own previous value! This results in the sum increasing on every recalculation.
You should be able to see this in the attached sheet. A99 contains the formula =SUM(A1:A98) and is initially shown with a value of 4950. If you fill in the value 1 in A98, the sum changes to 9901. Ben. -- System Information: Debian Release: bullseye/sid APT prefers unstable-debug APT policy: (500, 'unstable-debug'), (500, 'stable-updates'), (500, 'unstable'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 5.9.0-2-amd64 (SMP w/2 CPU threads) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE not set 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.74 ii gnumeric-common 1.12.48-1 ii gsfonts 1:8.11+urwcyr1.0.7~pre44-4.4 ii libatk1.0-0 2.36.0-2 ii libc6 2.31-4 ii libcairo2 1.16.0-4 ii libgdk-pixbuf2.0-0 2.40.0+dfsg-5 ii libglib2.0-0 2.66.2-1 ii libgoffice-0.10-10 0.10.48-1 ii libgsf-1-114 1.14.47-1 ii libgtk-3-0 3.24.23-2 ii libpango-1.0-0 1.46.2-3 ii libpangocairo-1.0-0 1.46.2-3 ii libxml2 2.9.10+dfsg-6.2 ii procps 2:3.3.16-5 ii pxlib1 0.6.8-1+b1 ii zlib1g 1:1.2.11.dfsg-2 Versions of packages gnumeric recommends: ii evince 3.38.0-2 ii gnumeric-doc 1.12.48-1 ii lp-solve 5.5.2.5-2 Versions of packages gnumeric suggests: ii fonts-liberation 1:1.07.4-11 pn gnumeric-plugins-extra <none> pn libgsf-1-dev <none> -- debconf information: gnumeric/existing-process-title: gnumeric/existing-process: false
sum-bug.gnumeric
Description: application/gzip