[upstream] Modifying (or saving files containing) certain graphs crashes OpenOffice.org 3.1 Spreadsheet

[Grey Nicholson]

Binary package hint: openoffice.org

I have a spreadsheet that contains a graph; unfortunately, the file contains personal data and because of this bug I can't modify it to make the data more generic, so I can't provide an example file.

Each time I try to save this spreadsheet, OOo crashes. Entering the graph's editing mode (i.e. double-clicking the graph) works, but OOo crashes: when I exit the graph's editing mode (when clicking away from the graph); and when opening the Data Ranges dialogue.

One of the data-points included in the graph is the current time, using the NOW() function. Editing the other data plotted on the graph doesn't cause a crash, and the graph updates correctly.

At first I thought the problem related to the spreadsheet having been created by a previous version of OpenOffice.org. However, I have another spreadsheet created at the same time, which doesn't crash under the circumstances described above; this other spreadsheet's graph doesn't include the current time.

ProblemType: Bug
Architecture: i386
Date: Mon Sep 14 00:03:56 2009
DistroRelease: Ubuntu 9.10
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.1.1-1ubuntu2
ProcEnviron:
 PATH=(custom, user)
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-10.32-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-10-generic i686

[Chris Cheney (ccheney)]

I won't be able to do anything with this bug without an example document, setting to incomplete.

[Grey Nicholson (greytheearthling)]

I've found another spreadsheet that also crashes, but contains less-sensitive data—see the attachment.

It seems that the problem isn't the now() function, but that the data ranges go to an arbitrarily-high row number.

Another spreadsheet I have, where the data ranges go to a slightly lower row number, doesn't crash.

Creating a new spreadsheet in OOo 3.1 that goes up to a somewhat-larger final row number doesn't cause the crash.

[Chris Cheney (ccheney)]

This seems to at least lockup official OOo 3.1 if not crash it, so is probably a bug in it.

[penalvch (penalvch)]

Greg K Nicholson, this issue is unreproducible in LibreOffice Calc via the Terminal:

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

typed a few characters in both sheets, saved the file, no crash. Does this work for you?

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

[penalvch (penalvch)]

Greg K Nicholson, your crash report is missing. Please follow these instructions to have apport report a new bug about your crash that can be dealt with by the automatic retracer.

If you are running the Ubuntu Stable Release you might need to enable apport in /etc/default/apport and restart.

Now open your file manager, navigate to your /var/crash directory and open the crash report you wish to submit.
If this fails you will have to open a terminal and file your report with 'ubuntu-bug /var/crash/_my_crash_report.crash' where _my_crash_report.crash is the crash you would like to report. If you get an error that you aren't allowed to access this report you will have to file it with 'sudo ubuntu-bug /var/crash/_my_crash_report.crash'.

I'm closing this bug report since the process outlined above will automatically open a new bug report which can then dealt with more efficiently. Thanks in advance for your cooperation and understanding.