×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Open old Lotus and Quattro Pro files in XLSX

Open old Lotus and Quattro Pro files in XLSX

Open old Lotus and Quattro Pro files in XLSX

(OP)
My company migrated to Office 2007 with Excel 2007.  I have some old spreadsheets with the extensions WB1, WQ1, and WK1 from old versions of Quattro Pro and Lotus IIRC.  I asked our IT dept if there is a converter out there and they were less than helpful saying I needed to find and install the old software and save the files in Excel format.  I don't think Excel was around when I was using Lotus in the 1980's so I doubt that it had a SAVEAS function to convert to XLS format.

Is there a cheap way to convert the old WQ1 files to something Excel 2007 could open?  I searched the web and found a couple that claim to do it but the trial version makes the formulas into text and numbers.  I want the formulas to translate.  

I also tried Open Office which someone said would do it but was not very successful.  I found a Gnumeric that will open one of the formats but not the other two. Has anyone done this?  As big and powerful as MS seems to be, it seems to me that they would be able to open any spreadsheet as far back as Visicalc.

TIA

_____________________________________
I have been called "A storehouse of worthless information" many times.

RE: Open old Lotus and Quattro Pro files in XLSX

I was going to suggest Gnumeric.

The only other option I can think of is to install an old copy of Smartsuite and/or whatever the Borland Office package is called.

I just checked my copy of Smartsuite and it does have options for opening WQ1, WB1 and WB2, and should open any of the old Lotus formats.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Open old Lotus and Quattro Pro files in XLSX

(OP)
OOPS, I forgot to mention that my other option is to install the free trial of the Correl office package that includes the new version of Quattro Pro.  Any idea if the trial is limited to the first 10 rows like one trial I got from ABC?

I'll try to look for Smartsuite around the web.  

My old spreadsheets are probably just pieces of extraneous things I was doing at the time but just looking at the file names and knowing that I can't see what is in them bugs me no end.  I had wrongly assumed Excel would open them forever.  IIRC, Excel 2003 or the previous version (2000?) would open them because I have saved some in XLS format.

_____________________________________
I have been called "A storehouse of worthless information" many times.

RE: Open old Lotus and Quattro Pro files in XLSX

(OP)
I D/L Corel's WordPerfect Office X4 Trial Version (good for 30 days, unlimited functionality) and it will open my old spreadsheets and save them as Excel 2003 XLS files.  This seems to be the cheapest solution.  Someone said on another forum that MS is doing a victory dance on the other spreadsheet formats by not including the ability to open them.  I wouldn't mind not being able to save in the other formats once the files were open and working, but I guess with the huge market share of Office suites that MS has, they feel they can thumb their nose at all the others.

_____________________________________
I have been called "A storehouse of worthless information" many times.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources