Bug#749847: libreoffice-calc: Chained Calculations aren't updated correctly after deleting a Row or Column
Package: libreoffice-calc
Version: 1:4.2.4-3
Severity: important
Dear Maintainer,
Steps to reproduce that work for me.
Opening a new Spreadsheet.
Entering:
A1: 1
A2: 2
A3: 3
A4: =SUM(A1:A3)
A5: =A4
I see:
1
2
3
6
6
Then i click on Row 2 and select "Delete Selected Row" from the context-menu
I see:
1
3
4
6
The last 6 is wrong and should also be 4.
The same happens when fill in the number/formulas horizontally and delete a column.
Bonus:
'Undo'ing the Row-Delete and then 'Redo'ing it (Ctrl-Z, Ctrl-Y)
i see what i would expect:
1
3
4
4
-- System Information:
Debian Release: jessie/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (x86_64)
Foreign Architectures: amd64
Kernel: Linux 3.14.0 (SMP w/8 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages libreoffice-calc depends on:
ii libc6 2.18-7
ii libgcc1 1:4.9.0-5
ii libicu52 52.1-3
ii liborcus-0.6-0 0.5.1-8+b1
ii libreoffice-base-core 1:4.2.4-3
ii libreoffice-core 1:4.2.4-3
ii libstdc++6 4.9.0-5
ii libxml2 2.9.1+dfsg1-3
ii lp-solve 5.5.0.13-7+b1
ii uno-libs3 4.2.4-3
ii ure 4.2.4-3
ii zlib1g 1:1.2.8.dfsg-1
libreoffice-calc recommends no packages.
Versions of packages libreoffice-calc suggests:
pn ocl-icd-libopencl1 <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.11.0-5
ii fonts-opensymbol 2:102.6+LibO4.2.4-3
ii libatk1.0-0 2.12.0-1
ii libboost-date-time1.54.0 1.54.0-5
ii libc6 2.18-7
ii libcairo2 1.12.16-2
ii libclucene-contribs1 2.3.3.4-4
ii libclucene-core1 2.3.3.4-4
ii libcmis-0.4-4 0.4.1-7
ii libcups2 1.7.2-3
ii libcurl3-gnutls 7.37.0-1
ii libdbus-1-3 1.8.2-1
ii libdbus-glib-1-2 0.102-1
ii libeot0 0.01-2
ii libexpat1 2.1.0-5
ii libexttextcat-2.0-0 3.4.3-1
ii libfontconfig1 2.11.0-5
ii libfreetype6 2.5.2-1
ii libgcc1 1:4.9.0-5
ii libgdk-pixbuf2.0-0 2.30.7-1
ii libgl1-mesa-glx [libgl1] 10.1.4-1
ii libglib2.0-0 2.40.0-3
ii libglu1-mesa [libglu1] 9.0.0-2
ii libgraphite2-3 1.2.4-2
ii libgtk2.0-0 2.24.23-1
ii libharfbuzz-icu0 0.9.28-2
ii libharfbuzz0b 0.9.28-2
ii libhunspell-1.3-0 1.3.2-7
ii libhyphen0 2.8.6-3
ii libice6 2:1.0.8-2
ii libicu52 52.1-3
ii libjpeg8 8d-2
ii liblangtag1 0.5.1-2
ii liblcms2-2 2.6-1
ii libldap-2.4-2 2.4.39-1
ii libmythes-1.2-0 2:1.2.2-1
ii libneon27-gnutls 0.30.0-2
ii libnspr4 2:4.10.4-1
ii libnspr4-0d 2:4.10.4-1
ii libnss3 2:3.16-1
ii libnss3-1d 2:3.16-1
ii libpango-1.0-0 1.36.3-1
ii libpangocairo-1.0-0 1.36.3-1
ii libpangoft2-1.0-0 1.36.3-1
ii libpng12-0 1.2.50-1
ii librdf0 1.0.17-1+b1
ii libreoffice-common 1:4.2.4-3
ii libsm6 2:1.2.1-2
ii libssl1.0.0 1.0.1g-4
ii libstdc++6 4.9.0-5
ii libx11-6 2:1.6.2-2
ii libxext6 2:1.3.2-1
ii libxinerama1 2:1.1.3-1
ii libxml2 2.9.1+dfsg1-3
ii libxrandr2 2:1.4.2-1
ii libxrender1 1:0.9.8-1
ii libxslt1.1 1.1.28-2
ii libxt6 1:1.1.4-1
ii uno-libs3 4.2.4-3
ii ure 4.2.4-3
ii zlib1g 1:1.2.8.dfsg-1
-- no debconf information
Reply to: