[Upstream] Calc can't load a *.wb3 file

Bug #314147 reported by Wayne Vizniowski
8
Affects Status Importance Assigned to Milestone
LibreOffice
Confirmed
Wishlist
OpenOffice
Unknown
Low
gnumeric (Ubuntu)
Invalid
Undecided
Unassigned
libreoffice (Ubuntu)
Fix Released
Wishlist
Unassigned
openoffice.org (Ubuntu)
Won't Fix
Wishlist
Unassigned

Bug Description

Binary package hint: openoffice.org

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

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386
Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

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

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/314147/+attachment/434865/+files/CAR08.wb3 && localc -nologo CAR08.wb3

is the file opens.

4) What happens instead is it fails silently.

WORKAROUND: Convert the file using Gnumeric's ssconvert and open in LibreOffice via the Terminal:

ssconvert CAR08.wb3 CAR08.ods && localc -nologo CAR08.ods

WORKAROUND: Use Gnumeric.

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

Original Reporter Comments: Opening a *.wp3 file crashes OOspreadsheet. reloading says it fixes the file, but nothing is on the screen. reloading the file causes same to crash again. OO 2.4.1 for ubuntu.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 8.10
Package: openoffice.org-core 1:2.4.1-11ubuntu2.1
ProcEnviron:
 PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
 LANG=en_CA.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.27-9-generic i686

Revision history for this message
In , Non-migrated-user (non-migrated-user) wrote :

I would like to see import filters for QP files, at least version 7 to 10.

Best regards
Werner

P.S. I would be happy to help testing such a feature.

Revision history for this message
In , Fst-t (fst-t) wrote :

Hi Falko,

1 4 u

Frank

Revision history for this message
In , Thepianoguy (thepianoguy) wrote :

I am missing this feature as well...

Revision history for this message
In , Oc-n (oc-n) wrote :

*** Issue 8494 has been marked as a duplicate of this issue. ***

Revision history for this message
In , Oc-n (oc-n) wrote :

*** Issue 11390 has been marked as a duplicate of this issue. ***

Revision history for this message
In , Oc-n (oc-n) wrote :

*** Issue 19860 has been marked as a duplicate of this issue. ***

Revision history for this message
In , Fst-t (fst-t) wrote :

*** Issue 20753 has been marked as a duplicate of this issue. ***

Revision history for this message
In , D-ft (d-ft) wrote :

We do not work on any other filter than MS Office ones.
All other filter projects mnust be initiated and done by the community.

Revision history for this message
In , D-ft (d-ft) wrote :

closed

Revision history for this message
In , Mmeeks-x (mmeeks-x) wrote :

We are working on this.

Revision history for this message
In , Mmeeks-x (mmeeks-x) wrote :

So, Shilpa is working on this, turns out the format is not that difficult to get
to grips with.

Revision history for this message
In , Padjxn (padjxn) wrote :

Dell has been supplying PCs with Corel Office with Wordperfect and Quattro ready
installed for some time and small businesses have developed systems using these
programs which do not transport well to any other office package. We have been
using Corel office since 1998 and we do not have any programming ability on site
but we are holding off implementing Open Office because of these legacy
spreadsheets which we need to cross over. Is there any progress on releasing an
import filter?

Revision history for this message
In , Mestech (mestech) wrote :

Today at lunch time I was asked about OpenOffice support for WordPerfect files.
 The one issue is the support for Quattro Pro files. This is a thread in the
users mail list as well.

Lack of support is a deal breaker in this case.

Gnumeric will open wb3 files, kspread just crashes.

Neither will open qpw files.

Revision history for this message
In , Mmeeks-x (mmeeks-x) wrote :

> Lack of support is a deal breaker in this case.

So - we can help point you either to some documentation to help write this
filter - we wrote (sadly) a filter tackling only the older QPro file formats a
while back that should be included; anyhow drop me a mail :-)

Revision history for this message
In , Troodon (troodon) wrote :

troodon->mestech

As mmeeks says there is already support for Quattro Pro 6.0 files. See issue 41688.

Revision history for this message
In , Padjxn (padjxn) wrote :

Speaking personally we have about 40% of our files in wb3 format and 60% in qpw
format and we are currently using Quattro v11 and v12. wb2 is from pre 1998 and
has never been used here

Revision history for this message
Wayne Vizniowski (wayne-vizniowski) wrote :
Revision history for this message
Chris Crisafulli (itnet7) wrote :

Thanks for submitting the bug in order to make Ubuntu better.

I believe at this time only .wb2 is supported, I do confirm the crash, but since it's not a supported format I think this should be marked invalid as a bug.

You can use Gnumeric to open the .wb3 file, I successfully opened it without issue, this is also in the repositories.

You might already know this but you can install gnumeric from a terminal by using the following command:

sudo apt-get install gnumeric

I would go to OpenOffice.org and find out more about submitting that enhancement request.

Changed in openoffice.org:
status: New → Invalid
Revision history for this message
Chris Cheney (ccheney) wrote :

This appears to be an ooo-build issue, attempting to open the file in upstream openoffice.org just pops up the unknown file type dialog.

Changed in openoffice.org:
status: Invalid → Confirmed
importance: Undecided → Medium
status: Confirmed → Triaged
Revision history for this message
Chris Crisafulli (itnet7) wrote : Re: [ooo-build] can't load a *.wb3 file

Are you saying that when you use upstream openoffice.org, and you open openoffice.org wordprocessor, select Open, and expand the file type in the lower left corner of the Open Dialogue window, that Quattro pro 7.0 and/or wb3 file extension is available as an option?

Revision history for this message
Chris Cheney (ccheney) wrote :

No, with the upstream openoffice.org it can not open the file but it doesn't even attempt to do so it does not crash. When you try to open it shows an unknown file type dialog that makes you tell it what it is, essentially it is telling you it does not support the type of file you are trying to open.

Chris

Revision history for this message
Chris Crisafulli (itnet7) wrote :

Oh, cool thanks for your response, Now I understand what you meant. I was thinking that he was wanting full on support for .wb3... Instead of get the unknown file dailogue to prevent crashing.

Revision history for this message
Andrew (andrewabc) wrote :

Using openoffice 3.0.1 build OOO300m14 build 9376 (will update later today)

When I try to open .wb3 files Openoffice starts up (shows the splash screen loading with progress bar), then it crashes and gets killed before doing anything else. If I try opening the document when I already have another document open, it will try to autorecovery the document and autorecovery appears to freeze and I have to manually kill openoffice from system monitor.

I don't think windows version of 3.0.0 crashes (havn't updated it to 3.0.1 yet). But for some weird reason MSO 2003 cannot open the file either. I think when I had corel I had to export the spreadsheet to other formats (mostly .xls back when I used MSO).

Would be nice if OOo could open corel spreadsheets.

If someone has gnumeric installed and it is capable of opening this file I guess I will install that for now.

Revision history for this message
Andrew (andrewabc) wrote :

I updated to the latest openoffice in the PPA and same problem.

I installed gnumeric and it appears to open the .wb3 file good. Maybe missing some font stuff, but otherwise the data in them are fine.

I saved the .wb3 as .ods using gnumeric, but it did not preserve any of the formulas. Only the numbers/text remain. :(
Apparently because it is not fully implemented in gnumeric.

Saving the .wb3 to excel 97/2000/xp format retained the formulas.

Revision history for this message
In , Chris Cheney (ccheney) wrote :

User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.5) Gecko/2008121711 Ubuntu/9.04 (jaunty) Firefox/3.0.5

When attempting to open the wb3 file OOo (ooo-build) crashes. On official OOo it brings up the filter selection dialog box instead of crashing.

http://launchpadlibrarian.net/20927742/CAR08.wb3

Reproducible: Always

Changed in openoffice:
importance: Undecided → Unknown
status: New → Unknown
Changed in openoffice:
status: Unknown → Confirmed
Revision history for this message
In , Nopower (nopower) wrote :
Download full text (5.8 KiB)

confirmed crasher

(gdb) where
#0 0x0873ba08 in ?? ()
#1 0xb701e745 in utl::OSeekableInputStreamWrapper::seek(long long) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libutlli.so
#2 0xafa296d4 in WPXSvInputStream::seek(long, WPX_SEEK_TYPE) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libwpgimportli.so
#3 0xaf9dfb87 in libwpg::WPGraphics::isSupported(WPXInputStream*) () from /usr/lib/libwpg-0.1.so.1
#4 0xafa38d63 in WPGImportFilter::detect(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libwpgimportli.so
#5 0xb1c5ef1e in filter::config::TypeDetection::impl_askDetectService(rtl::OUString const&, comphelper::MediaDescriptor&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libfilterconfig1.so
#6 0xb1c5f63c in filter::config::TypeDetection::impl_detectTypeDeepOnly(comphelper::MediaDescriptor&, comphelper::SequenceAsVector<rtl::OUString> const&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libfilterconfig1.so
#7 0xb1c61155 in filter::config::TypeDetection::queryTypeByDescriptor(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>&, unsigned char) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libfilterconfig1.so
#8 0xb20d28e9 in framework::LoadEnv::impl_detectTypeAndFilter (this=0x8622efc) at /media/disk/BUILD-related/LATEST/ooo-build/build/dev300-m40/framework/source/loadenv/loadenv.cxx:831
#9 0xb20d3253 in framework::LoadEnv::startLoading (this=0x8622efc) at /media/disk/BUILD-related/LATEST/ooo-build/build/dev300-m40/framework/source/loadenv/loadenv.cxx:399
#10 0xb20ca5cc in framework::LoadDispatcher::impl_dispatch(com::sun::star::util::URL const&, com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&, com::sun::star::uno::Reference<com::sun::star::frame::XDispatchResultListener> const&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libfwkli.so
#11 0xb20ca8ce in framework::LoadDispatcher::dispatchWithReturnValue(com::sun::star::util::URL const&, com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libfwkli.so
#12 0xb7be9791 in comphelper::SynchronousDispatch::dispatch(com::sun::star::uno::Reference<com::sun::star::uno::XInterface> const&, rtl::OUString const&, rtl::OUString const&, long, com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libcomphelp4gcc3.so
#13 0xb7f73e46 in desktop::DispatchWatcher::executeDispatchRequests(std::vector<desktop::DispatchWatcher::DispatchRequest, std::allocator<desktop::DispatchWatcher::DispatchRequest> > const&, bool) () from /media/disk-4/BUILD-related/LATEST/ooo-build/INSTALL_LINK/program/../basis-link/program/libsofficea...

