Public bug reported:
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
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386
--
Calc: Insert row causes error in formula below insert that referred to row
above it
https://bugs.launchpad.net/bugs/654058
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
