[Solved+Issue] Converting QuattroPro .qpw files

Discuss the spreadsheet application

[Solved+Issue] Converting QuattroPro .qpw files

Postby furma2n » Mon May 05, 2008 6:56 pm

Does anyone know how to convert a Quattro Pro .qpw file into Calc 2.4? All my backup files are in this old format, and Excel will not open them, so I thought maybe Calc could do it, but I can not figure out how. Any help will be appreciated...............
Last edited by Hagar Delest on Wed Jun 25, 2008 12:10 pm, edited 3 times in total.
Reason: Tagged the thread as issue (link to a bug report).
furma2n
 
Posts: 2
Joined: Mon May 05, 2008 6:21 pm

Re: Converting QuattroPro .qpw files

Postby squenson » Mon May 05, 2008 7:59 pm

If you tried and it did not work, then it means that it is not possible. There is a filter for Quattro pro, but the extension is wb2, not qpw.

You should go to http://www.corel.com and download a trial version, open your old files, save them in Excel format (or OOo Calc format if allowed), and then open them with OOo.
LibreOffice 4.1.3.2. on Ubuntu 13.10
User avatar
squenson
Volunteer
 
Posts: 1878
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Converting QuattroPro .qpw files

Postby furma2n » Wed May 07, 2008 4:38 pm

Thanks, this did the trick..............
furma2n
 
Posts: 2
Joined: Mon May 05, 2008 6:21 pm

Re: Converting QuattroPro .qpw files

Postby squenson » Wed May 07, 2008 11:47 pm

Please do me (us) a favor then: edit your first post and add "[solved]" (without the quotes) at the beginning of the subject line, so other forum participants may benefit from your solution.
LibreOffice 4.1.3.2. on Ubuntu 13.10
User avatar
squenson
Volunteer
 
Posts: 1878
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: NOT [Solved] Converting QuattroPro .qpw files

Postby rebresb » Wed Jun 25, 2008 2:57 am

This doesn't solve the problem since .qpw files don't always fit into Excel format. The QP export into Excel uses pre-2007 MS Office format of 256 columns x 65,536 rows, but the .qpw limits are well in excess of that: 18,276 columns x 1e6 rows. Since Excel 2007 has 16,384 columns x 1e6 rows, its still smaller than Quattro Pro and won't be a solution even if QP upgrades their export for Excel files to 2007 format.
Though a fix is in the works to upgrade OOo Calc to accommodate these larger sizes (http://www.openoffice.org/issues/show_bug.cgi?id=30215), it's still using the archaic limit of the old Excel files (a poor industry "standard") and import for large QP sheets won't be possible until OOo completes this fix. This is why my workgroup purchased Corel Office X3: inadequate function in both Excel and OpenOffice.org spreadsheets. I'll anxiously await the upgrade to OOo Calc and implementation of a direct import filter for .qpw, since even Excel can't do that right now. OOo should take the lead in such compatibility and cross-platform support issues.
OOo 2.4.X on Ubuntu 8.x + WinXP
rebresb
 
Posts: 3
Joined: Wed Jun 25, 2008 2:37 am

Re: NOT [Solved] Converting QuattroPro .qpw files

Postby TheGurkha » Sun Jun 29, 2008 10:41 pm

rebresb wrote:I'll anxiously await the upgrade to OOo Calc and implementation of a direct import filter for .qpw, since even Excel can't do that right now.


Are you aware of any plans to implement a .qpw filter? Or are you just saying you'll look forward to a day when such a thing comes about?
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: [Solved+Issue] Converting QuattroPro .qpw files

Postby rebresb » Thu Jul 31, 2008 10:19 pm

I'm not aware of anyone working on a filter for .qpw files, but hope that someone considers it. It would be great to have this enhancement over competitors. Quattro Pro has used .qpw format since ~2002, so it's been around for quite some time. Though I saw a claim that Calc "supports Quattro Pro files", this claim seems weak since it only applies to the very outdated format of .wb2. Of course, demand hasn't been strong for such filters given its small market share.
OOo 2.4.X on Ubuntu 8.x + WinXP
rebresb
 
Posts: 3
Joined: Wed Jun 25, 2008 2:37 am

Re: [Solved+Issue] Converting QuattroPro .qpw files

Postby TheGurkha » Sat Aug 02, 2008 2:47 pm

rebresb wrote:Of course, demand hasn't been strong for such filters given its small market share.


I think thats the nail, and you seem to have struck it firmly on the head. Perhaps Zamzar or another free file conversion site can convert directly from quattro to calc?
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: [Solved+Issue] Converting QuattroPro .qpw files

Postby Windrider6 » Tue Jun 02, 2009 12:08 am

I too used to use Quattro Pro (as well as WordPerfect), and would like to request an import filter for Calc to load Quattro Pro's .qpw files.
» If at first you succeed, try to hide your astonishment.
~
• Bruce A. Johnson in Hardisty, Alberta, Canada
Bruce@BruceJohnson.ca
• Windows Vista
OOo 3.1.X on MS Windows Vista + Win XP
User avatar
Windrider6
 
Posts: 3
Joined: Sat Mar 22, 2008 12:52 am
Location: Hardisty, Alberta, Canada

Re: [Solved+Issue] Converting QuattroPro .qpw files

Postby Hagar Delest » Tue Jun 02, 2009 8:07 am

Then vote for the issue linked above (up to 2 votes per issue). You'll need to register, it's not the same user database as this forum.
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25074
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests