Quattro Pro for DOS: an obsolete format at last?

Quattro Pro for DOS: an obsolete format at last?

While browsing ArchiveTeam's File Formats Wiki earlier this week, I came across some entries I created there on Quattro Pro spreadsheets two years ago. At the time I had also contributed some old Quattro Pro for DOS spreadsheets (here and here) from my personal archives to the OPF format corpus. Seeing those files again, I decided to spend an afternoon trying to access them using modern-day software. This turned out to be more challenging than expected. It even made me wonder whether, at long last, I had finally run into a case of the much discussed (but rarely observed) phenomenon of format obsolescence. Yes, big words indeed, and if anyone would like to prove me wrong, the comments section below is your friend!

What it's all about

Quattro Pro is a spreadsheet program that was first released in 1988. It's still around today as part of the WordPerfect Office suite. A number of file formats have been associated with the software. This blog post covers the old Quattro Pro for DOS formats:

First of all, let's have a look to what extent contemporary spreadsheet software can handle these formats.

MS Excel

Support for Quattro Pro spreadsheets (including recent versions of the format!) was removed altogether from more recent versions of Excel, as shown by this overview of file formats that are not supported in Excel 2010. On a side note, this list also includes all versions of Lotus 1-2-3 (which was once widely used). Older versions of Excel did offer support for the format. According to Microsoft, Excel 2003 supports Quattro Pro spreadsheets (albeit only after installing some converter add-ons from the Microsoft Office Web site1). The website explicitly mentions Quattro Pro for DOS files, although it also says "there are some limitations to opening the worksheets".

LibreOffice / OpenOffice

According to this overview, LibreOffice offers support for Quattro Pro 6 (WB2) spreadsheets, but it cannot handle the older Quattro Pro for DOS formats. It doesn't mention newer versions of the format either. The situation is the same for OpenOffice.

Tests with Quattro Pro X7

With neither Excel, LibreOffice or OpenOffice being able to open my spreadsheets, I went over to the WordPerfect website and grabbed a trial version of the WordPerfect Office suite (which includes Quattro Pro X7). I then tried opening some files, all of which are available from the spreadsheet section of the OPF Format Corpus.

Simple numerical / text data

I started out by opening two versions of a spreadsheet that contains simple numerical and text data. The first version has the WQ1 (Quattro Pro for DOS version 1-4) format. The file opens without problems:

I also had another version of that spreadsheet in WQ2 (Quattro Pro for DOS version 5) format. Opening this file produced the following result:

For some reason the numbers in some columns (A, C, D, G, H, I) aren't displayed, but clicking on any of those calls reveals they are actually still there. Changing the formatting properties also makes them visible again, as shown below:

So it looks like this is only a formatting issue.

Simple formulas, charts

Next I moved on to two other spreadsheets, which are a bit more interesting because they do some simple calculations2 and also contain charts. First I opened KS4001.WQ2; the screenshot below shows how it is rendered by Quattro Pro:

The main calculation results are in cells H17 and H18. The blue arrows highlight the cells from which these values are calculated. The calculated results are also correct. As before, two columns appear to be empty, but again, clicking these cells reveals that the underlying data (numbers in column C, and a calculation result in column D) are still present. I really don't remember what the chart originally looked like, but I was pleasantly surprised to see it's still displayed at all!

External links

Things got really interesting when I tried opening this WQ2 spreadsheet. Upon opening, Quattro Pro comes up with a preview of the file, and a Hotlinks dialogue box:

I highlighted some areas in red; we'll get back to that in a second. I first selected Open Supporting in the dialogue box, and pressed OK. The result was that both this spreadsheet and another one (our earlier KSBASE.WQ2) were loaded, so apparently it contains a link to that file. After loading, the spreadsheet displays as follows:

Now, pay special attention to the highlighted cells and compare them against the initial preview. This reveals some pretty dramatic changes: some of the preview values in rows 4 and 5 are replaced by Evaluator Stack Error after the file is fully loaded. Clicking on those cells also results in odd sequences of Unicode characters in the formula bar:

My best guess is that these cells contain external references that -for whatever reason- aren't resolved correctly. This in turn also influences the calculation results in cells H17 and H18. I also tried opening the file using the Update References and None options; in both cases the results are the same as described above.

With no access to the software that originally created the files, it is impossible to tell why the external references aren't working. It could be a bug of Quattro Pro, but I'm not ruling out that the spreadsheet may simply be faulty (e.g. perhaps the original referenced spreadsheet got replaced by an identically-named file at some point). Nevertheless, the fact that the correct cell values are displayed in the preview, shows that the original data are present, and it's rather worrying that Quattro Pro doesn't offer an option to fully load the files without updating/overruling them.

Implications for long-term access

