Ubuntu
libreoffice package

[Upstream] Cannot open xls file in 3.6.3.2, but works in 3.5.4

Bug #1083947 reported by Poldi
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
LibreOffice
Invalid
Medium
libreoffice (Ubuntu)
Fix Released
Medium
Unassigned

Bug Description

1) lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.2~rc2-0ubuntu4
  Candidate: 1:3.6.2~rc2-0ubuntu4
  Version table:
 *** 1:3.6.2~rc2-0ubuntu4 0
        900 http://archive.ubuntu.com/ubuntu/ quantal-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.6.2~rc2-0ubuntu3 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages

3) What is expected to happen in Calc via a terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1083947/+attachment/3445698/+files/Test.xls && localc --nologo Test.xls

is it opens successfully.

4) What happens instead is a Text Import window opens up, with unexpected characters showing up:
��������

This is a regression from 11.10:
lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.4.4-0ubuntu1.4
  Candidate: 1:3.4.4-0ubuntu1.4
  Version table:
 *** 1:3.4.4-0ubuntu1.4 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        500 http://security.ubuntu.com/ubuntu/ oneiric-security/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

WORKAROUND: Use Gnumeric.

apt-cache policy gnumeric
gnumeric:
  Installed: 1.10.17-1.1ubuntu1
  Candidate: 1.10.17-1.1ubuntu1
  Version table:
 *** 1.10.17-1.1ubuntu1 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/universe i386 Packages
        100 /var/lib/dpkg/status

WORKAROUND: Use Excel via WINE.

Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit)

apt-cache policy wine1.5
wine1.5:
  Installed: 1.5.18-0ubuntu1
  Candidate: 1.5.18-0ubuntu1
  Version table:
 *** 1.5.18-0ubuntu1 0
        500 http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu/ quantal/main i386 Packages
        100 /var/lib/dpkg/status

Original Reporter Comments: The same file can be opened ok in LibreOffice 3.5.4, MS Office and Open Office in MacOS.

ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: libreoffice 1:3.6.2~rc2-0ubuntu4
ProcVersionSignature: Ubuntu 3.5.0-19.30-generic 3.5.7
Uname: Linux 3.5.0-19-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.6.1-0ubuntu6
Architecture: amd64
Date: Wed Nov 28 15:46:52 2012
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-11-23 (4 days ago)

See original description
Revision history for this message
Poldi (poldi) wrote :
Revision history for this message
Poldi (poldi) wrote :

Guess its never a good sign if I;m the only one affetcted.

Is there anything I can do to provide more info?

penalvch (penalvch)
description: updated
tags: added: regression-release
Revision history for this message
penalvch (penalvch) wrote :

Poldi, thank you for taking the time to report this bug and helping to make Ubuntu better. 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 verbatim 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 the status. Thanks in advance.

Helpful bug reporting tips:
https://help.ubuntu.com/community/ReportingBugs

Reproducible in:
Microsoft Windows Vista Business x86
6.0.6002 Service Pack 2 Build 6002
Version 3.6.4.1 (Build ID: a9a0717)

Changed in libreoffice (Ubuntu):
importance: Undecided → Medium
status: New → Triaged
Revision history for this message
In , Poldi (poldi) wrote :

Created attachment 70895
This is a test file that shows the problem

Problem description:

When opening an xls file (see attached sample), the file is not recognised as a spreadheet. It looks like its treated like a csv file as I get the same dialog popup you get when dealing with csv files in a spreadsheet.

Have reported this as an ubuntu bug, and was asked to post this upstream

Steps to reproduce:
1. open the attached in version 3.6.3.2

Current behavior:
Opening the attached opens it as a Text Import window, with unexpected characters showing up:
��������

Expected behavior:

Open the attached as a spreadsheet

Operating System: Ubuntu
Last worked in: 3.5.4 release

Revision history for this message
Poldi (poldi) wrote :

done. The id is 57787

Cheers

Revision history for this message
In , penalvch (penalvch) wrote :

Reproducible in:
Microsoft Windows Vista Business x86
6.0.6002 Service Pack 2 Build 6002
Version 3.6.4.1 (Build ID: a9a0717)

summary: - Cannot open xls file in 3.6.3.2, but works in 3.5.4
+ [Upstream] Cannot open xls file in 3.6.3.2, but works in 3.5.4
Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
importance: Unknown → Medium
status: Unknown → Confirmed
Revision history for this message
In , Davian818 (davian818) wrote :

*** This bug has been marked as a duplicate of bug 53909 ***

Bug Watch Updater (bug-watch-updater)
Changed in df-libreoffice:
status: Confirmed → Invalid
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package libreoffice - 1:4.0.0~beta2-0ubuntu2

---------------
libreoffice (1:4.0.0~beta2-0ubuntu2) raring; urgency=low

  * Build using the internal libmspub for a first build.
 -- Matthias Klose <email address hidden> Tue, 19 Feb 2013 00:05:26 +0100

Changed in libreoffice (Ubuntu):
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.