[upstream] OO spreadsheet copies changes from one sheet to another

[Cliff Kachinske]

Binary package hint: openoffice.org-calc

I have a spread sheet, saved in .xls format.

The spread sheet contains two sheets.

Changes made to cells on one sheet appear on the other sheet.

I can email the spread sheet if it helps find this bug.

<email address hidden>

[Cliff Kachinske (cjkske-gmail)]

Forgot to say, running Gutsy, up to date as of 2008 01 23.

Created this sheet in OO.calc and saved as xls for compatibility with the misguided.

[Chris Cheney (ccheney)]

Do you happen to have this sheet in ods format or was it saved out as xls initially?

Thanks,

Chris Cheney

[Chris Cheney (ccheney)]

Confirmed the problem on upstream's openoffice.org 2.4.0~rc2

[Derek Abson (dsabson)]

In attachment ods file, sheet Results has been copied to end position as Results 2. The function references are copied incorrectly and refer to the wrong sheets. Compare Sheets Results and Results 2. Delete Results 2 and copy Result again again to end position. The errors are consistent. I generated a new sheet and copied Result using this empty sheet as a reference point, but the error was still the same.

[penalvch (penalvch)]

Cliff Kachinske, this was unreproducible in LibreOffice Calc. Does this work for you? If your using Lucid or Maverick feel free to type at a Terminal:

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

[Cliff Kachinske (cjkske-gmail)]

Seems to be working OK.

If the problem recurs I'll open another ticket.

Thanks

On Tue, Aug 16, 2011 at 2:17 PM, Christopher M. Penalver <
<email address hidden>> wrote:

> Cliff Kachinske, this was unreproducible in LibreOffice Calc. Does this
> work for you? If your using Lucid or Maverick feel free to type at a
> Terminal:
>
> sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update &&
> sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc
>
> ** Also affects: libreoffice (Ubuntu)
> Importance: Undecided
> Status: New
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/185476
>
> Title:
> [upstream] OO spreadsheet copies changes from one sheet to another
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openoffice/+bug/185476/+subscriptions
>

[penalvch (penalvch)]

Cliff Kachinske, this bug report is being closed due to your last comment regarding this being fixed with an update. For future reference you can manage the status of your own bugs by clicking on the current status in the yellow line and then choosing a new status in the revealed drop down box. You can learn more about bug statuses at https://wiki.ubuntu.com/Bugs/Status. Thank you again for taking the time to report this bug and helping to make Ubuntu better. Please submit any future bugs you may find.

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.