Apart from Quattro Pro, modern spreadsheet programs offer no support for Quattro Pro for DOS spreadsheets. The most recent version of Quattro Pro still reads both DOS era formats, although there are some problems. Some of these are formatting-related (e.g. cells that contain data showing up as blank), and can be easily remedied. The behaviour of one spreadsheet with an external dependency is much more problematic, especially because Quattro Pro updates the original values (which are stored in the file) after fully loading the spreadsheet. Migrating this spreadsheet to another format would result in the loss of some of the original data. So, based on this (admittedly cursory) analysis it looks like no modern-day software is able to correctly handle the Quattro Pro for DOS formats. Add to this that the Quattro Pro for DOS formats are proprietary with (as far as I'm aware) no publicly available specifications, and I think we have a pretty strong candidate for a format that may be (nearly) obsolete.

Solutions

Although I haven't explored any concrete solutions for accessing Quattro Pro for DOS spreadsheets, some obvious routes would be:

  • Run an old copy of Quattro Pro for DOS (e.g. in a virtual machine) and export the spreadsheet to e.g. the Lotus 1-2-3 format (which is still reasonably well supported today).
  • Run an old version of MS Excel (2003 or earlier) and export the spreadsheet to the XLS format.

If anyone decides to have a go at this, I'd be very interested to see the results!

Update: analysis by Euan Cochrane; Lotus 1-2-3 problematic as well?

In response to this blog post, Euan Cochrane has done some additional tests with my Quattro Pro files using Quattro Pro 6 running in an emulated environment. Euan's analysis is highly recommended for any readers of this post. Moreover, trying to open a Lotus 1-2-3 file that Euan created as part of his analysis made me realise that Lotus 1-2-3 spreadsheets may also be more problematic than I initially thought. See my comment under Euan's blog post.


  1. I wasn't able to locate these converters anywhere on Microsoft's website. â†©

  2. Just in case anyone's wondering: these spreadsheets calculate a soil's saturated hydraulic conductivity from field measurement data using the inverse auger hole method↩

3 Comments

  1. Spyros Stravoravdis
    September 5, 2021 @ 5:38 pm CEST

    A very late comment 🙂

    It seems LibreOffice / libwps have improved support of Quattro Pro for DOS files.

    Relevant changelogs:
    https://wiki.documentfoundation.org/ReleaseNotes/5.0#New_import_filters
    https://sourceforge.net/p/libwps/code/ci/master/tree/CHANGES

    This is how KS4001.WQ2 is rendered on my PC (default LibreOffice 7.0.4.2 on Debian 11): https://i.imgur.com/pvSybk2.png

    The chart is the same as the one on Euan Cochrane’s follow up blog post (with Quattro Pro version 6 for Windows 3.11). I assume Quattro Pro X7’s support for these old files has deteriorated.

    Trying to open KS4000.WQ2 though still uncovers several faults. With KSBASE.WQ2 on the same directory I get the error “The following external file could not be loaded. Data linked from this file did not get updated. file:///home/spyros/KSBASE”

    After I renamed KSBASE.WQ2 to KSBASE (removed the file extension) it loads something but it’s obviously wrong: https://i.imgur.com/GNI5pwe.png

    (Those letters in column E mean “Error: 502” in greek)

    PS: LibreOffice can also open Lotus 1-2-3 files nowadays. All three converted files in Euan Cochrane’s blog post (KS4001.WB2, KS4001.WK3, KS4001.XLS) opened up in LibreOffice 7.0; unfortunately in all three of them the chart was completely missing. Still: there’s some progress!

    Spyros

  2. TP_Archie
    March 18, 2015 @ 8:52 pm CET

    Still use Quattro Pro v4 (DOS) and also v12 (Win). DOS version is for messing around, and also when I feel like getting Borland Reflex going. DOSBox is best environment – for me this is under XP.
    Compatibility is an issue until you remember that all you really need to save is values, so go for CSV. Most formulae will need fixing so if were me, I’d work from scratch. depends on how well you know your original file (heh-heh). One thing the QPro did that Excel never really bothered to replicate was interactive slide shows. A block of data and some work on charting and you were ready to go. A big no-no in Excel and (as far as I could tell) Lotus 1-2-3 of the time.
    Here’s my blog posting on Quattro Pro https://tparchie.wordpress.com/2014/10/03/quattro-pro-by-borland/

  3. ecochrane
    October 29, 2014 @ 6:29 pm CET

    Hi Johan,

     

    Fascinating post!

     

    I tried opening the files in Quattro Pro 6 for Win 3.11 in QEMU with some interesting results. I had to create another post in order to upload all the screenshots. It is here

     

    Thanks!

     

    Euan

Leave a Reply

Join the conversation