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 -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
