← Back to team overview

desktop-packages team mailing list archive

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

 

Colin Law, the issue you are reporting is an upstream one and it would
be nice if somebody having it could send the bug to the developers of
the software by following the instructions at
http://wiki.documentfoundation.org/BugReport . If you have done so,
please tell us the number of the upstream bug (or the link), so we can
add a bugwatch that will inform us about its status. Thanks in advance.

** Description changed:

  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
+   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:
+ 3) What is expected to happen in a blank LibreOffice Calc file:
  
- cd ~/Desktop && wget
- https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/899190/+attachment/2616439/+files/test4.ods
- && libreoffice --calc test4.ods
+ type testit in cell A1 -> File -> Save As -> File name: testit -> File type: ODF Spreadsheet (.ods) -> Save button -> Tools -> Macros -> Organize Macros -> LibreOffice Basic... -> click testit.ods -> 
+ Organizer... -> select testit.ods -> click New -> OK button -> with Module1 highlighted click New -> in the text box Name: ThisWorkbook -> OK button -> Close button -> Close button -> Save -> File -> Exit and reopen by double clicking the file or via the Terminal:
  
- or double clicking the file is the file opens successfully.
+ libreoffice --calc testit.ods
+ 
+ and it opens successfully.
  
  4) What happens instead is the document is blank and the Terminal shows:
  
- libreoffice --calc test4.ods
+ libreoffice --calc testit.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
+ libreoffice testit.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.
+ WORKAROUND: After opening via the above workaround, copy the entire
+ sheet from testit.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)

** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Medium

** Changed in: libreoffice (Ubuntu)
       Status: Incomplete => Triaged

** Also affects: df-libreoffice
   Importance: Undecided
       Status: New

** Changed in: df-libreoffice
       Status: New => Incomplete

-- 
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 Productivity Suite:
  Incomplete
Status in “libreoffice” package in Ubuntu:
  Triaged

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 a blank LibreOffice Calc file:

  type testit in cell A1 -> File -> Save As -> File name: testit -> File type: ODF Spreadsheet (.ods) -> Save button -> Tools -> Macros -> Organize Macros -> LibreOffice Basic... -> click testit.ods -> 
  Organizer... -> select testit.ods -> click New -> OK button -> with Module1 highlighted click New -> in the text box Name: ThisWorkbook -> OK button -> Close button -> Close button -> Save -> File -> Exit and reopen by double clicking the file or via the Terminal:

  libreoffice --calc testit.ods

  and it opens successfully.

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

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

  WORKAROUND: Open it via the Terminal command:

  libreoffice testit.ods

  WORKAROUND: After opening via the above workaround, copy the entire
  sheet from testit.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/df-libreoffice/+bug/899190/+subscriptions


References