Calc: Insert row causes error in formula below insert that referred to row above it

[markling]

Binary package hint: openoffice.org

Inserting a row causes mistaken alteration of formulas in cells belonging to rows immediately below the insert that referred to cells above it.

E.g. In the attached example spreadsheet: "test 4.ods"

It has two columns: A (Money in) and B (Running total).
A is just a number
B is a formula that adds the amount in A to the previous total.

To repeat generate the error, do the following:

Choose a row anywhere after the first in the table, above which a new row will be inserted. So e.g. choose Row 5. The formula in Cell B5 is SUM(B4+A5). Now insert a row above Row 5.

What has happened:

What was B5 is now B6. The formulas in all the cells below the newly inserted Row 5 have been altered automatically to correspond with their new position. But the formula in the row immediately following the inserted row is incorrect. The formula in Cell B6 is now SUM(B4+A6). It should be SUM(B5+A6).

The formulas in all the cells below Row 6 have all been altered correctly. E.g. The Cell that was B6 before it got shunted down by the row insert used to have the formula SUM(B5+A6). After the insert it is located at B7. Its formula has changed correctly to SUM(B6+A7).

The erroneous formula in B6 will change back to the correct form if the inserted Row 5 is deleted. B6 is B5 again. It's formula is, correctly, SUM(B4+A5).

ProblemType: Bug
Architecture: i386
Date: Sun Oct 3 13:04:26 2010
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
Package: openoffice.org-core 1:3.1.1-5ubuntu1.2
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-22.65-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-22-generic i686
XsessionErrors:
 (gnome-settings-daemon:1743): GLib-CRITICAL **: g_propagate_error: assertion `src != NULL' failed
 (nautilus:1843): Eel-CRITICAL **: eel_preferences_get_boolean: assertion `preferences_is_initialized ()' failed
 (polkit-gnome-authentication-agent-1:1865): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed
 (nautilus:3492): Eel-CRITICAL **: eel_preferences_get_boolean: assertion `preferences_is_initialized ()' failed

[penalvch (penalvch)]

markling, thank you for reporting this bug and making Ubuntu better. In Ubuntu 10.10, libreoffice-calc performed via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/654058/+attachment/1669046/+files/test%204.ods && soffice -calc test%204.ods

It is noticed how if one inserts a blank row into row 5, the equation of B6 becomes =SUM(B4+A6) One way to get what your looking for is if after inserting the blank row into row 5, highlight cells B4 through B6, click Edit -> Fill -> Down.

Does this work for you?

lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.0-1maverick1
  Candidate: 1:3.3.0-1maverick1
  Version table:
 *** 1:3.3.0-1maverick1 0
        500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
        100 /var/lib/dpkg/status

[Launchpad Janitor (janitor)]

[Expired for openoffice.org (Ubuntu) because there has been no activity for 60 days.]