← Back to team overview

desktop-packages team mailing list archive

[Bug 899190] Re: Unable to open spreadsheet using --calc

 

Thank you for reorganising the bug report to be more logical.
The failing document was originally (years ago) created using MS Excell.  It was then maintained using OpenOffice and then LibreOffice.  I am not aware of any reason that it should have become corrupted.  The actual document I have posted here is a much cut down version of the original which fails, I removed as much of it as I could whilst still retaining the failure mode.
I am not able to reproduce the problem starting with a good document.
I am quite prepared to believe that the problem is due to a corruption of some sort, the main point of the bug is that opening it in one way leads to success whereas another silently fails (if opened via the launcher or double clicking) with no indication that there is in fact anything in the spreadsheet at all.
However if that would not be accepted as a valid bug upstream then so be it.  I would have hoped that someone who understands the file format would at least have a look at the file to see what the problem is.

I did not mention it in the report, but is the fact that if I open it
using libreoffice test4.ods then do a Save As then the corruption
persists in the new file?

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

Title:
  Unable to open spreadsheet using --calc

Status in “libreoffice” package in Ubuntu:
  Incomplete

Bug description:
  1) lsb_release -rd
  Description:	Ubuntu 11.10
  Release:	11.10

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.4.4-0ubuntu1
    Candidate: 1:3.4.4-0ubuntu1
    Version table:
   *** 1:3.4.4-0ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
          100 /var/lib/dpkg/status
       1:3.4.3-3ubuntu2 0
          500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

  3) What is expected to happen in LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/899190/+attachment/2616439/+files/test4.ods
  && libreoffice --calc test4.ods

  or double clicking the file is the file opens successfully.

  4) What happens instead is the document is blank and the Terminal
  shows:

  libreoffice --calc test4.ods
  Entity: line 1: parser error : Start tag expected, '<' not found
  PK
  ^

  Original Reporter Comments: Some edits to the document will fix the
  problem, others do not.

  WORKAROUND: Open it via the Terminal command:

  libreoffice test4.ods

  WORKAROUND: Copy the entire sheet from test4.ods into a new, blank
  Calc document, save the document and then one may open via the
  expected Terminal commands or by double clicking.

  ProblemType: Bug
  DistroRelease: Ubuntu 11.10
  Package: libreoffice (not installed)
  ProcVersionSignature: Ubuntu 3.0.0-13.22-generic 3.0.6
  Uname: Linux 3.0.0-13-generic i686
  ApportVersion: 1.23-0ubuntu4
  Architecture: i386
  Date: Fri Dec  2 14:14:57 2011
  InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429)
  ProcEnviron:
   PATH=(custom, user)
   LANG=en_GB.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to oneiric on 2011-10-14 (49 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/899190/+subscriptions


References