Read more...

Revision history for this message
In , Del-sur (del-sur) wrote :

I'm confused -- is there a way to convert wb3 files yet???
I'm in desperate need (for 2005 taxes) of some info that may or may not be on a
wb3 file I have.

If a conversion is not available now, it would still be nice to have in the
future.

Thanks.

Revision history for this message
In , Bruce-a-johnson (bruce-a-johnson) wrote :

To update and clarify, what is needed is import filters for .QPW and .WP3 file
formats. .QPW format (Quattro Pro Windows), has been in use since about 2003
(maybe earlier), and most people who have used Quattro Pro since then, have
their files in .QPW format.

Revision history for this message
In , Pfaure (pfaure) wrote :

HEllo,

I was wondering if there was any timeline for this issue?

Revision history for this message
In , Cloph (cloph) wrote :

*** Issue 109509 has been marked as a duplicate of this issue. ***

Chris Cheney (ccheney)
tags: added: intrepid
Changed in openoffice:
importance: Unknown → High
penalvch (penalvch)
description: updated
penalvch (penalvch)
Changed in openoffice:
importance: High → Unknown
status: Confirmed → Unknown
Changed in openoffice:
importance: Unknown → Low
status: Unknown → Confirmed
Revision history for this message
In , penalvch (penalvch) wrote :

Created attachment 46640
CAR08.wb3

Downstream bug may be found at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/314147

Related OOo bug may be found at:
http://openoffice.org/bugzilla/show_bug.cgi?id=5460

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

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386
Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

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

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/314147/+attachment/434865/+files/CAR08.wb3 && localc -nologo CAR08.wb3

is the file opens.

4) What happens instead is it fails silently.

penalvch (penalvch)
Changed in libreoffice (Ubuntu):
importance: Undecided → Wishlist
status: New → Triaged
summary: - [ooo-build] can't load a *.wb3 file
+ [Upstream] Calc can't load a *.wb3 file
Changed in df-libreoffice:
importance: Unknown → Wishlist
status: Unknown → Confirmed
penalvch (penalvch)
Changed in gnumeric (Ubuntu):
status: New → Invalid
penalvch (penalvch)
Changed in openoffice.org (Ubuntu):
importance: Medium → Wishlist
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote : migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote :

This is:
- a clearcut upstream issue
- wishlist/feature request unlikely to be fixable with a simple patch
- wont be fixed in libreoffice packaging
Resolving as WONTFIX in libreoffice packaging. This does not mean the issue will not be cared about, but if it is cared about (even by Ubuntu/Canonical contributors), it is done upstream at LibreOffice.

Libreoffice (Ubuntu) => WONTFIX

Changed in libreoffice (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
In , Björn Michaelsen (bjoern-michaelsen) wrote :

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Changed in df-libreoffice:
status: Confirmed → Incomplete
Revision history for this message
In , Mkrcds (mkrcds) wrote :

*** Bug 15875 has been marked as a duplicate of this bug. ***

Changed in openoffice:
status: Confirmed → Unknown
Revision history for this message
In , Reisi007 (reisi007) wrote :

Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian

Changed in df-libreoffice:
status: Incomplete → Invalid
Changed in df-libreoffice:
status: Invalid → Confirmed
Revision history for this message
In , Owen-genat (owen-genat) wrote :

Added Apache OO issue to See Also list (https://issues.apache.org/ooo/show_bug.cgi?id=64403 would seem a related duplicate). Version set to Inherited From OOo.

Revision history for this message
In , Owen-genat (owen-genat) wrote :

Setting version back from "Inherited From OOo" to what it was prior (for bugs marked enhancement), for QA tracking purposes. My mistake. Apologies.

Revision history for this message
In , Jmadero-dev (jmadero-dev) wrote :

I don't see that this was ever confirmed. REOPENED is incorrect status. Moving back to UNCONFIRMED.

Changed in df-libreoffice:
status: Confirmed → New
Revision history for this message
In , penalvch (penalvch) wrote :

This was initially reported downstream 5 years ago, as noted in the See Also: at the top of this report -> https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/314147 , and as I've confirmed this now twice, once downstream, and now again here by reporting it, I've marked this New as outlined in https://wiki.documentfoundation.org/QA/BSA/BugReport_Details#Initial_state (which doesn't require a member of QA confirming a bug to mark it New).

Despite this, as I'm now formally a member of QA https://wiki.documentfoundation.org/QA/Team , I've gone ahead and placed myself as the QA contact if you would have further questions regarding the scope of this report.

Changed in df-libreoffice:
status: New → Confirmed
Revision history for this message
penalvch (penalvch) wrote :

Resolved in as early as:
Version: 6.2.4.2 (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64

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

Other bug subscribers

Remote bug watches

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