← Back to team overview

desktop-packages team mailing list archive

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

 

SatPhil, this is not reproducible in Trusty.

lsb_release -rd
Description:	Ubuntu 14.04.1 LTS
Release:	14.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:4.2.7-0ubuntu2
  Candidate: 1:4.2.7-0ubuntu2
  Version table:
 *** 1:4.2.7-0ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main amd64 Packages
        100 /var/lib/dpkg/status
     1:4.2.7-0ubuntu1 0
        500 http://security.ubuntu.com/ubuntu/ trusty-security/main amd64 Packages
     1:4.2.3~rc3-0ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages

** Changed in: libreoffice (Ubuntu)
       Status: New => Invalid

-- 
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