← Back to team overview

desktop-packages team mailing list archive

[Bug 1315291] Re: libreoffice spreadsheet: insert rows above changes result below

 

Confirmed that bug is now fixed in Libreoffice-calc 1:4.2.7-0ubuntu2 [Version: 4.2.7.2 Build ID: 420m0(Build:2)] on Ubuntu 14.04 LTS x64.  
Many thanks.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1315291

Title:
  libreoffice spreadsheet: insert rows above changes result below

Status in libreoffice package in Ubuntu:
  Invalid

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/libreoffice/+bug/1315291/+subscriptions