desktop-packages team mailing list archive

[Colin Law <899190@xxxxxxxxxxxxxxxxxx>]

It is possible to replicate the problem with a new document as follows:
Open a new spreadsheet
Enter some text in first cell (this is just so that we can later see that we have opened the spreadsheet ok)
Save the file,  say testit.ods and close the file.
>From a terminal in appropriate directory check that it opens ok with
libreoffice --calc testit.ods
Select Tools > Macros > Organize Macros > LibreOffice Basic
Click Organiser
Select testit.ods
Click New
Leave name as Module1 and click OK
Click New
Change name to ThisWorkbook and click OK
Click Close and Close again
Save the document
Close the document

Open the document again using
libreoffice --calc testit.ods
The error
Entity: line 1: parser error : Start tag expected, '<' not found
is seen in the terminal and the spreadsheet opens apparently empty.  Close it.
Open using
libreoffice testit.ods
and it opens ok.

The bug is a regression as I have not changed the macros in my original
document for many months and it was ok using LibreOffice up till about
two months ago.  So I assume that an update around that time introduced
the problem.

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