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

[Wayne Vizniowski]

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

[Non-migrated-user (non-migrated-user)]

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.

[Fst-t (fst-t)]

Hi Falko,

1 4 u

Frank

[Thepianoguy (thepianoguy)]

I am missing this feature as well...

[Oc-n (oc-n)]

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

[Oc-n (oc-n)]

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

[Oc-n (oc-n)]

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

[Fst-t (fst-t)]

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

[D-ft (d-ft)]

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

[D-ft (d-ft)]

closed

[Mmeeks-x (mmeeks-x)]

We are working on this.

[Mmeeks-x (mmeeks-x)]

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

[Padjxn (padjxn)]

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?

[Mestech (mestech)]

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.

[Mmeeks-x (mmeeks-x)]

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

[Troodon (troodon)]

troodon->mestech

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

[Padjxn (padjxn)]

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

[Chris Crisafulli (itnet7)]

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.

[Chris Cheney (ccheney)]

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.

[Chris Crisafulli (itnet7)]

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?

[Chris Cheney (ccheney)]

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

[Chris Crisafulli (itnet7)]

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.

[Andrew (andrewabc)]

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.

[Andrew (andrewabc)]

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.

[Chris Cheney (ccheney)]

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

[Nopower (nopower)]

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

[Del-sur (del-sur)]

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.

[Bruce-a-johnson (bruce-a-johnson)]

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.

[Pfaure (pfaure)]

HEllo,

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

[Cloph (cloph)]

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

[penalvch (penalvch)]

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.

[Björn Michaelsen (bjoern-michaelsen)]

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

[Björn Michaelsen (bjoern-michaelsen)]

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

[Björn Michaelsen (bjoern-michaelsen)]

[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

[Mkrcds (mkrcds)]

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

[Reisi007 (reisi007)]

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

[Owen-genat (owen-genat)]

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.

[Owen-genat (owen-genat)]

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

[Jmadero-dev (jmadero-dev)]

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

[penalvch (penalvch)]

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.

[penalvch (penalvch)]

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