undo does not recover formula of other after deleting lines

[Hugo Cid]

Binary package hint: openoffice.org

OpenOffice Calc bug:

When deleting first few lines affecting a column of data, dependent formulas are changed. It is OK.
Undoing this does not undo changes in the dependent formula if the dependent formula is in other sheet.

1) In sheet1 have a column of data. For example:

      A B
1
2 1
3 2
4 3
5 4
6 5
7 6
8
9 =SUM(B2:B6)

2) In any cell of sheet2 of same document let's have the formula:

=SUM(Sheet1.B2:B7)

3) Now, if we delete lines 2:5 in sheet1 we get:

Sheet1:
      A B
1
2 5
3 6
4
5 =SUM(B2:B3)

Sheet2:
=SUM(Sheet1.B2:B3)

So far so good.

4) Now, lets undo the deletion. It results:

Sheet1:
      A B
1
2 1
3 2
4 3
5 4
6 5
7 6
8
9 =SUM(B2:B6)
All normal here!

Sheet2:
=SUM(Sheet1.B6:B7) !!!!!ABNORMAL result of UNDO here. It does not recover initial formula range!!!!!

4) Observations: it just happens with the formula in the other sheet. It does not happen if we delete central or last lines. Only with deletion of the first n lines (or cells)

ProblemType: Bug
Architecture: i386
Date: Thu Jul 22 23:48:59 2010
DistroRelease: Ubuntu 9.10
InstallationMedia: Ubuntu-Netbook-Remix 9.10 "Karmic Koala" - Release i386 (20091028.4)
Package: openoffice.org-core 1:3.1.1-5ubuntu1.2
ProcEnviron:
 LANGUAGE=pt_PT.UTF-8
 PATH=(custom, no user)
 LANG=pt_PT.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-22.60-generic
SourcePackage: openoffice.org
Tags: ubuntu-unr
Uname: Linux 2.6.31-22-generic i686

[penalvch (penalvch)]

Hugo Cid, thank you for reporting this bug and making Ubuntu better. Could you please attach the file that you could reproduce this bug in?

[Launchpad Janitor (janitor)]

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

[penalvch (penalvch)]

Hugo Cid, this issue is unreproducible via Ubuntu 10.10, LibreOffice Calc via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/608961/+attachment/2080035/+files/example.ods && localc -nologo example.ods

In Sheet 1 highlight rows 2 through 5 -> click Edit -> Delete Cells -> Delete entire row(s) radio button -> OK button

Notice Sheet 2, Cell A1 has:

=SUM(Sheet1.B2:B3)

click Edit -> Undo and notice Sheet 2, Cell A1 has:

=SUM(Sheet1.B2:B7)

Does this work for you?

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

lsb_release -rd
Description: Ubuntu 10.10
Release: 10.10

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

[Hugo Cid (hcid)]

Thanks Timo,

I believe it is an OpenOffice bug.
I am still using 9.10 version, I just upgrade when necessary since my
pc's are in production.
Anyway, your procedure it works OK following your steps in OpenOffice.

BUT:
If you start in Sheet1 selecting rows 1:5 instead (from first row).
Then following all other steps:

a) delete rows 1:5;
b) check sheet2, OK. The formula in cell A1 remap the parameters
=SUM(Sheet1.B6:B7)
c) UNDO
d) result: sheet1 is back to normal but sheet2 cell A1 shows 11 and
formula IS =SUM(Sheet1.B6:B7) (should be the original
=SUM(Sheet1.B2:B7)).

I am using OpenOffice 3.1.1 . I used the exact file you have linked in
your mail.

Can you please test it the same way I did before I change to other
Office package?

Qui, 2011-04-21 às 17:17 +0000, Christopher M. Penalver escreveu:
> Hugo Cid, this issue is unreproducible via Ubuntu 10.10, LibreOffice
> Calc via the Terminal:
>
> cd ~/Desktop && wget
> https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/608961/+attachment/2080035/+files/example.ods
> && localc -nologo example.ods
>
> In Sheet 1 highlight rows 2 through 5 -> click Edit -> Delete Cells ->
> Delete entire row(s) radio button -> OK button
>
> Notice Sheet 2, Cell A1 has:
>
> =SUM(Sheet1.B2:B3)
>
> click Edit -> Undo and notice Sheet 2, Cell A1 has:
>
> =SUM(Sheet1.B2:B7)
>
> Does this work for you?
>
> sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update &&
> sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc
>
> lsb_release -rd
> Description: Ubuntu 10.10
> Release: 10.10
>
> apt-cache policy libreoffice-calc
> libreoffice-calc:
> Installed: 1:3.3.2-1ubuntu2~maverick1
> Candidate: 1:3.3.2-1ubuntu2~maverick1
> Version table:
> *** 1:3.3.2-1ubuntu2~maverick1 0
> 500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
> 100 /var/lib/dpkg/status
>
> ** Changed in: openoffice.org (Ubuntu)
> Status: Expired => Incomplete
>

[penalvch (penalvch)]

Hugo Cid, Ubuntu 9.10 reached EoL on April 2011.
Please see this document for currently supported Ubuntu releases:
https://wiki.ubuntu.com/Releases

I've tried recreating this bug with Ubuntu 10.10 and was unable to given the information you've provided. Please upgrade to a supported version of Ubuntu and if reproducible, reopen this bug report by clicking on the current status, under the Status column, and change the Status back to "New". Thanks!

[Launchpad Janitor (janitor)]

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