Public bug reported:
Running libreoffice-calc 1:4.2.3~rc3-0ubuntu2 on Ubuntu 14.04 LTS x64.
I have a simple formula, A5 =A2-SUM(A3:A4)
- Click on row 2, right click -> insert rows above; A6 (was A5) stays correct.
Undo.
- Click on row 3, right click -> insert rows above; A6 (was A5) stays correct.
Undo.
- Click on rows 2 and 3, right click -> insert rows above; A7 (was A5) now
changes and is incorrect!
It is now =A4-SUM(A3:A6) instead of =A4-SUM(A5:A6)
I expected adding 2 rows above would not change the formula below.
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Attachment added: "test case for insert rows above changes result below"
https://bugs.launchpad.net/bugs/1315291/+attachment/4103036/+files/test%20case%20insert%20rows%20above.ods
** Description changed:
Running libreoffice-calc 1:4.2.3~rc3-0ubuntu2 on Ubuntu 14.04 LTS x64.
I have a simple formula, A5 =A2-SUM(A3:A4)
- - Click on row 2, right click -> insert rows above; A6 (was A5) stays correct
- - Click on row 3, right click -> insert rows above; A6 (was A5) stays
correct.
- - Click on rows 2 and 3, right click -> insert rows above; A7 (was A5) now
changes and is incorrect!
+ - Click on row 2, right click -> insert rows above; A6 (was A5) stays
correct. Undo.
+ - Click on row 3, right click -> insert rows above; A6 (was A5) stays
correct. Undo.
+ - Click on rows 2 and 3, right click -> insert rows above; A7 (was A5) now
changes and is incorrect!
It is now =A4-SUM(A3:A6) instead of =A4-SUM(A5:A6)
I expected adding 2 rows above would not change the formula below.
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to openoffice.org in Ubuntu.
https://bugs.launchpad.net/bugs/1315291
Title:
libreoffice spreadsheet: insert rows above changes result below
Status in “openoffice.org” package in Ubuntu:
New
Bug description:
Running libreoffice-calc 1:4.2.3~rc3-0ubuntu2 on Ubuntu 14.04 LTS x64.
I have a simple formula, A5 =A2-SUM(A3:A4)
- Click on row 2, right click -> insert rows above; A6 (was A5) stays
correct. Undo.
- Click on row 3, right click -> insert rows above; A6 (was A5) stays
correct. Undo.
- Click on rows 2 and 3, right click -> insert rows above; A7 (was A5) now
changes and is incorrect!
It is now =A4-SUM(A3:A6) instead of =A4-SUM(A5:A6)
I expected adding 2 rows above would not change the formula below.
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/1315291/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
