Quattro Pro (by Borland)


At a recent seminar, the virtues of an i-Something-or-other was being extolled, for the purpose of presentations. My mind was drawn to an old product, Quattro Pro. This was a spreadsheet from long before the days of MS Office dominance.

QPro-25-rows

QPro-25-rows

This takes us back to the early 1990’s. The then leading spreadsheet was Lotus 1-2-3. 1-2-3 did some useful things but it wasn’t pretty. A market grew up for Lotus 1-2-3 add ons. These gave that market leading product a WYSIWYG style interface.

In those long gone days, XP wasn’t born and even Windows 95 was little more than a ‘look and feel’ glint in Gate’s eye. WIMP – Windows /Icon / Menu / Pointer – that was the direction of nerd-heaven. IBM compatibles ruled the roost powered by DR DOS, IBM DOS and MS DOS. Windows 3.1 and O/S 2 were recent market entrants for those who insisted on Mice, Pointers and a GUI experience. Yet Apple was dying on its feet – entrenched in an 8% market share of all things desktop.

Lotus 1-2-3 ran well in a standard 512 kb of RAM. It was lean and effective. Ah happy days, Upper Memory Blocks and then Extended memory and Expanded memory which took software beyond the one Megabyte limit.

I can still imagine that nameless IBM rocket-scientist: “We’ll set maximum memory at ONE MEGABYTE. That’s an incredible amount of RAM. No one will ever, ever want any more than that. And if they do, we’ll just hard code it in.” 🙂

Bet they didn’t smile then. Bet they were seriously po faced.

Back to Quattro Pro.

QPro-50-Rows-+-Display-menu

QPro-50-Rows-+-Display-menu

I started with Supercalc. It was actually Supercalc 3.1 – essentially Supercalc 2 with a macro-interpreter thrown in. At that time, macros were in the main, keystroke interpreters. Supercalc could export to Lotus 1-2-3, the group standard, but the results weren’t always reliable. I needed to get a more reliable product that didn’t break the bank (Lotus 1-2-3 would set you back £400-ish). I shopped around, coaxed by the urgings of the Company Secretary. Quattro came top.

The Group ‘encouraged’ us to get a copy of Lotus 1-2-3 anyway, so I had plenty of opportunity to cross-check the credentials of the respective products.

Leaving that story aside, by 1992 I had a copy of Quattro Pro v4. Still have it.

Its help system under ‘Help for Lotus 123 Converts’ said
Just a few Quattro Pro Features Not Available in 1-2-3
Graph Insertion Insert Graphs directly into the spreadsheet
Graph Annotation Use an Annotator to draw on the graph
Multiple Windows Open up to 32 windows at once (years before Win 95)
File Manager Use the File Manager to work with files on Hard Drive
Transcript Use the Transcript Utility to review, replay and make macros from actions
Graph Buttons Use Graph Buttons to navigate between topics in slide shows and to run macros
132 col display View more data at a time with 132 column display mode

Fighting talk to the likes of Jim Manzi, then boss of Lotus Development. The Look and Feel case dragged on for years and proved one thing; it’s possible to hire lawyers and other expert advice so compelling that you lose touch with your core business. Lotus lost touch with its, and succumbed to a hostile bid from IBM. By then, Philippe Kahn (head of Borland) had flogged Quattro Pro to Novell, and Microsoft used its monopoly power to leverage MS Office onto new PC’s. If you wanted to offer Windows 95, you knew which way to jump.

Quattro Pro could read a number of file types. It’s hard to test every file type, but apart from Havard Graphics, which I never got my hands, I remember little problem in handling the table below (it’d be interesting to know how translation from CHT files went).

WQ1 default extension
DB Paradox
DB2 dBASE II
DBF dBASE IV
WKQ Quattro 1.x
CHT Havard Graphics 2.x
RXD Reflex 1
R2D Reflex 2
WKP Surpass
DIF Visicalc
ALL Allways*
FMT Impress*
SLK Multiplan
WK1 Lotus 1-2-3 2.01, 2.2
WKS Lotus 1-2-3 1A
WKE Lotus 1-2-3 Educ
WK3 Lotus 1-2-3 3.x
FM3 Lotus 1-2-3 3.x WYSIWYG add-in*
WR1 Symphony 2.0
WRK Symphony 1.2

File compression in Quattro Pro results in additional file extensions. It handles file compression for its own files, and those generated by Lotus 1-2-3, via a utility called SQZ!

File extension / type of file compressed
WQ! Quattro Pro File
WKZ Quattro Pro 1 File
WK$ WKS File
WK! WK1 File

SQZ! has options to change the way compression works. These are:
– Remove blanks
– Storage of Values (i.e. formulae or formulae + resulting values)
– Version (SQZ! and SQZ! Plus

File-Manager

(SQZ! was found in File-Manager)

Getting Quattro pro up and running was quite a grind. It turned out that my re-installation failed to generate screen font definition files – which meant that WYSISWYG mode crashed DOSbox.

That problem was fixed by copying the following files (from an earlier installation)

INDEX.FON
DUT__000.FON
SWS__000.FN2

Method to launch is:

Open a DOS window (Run Command.com)

Run DOSbox (Mount c C:\Tools\Qpro [enter])

Run Qpro (q [enter])

QPro-WYSiWYG

QPro-WYSiWYG

A retrospect on the special features

Graph Insertion Quattro Pro manages graphs by naming them; in Excel, each insertion creates a new chart – it doesn’t use named charts;
Graph Annotation Chart tools
Multiple Windows Part of standard Windows functionality, noting that the recent Windows Tile is a bit retro.
File Manager Dealt with via Windows Explorer
Transcript Excel equivalent is Record a Macro
Graph Buttons Requires stand alone Presentation Software
132 col display Zoom – part of standard Windows functionality

Graph Buttons and Slide Shows

It’s worth having a further look at Graph Buttons. These allow a slide show to become a presentation – each button can become a hotlink to a different chart.
How does it work?
Define your charts.

Annotating a Chart

Annotating a Chart

Edit each chart: add buttons to link to the next chart.

Headcount-Admin

Headcount-Admin

Chart Headcount-Indirect

Chart Headcount-Indirect

Headcount-by-Function-April

Headcount-by-Function-April

Eventually your slide show is done and all your data to drive the charts is in the same spreadsheet. The Annotation module let you load, draw and save CLP files. Saved Text Boxes remember which graph they point to.  Here’s a mental map of my slide show.

Slide Show Schematic

Slide Show Schematic

Simple.
Powerful.
Not in Excel

Other stuff
What else did I like back then?
The fact that it read my Reflex databases with no problem; it was fast and it made a fairly decent fist of cascading open spreadsheets.

Menu builder.

QPro: Menubuilder.

QPro: Menubuilder. This view is in character based mode

That was the thing that let you redesign the interface. Most products let you do that now. Quattro Pro came with a Lotus 1-2-3 compatible interface which meant that Lotus macros (which were keystroke driven) would also work in Quattro Pro. In addition, Quattro had a macro language that was independent of keystrokes.

Play sounds directly from the spreadsheet. Gimmicky 20 years ago. Achieved via macro syntax: {play name.SND} where SND was digitized sound from RealSound. SND files were small (about 7kb for 1 second).

Links

Lotus Development v Borland
http://en.wikipedia.org/wiki/Lotus_v._Borland
The Lawsuit.

SND files
http://www.oldskool.org/sound/pc/#digitized
http://en.wikipedia.org/wiki/RealSound

Advertisements

About Terence Park

Collections: vinyl records, comic books, paperbacks; I've plenty of them all. I also do spreadsheets.
This entry was posted in General, Trivia and tagged , , , , , , . Bookmark the permalink.

3 Responses to Quattro Pro (by Borland)

  1. Peter says:

    Hi

    Question. How do you apply filters to data? If run qp5.6 in dosbox turbo om my blackberry q10 but I have not found the filtering option yet..

    Thanks!
    Peter

    • Terence Park says:

      Quattro Pro v 5 for DOS
      …didn’t have filters. There were a couple of ways to drill down into data, the first was to navigate through each row that matched your query (noting that non-matching rows remained visible); the second was to extract data via the self-same query.
      I never came across a version 5.6 but would assume it to be similar to version 5.5 for DOS. Version 5.5 for DOS supported multi-page spreadsheets; whereas version 5 had only one page per spreadsheet.

      Quattro Pro 5 for Windows
      …had a sub-program called ‘Data Modelling Desktop’ which offered Cross Tab functionality. The functionality was not dissimilar to Pivot Tables and Filters in Excel. In later versions, it was tweaked to make Quattro more like Excel, however, that functionality was not present in any DOS version I’ve used.

    • Terence Park says:

      Filters was a worthwhile incentive to transition from Lotus (or Quattro) to Excel. Going onto comparisons, the other worthwhile Excel feature, 20 years back, was the ability to assign a name to a formula.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s