Quattro Pro
   HOME

TheInfoList



OR:

Quattro Pro is a
spreadsheet A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cel ...
program developed by
Borland Borland Software Corporation was a computer technology company founded in 1983 by Niels Jensen, Ole Henriksen, Mogens Glad and Philippe Kahn. Its main business was the development and sale of software development and software deployment product ...
and now sold by
Corel Cascade Parent Limited, doing business as Alludo (pronounced like "all you do"), is a Canadian software company headquartered in Ottawa, Ontario, specializing in graphics processing. Formerly called the Corel Corporation ( ; from the abbreviation ...
, most often as part of Corel's WordPerfect Office suite.


Characteristics

Historically, Quattro Pro used keyboard commands close to those of
Lotus 1-2-3 Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software (later part of IBM). It was the first killer application of the IBM PC, was hugely popular in the 1980s, and significantly contributed to the success of IBM PC-compatibles i ...
. While it is commonly said to have been the first program to use
tabbed sheet In interface design, a tab is a graphical user interface object that allows multiple documents or Panel (computer software), panels to be contained within a single window (computing), window, using tabs as a navigational widget for switching ...
s,
Boeing Calc Boeing Calc was a spreadsheet package written by Boeing Computer Services, an independent subsidiary of aviation manufacturer Boeing. It had originally been developed as an in-house accounting tool, but was launched as a commercial product in Apri ...
actually utilized tabbed sheets earlier. It currently runs under the Windows operating system. For years Quattro Pro had a comparative advantage, in regard to maximum row and column limits (allowing a maximum worksheet size of one million rows by 18,276 columns). This avoided the 65,536 row by 256 column spreadsheet limitations inherent to Microsoft Excel (prior to Excel 2007). Even with the maximum row advantage, Quattro Pro has been a distant second to Excel, in terms of sales numbers, since approximately 1996 to the present. When version 1.0 was in development, it was codenamed "Buddha" since it was meant to "assume the Lotus position", #1 in the market. When the product was launched in 1988, its original name, suggested to Mr. Kahn by Senior VP, Spencer Leyton at a Vietnamese restaurant in Santa Cruz, was Quattro (the
Italian Italian(s) may refer to: * Anything of, from, or related to the people of Italy over the centuries ** Italians, an ethnic group or simply a citizen of the Italian Republic or Italian Kingdom ** Italian language, a Romance language *** Regional Ita ...
word for "four", a play on being one step ahead of "1-2-3"). Borland changed the name to Quattro Pro for its 1990 release. The common file extension of Quattro Pro spreadsheet file is .qpw, which it has used since version 9. Quattro Pro versions 7 and 8 used .wb3, version 6 used .wb2, version 5 used .wb1, and DOS versions used .wq2 and .wq1.


Origins

The original Borland Quattro electronic spreadsheet was a DOS program, the initial development of which was done by three Eastern Europeans, one of whom, the Hungarian Lajos Frank, was later hired by Microsoft. An article appeared in ''PC Week'' in 1985, quoting a maker of spreadsheet templates saying that he was in close contact with Borland, and that Borland was developing a spreadsheet. At the time, there was absolutely no such development being undertaken by Borland. After they both read the article, Philippe Kahn and Spencer Leyton had a casual conversation where they joked, half seriously, about perhaps developing a spreadsheet to compete with Lotus Development's 1-2-3. That led to Mr. Kahn setting an appointment with an agent for some Eastern European software developers, Robert Stein of Andromeda Software, which was also involved with the game ''
Tetris ''Tetris'' (russian: link=no, Тетрис) is a puzzle video game created by Soviet software engineer Alexey Pajitnov in 1984. It has been published by several companies for multiple platforms, most prominently during a dispute over the approp ...
''. That led to an agreement negotiated by Mr. Leyton and Mr. Stein, providing for the development of the original Quattro. Quattro was written in
assembly language In computer programming, assembly language (or assembler language, or symbolic machine code), often referred to simply as Assembly and commonly abbreviated as ASM or asm, is any low-level programming language with a very strong correspondence be ...
and
Turbo C Turbo C is a discontinued integrated development environment (IDE) and compiler for the C programming language from Borland. First introduced in 1987, it was noted for its integrated development environment, small size, fast compile speed, compr ...
, principally by
Adam Bosworth Adam Bosworth is a former Vice President of Product Management at Google Inc. from 2004–2007; prior to that, he was senior VP Engineering and Chief Software Architect at BEA Systems responsible for the engineering efforts for BEA's Framework Divi ...
, Lajos Frank, and Chuck Batterman. It was praised mainly for superior graphics on DOS. Borland acquired a replacement product called "Surpass", written in
Modula-2 Modula-2 is a structured, procedural programming language developed between 1977 and 1985/8 by Niklaus Wirth at ETH Zurich. It was created as the language for the operating system and application software of the Lilith personal workstation. It w ...
. The main designers and programmers of Surpass were also hired by Borland to turn Surpass into Quattro Pro: Bob Warfield, Dave Anderson, Weikuo Liaw, Bob Richardson and Tod Landis. They joined other Borland programmers including Chuck Batterman, Lajos Frank, Tanj Bennett, Rich Reppert and Roger Schlafly. Bob Warfield later became Vice President of R&D at Borland. All eventually left Borland. Quattro Pro shipped in the final quarter of 1989. The Borland main office was near the epicenter of the Loma Prieta earthquake and the building was severely damaged when large and heavy air conditioners on the roof of Borland's main building were thrown upward by the quake, and came crashing down upon the
glulam Glued laminated timber, commonly referred to as glulam, is a type of structural engineered wood product constituted by layers of dimensional lumber bonded together with durable, moisture-resistant structural adhesives so that all of the grain ru ...
beams running across the top of the building. The beams were damaged to the point where they required injections of epoxy in order to make them sturdy enough to support the building again. In addition, the sprinkler system was triggered. The building was closed for months. All the computers were removed, placed on the tennis courts, washed down (acoustic ceilings rained gray mush onto everything when the sprinklers ran) and dried with hair dryers. Those that booted up were put to work. Quattro Pro finished final
quality assurance Quality assurance (QA) is the term used in both manufacturing and service industries to describe the systematic efforts taken to ensure that the product(s) delivered to customer(s) meet with the contractual and other agreed upon performance, design ...
testing and was sent to manufacturing from those computers running on the tennis courts in the (fortunately) sunny and dry autumn weather.


Lawsuit

Some have claimed that Quattro Pro was the first to use the tabbed notebook metaphor, but another spreadsheet,
Boeing Calc Boeing Calc was a spreadsheet package written by Boeing Computer Services, an independent subsidiary of aviation manufacturer Boeing. It had originally been developed as an in-house accounting tool, but was launched as a commercial product in Apri ...
, used tabs to multiple sheets, and allowed three-dimensional references before Quattro Pro was on the market. (Boeing Calc was so slow that its multiple sheet capabilities were barely usable.) Quattro Pro was the subject of a major lawsuit by Lotus against Borland. Lotus argued that Quattro could not copy Lotus 1-2-3's menus. Borland supplied the 1-2-3 menus as an alternative because keystroke compatibility was needed in order to run macros in 1-2-3 worksheets. Borland argued that most cars operate the same, but they are not necessarily made the same. So, Lotus could not rationally "own" the way its program behaved. The district court ruled in favor of Lotus, but the appellate court ruled that the 1-2-3 menus were functional and not copyrightable. The case went all the way to the U.S. Supreme Court which split 4 to 4 (
Justice Stevens John Paul Stevens (April 20, 1920 – July 16, 2019) was an American lawyer and jurist who served as an associate justice of the Supreme Court of the United States from 1975 to 2010. At the time of his retirement, he was the second-olde ...
recused himself). This left the lower court ruling intact, which was a victory for Borland. However, the broader issue of whether a company can own and protect the way its program behaves remained unresolved. By the time the case was resolved, Borland no longer owned Quattro Pro. Borland sold the spreadsheet to
Novell Novell, Inc. was an American software and services company headquartered in Provo, Utah, that existed from 1980 until 2014. Its most significant product was the multi-platform network operating system known as Novell NetWare. Under the lead ...
six months before the final decision was handed down.


Quattro Pro for Windows

Quattro Pro began as a
DOS DOS is shorthand for the MS-DOS and IBM PC DOS family of operating systems. DOS may also refer to: Computing * Data over signalling (DoS), multiplexing data onto a signalling channel * Denial-of-service attack (DoS), an attack on a communicat ...
program (like Lotus 1-2-3) but with the growing popularity of Windows from Microsoft, a Windows version of Quattro needed to be written. There was almost nothing from the DOS code that could be moved to the Windows project, so the Quattro Pro for Windows (QPW) was written from scratch. Both the QPW and
Paradox A paradox is a logically self-contradictory statement or a statement that runs contrary to one's expectation. It is a statement that, despite apparently valid reasoning from true premises, leads to a seemingly self-contradictory or a logically u ...
for Windows codebases (the latter being another Borland database application) were based on Borland's internal pilot project with object oriented UI code for Windows. This project ran simultaneously with the Borland language group investigating the desirability of a
C++ C++ (pronounced "C plus plus") is a high-level general-purpose programming language created by Danish computer scientist Bjarne Stroustrup as an extension of the C programming language, or "C with Classes". The language has expanded significan ...
compiler, and the company decided to make a bet on C++. However, the C++ compiler was not ready at first, and OO code for both projects was started in C with OO emulation through macros. As the Borland Turbo C++ compiler became available internally the projects converted to using C++. Charlie Anderson was put in charge of the project and he soon had Istvan Cseri, Weikuo Liaw,
Murray Low Murray may refer to: Businesses * Murray (bicycle company), an American manufacturer of low-cost bicycles * Murrays, an Australian bus company * Murray International Trust, a Scottish investment trust * D. & W. Murray Limited, an Australian who ...
,
Steven Boye Stephen or Steven is a common English first name. It is particularly significant to Christians, as it belonged to Saint Stephen ( grc-gre, Στέφανος ), an early disciple and deacon who, according to the Book of Acts, was stoned to death; ...
,
Barry Spencer Barry may refer to: People and fictional characters * Barry (name), including lists of people with the given name, nickname or surname, as well as fictional characters with the given name * Dancing Barry, stage name of Barry Richards (born c. 195 ...
, Alan Bush,
Dave Orton David E. Orton (born 1955) is an American engineering executive and the CEO of GEO Semiconductor Inc. Orton earned a BS in mathematics and economics at Wake Forest University, and a MS in electrical engineering from Duke University. He worked in t ...
,
Bernie Vachon Bernie may refer to: Places in the United States * Bernie, Missouri, a city * Griffithsville, West Virginia, also called Bernie People * Bernie (given name) ** Bernie Sanders, United States senator and 2016 and 2020 Democratic presidential candi ...
,
Anson Lee Anson may refer to: People * Anson (name), a give name and surname ** Anson family, a British aristocratic family with the surname Place names ;United States * Anson, Indiana * Anson, Kansas * Anson, Maine ** Anson (CDP), Maine * Anson, Missouri * ...
, Tod Landis, Gordon Ko and
Chuck Batterman Chuck is a masculine given name or a nickname for Charles or Charlie. It may refer to: People Arts and entertainment * Chuck Alaimo, American saxophonist, leader of the Chuck Alaimo Quartet * Chuck Barris (1929–2017), American TV producer * C ...
working on the project. Other engineers joined later. Eventually the team numbered nearly 20. The object model was inspired by the
NeXT Next may refer to: Arts and entertainment Film * ''Next'' (1990 film), an animated short about William Shakespeare * ''Next'' (2007 film), a sci-fi film starring Nicolas Cage * '' Next: A Primer on Urban Painting'', a 2005 documentary film Lit ...
object model, modified by Mr. Cseri. Mr. Liaw and Mr. Spencer were in charge of the spreadsheet engine (written in assembly language) while Mr. Low wrote a large chunk of the UI. The product was internally codenamed "
Thor Thor (; from non, Þórr ) is a prominent god in Germanic paganism. In Norse mythology, he is a hammer-wielding æsir, god associated with lightning, thunder, storms, sacred trees and groves in Germanic paganism and mythology, sacred groves ...
" for the Norse god of Thunder. QPW featured two major innovations. First, it was the first Windows spreadsheet with multiple pages with cells that could be linked together seamlessly, a feature from Quattro Pro which QPW extended. Second, it was the first released Windows program to have an attribute menu (or property pane) available by right-clicking on the object. Although this idea was first seen on the
Xerox Alto The Xerox Alto is a computer designed from its inception to support an operating system based on a graphical user interface (GUI), later using the desktop metaphor. The first machines were introduced on 1 March 1973, a decade before mass-market ...
, the idea had not been implemented on a major Windows program. Paradox for Windows shared this feature, and it was shown off by
Phillipe Kahn Philippe Kahn (born March 16, 1952) is an engineer, entrepreneur and founder of four technology companies: Borland, Starfish Software, LightSurf Technologies, and Fullpower Technologies. Kahn is credited with creating the first camera phone, ...
at a Paradox user conference over a year before QPW was released. Both these ideas became widespread in the software industry. QPW was one of the first big applications written in C++ on Windows, and it pushed the Borland C++ compiler to the limit. One reason why the Borland C++ Compiler was so good was that it had to compile and link the massive QPW code base successfully. The technical risk of the QPW project was immense. The object model was untried and might not have worked for a spreadsheet. The user interface (UI) was new (for Windows programs at least). No one knew if the C++ compiler could generate fast enough code. As it turned out, the program worked. It was fast, it was close in feature set to Lotus 123 and Excel, and the "right-click for properties" user design was reasonably understandable. At one point, it was hoped that QPW and Paradox for Windows would be able to share a common object model. That proved impossible despite serious thought and design efforts. QPW was finally released in September 1992. The Quattro Pro marketing team had chosen to bundle both Quattro Pro for DOS and Quattro Pro for Windows in the same box labeled "WIN-DOS" at a price of $495. Customers and reviewers expecting a pure Windows application responded with confusion and outrage, believing the product was merely a DOS application with windowing capabilities. Shortly thereafter QPW was re-packaged by itself and priced $129, receiving accolades for Borland's long-delayed pure Windows spreadsheet and its popular price. Eventually it sold well (after the price was slashed to just $49 a copy). Work was started immediately on a new version with a brand new team of engineers led by
Joe Ammirato Joe or JOE may refer to: Arts Film and television * ''Joe'' (1970 film), starring Peter Boyle * ''Joe'' (2013 film), starring Nicolas Cage * ''Joe'' (TV series), a British TV series airing from 1966 to 1971 * ''Joe'', a 2002 Canadian animated ...
; including
Bret Gillis Bret or BRET may refer to: People and fictional characters * Bret (given name), a personal name, including a list of people and fictional characters * Bret (surname), a list of people Other uses * a regional name for either the brill or the tu ...
and
Peter Weyzen Peter may refer to: People * List of people named Peter, a list of people and fictional characters with the given name * Peter (given name) ** Saint Peter (died 60s), apostle of Jesus, leader of the early Christian Church * Peter (surname), a sur ...
. Borland purchased DataPivot from Brio Technology to add a new feature to the program. Colin Glassey came from Brio to help with the integration of that technology. After a year and the merging of the old team and the new team, QPW 5 was released (the reason for the jump in version number had to do with keeping up with the DOS version as well as it looked good). QPW 5 sold well also, though the
Microsoft Excel Microsoft Excel is a spreadsheet developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro (comp ...
+ Word combination was gaining steam. Work then started on version 6 (now with
Steven Boye Stephen or Steven is a common English first name. It is particularly significant to Christians, as it belonged to Saint Stephen ( grc-gre, Στέφανος ), an early disciple and deacon who, according to the Book of Acts, was stoned to death; ...
as project lead). Midway through the development of version 6 a strategic decision to work closely with the WordPerfect word processor was made. It was a direct attempt to push back at the Microsoft Office one-two punch of
Microsoft Word Microsoft Word is a word processing software developed by Microsoft. It was first released on October 25, 1983, under the name ''Multi-Tool Word'' for Xenix systems. Subsequent versions were later written for several other platforms includin ...
and Microsoft Excel. The other big issue with Version 6 was the advent of
Windows 95 Windows 95 is a consumer-oriented operating system developed by Microsoft as part of its Windows 9x family of operating systems. The first operating system in the 9x family, it is the successor to Windows 3.1x, and was released to manufacturin ...
. This was a significant modification to the Windows operating system with a major change to user interface guidelines. In an odd set of events,
Novell Novell, Inc. was an American software and services company headquartered in Provo, Utah, that existed from 1980 until 2014. Its most significant product was the multi-platform network operating system known as Novell NetWare. Under the lead ...
purchased both WordPerfect Corporation and the Quattro Pro code base and team of engineers from Borland. Novell was going to try to be a real competitor to Microsoft. Although Version 6 was released and some effort was made to unify the user interface between WordPerfect and QPW, the effort was far from complete. In another lawsuit, Novell claims that Microsoft had "deliberately targeted and destroyed" its WordPerfect and QuattroPro programs to protect its Windows operating system monopoly. The US Supreme Court refused to halt the antitrust lawsuit in March 2008.


Novell's exit

The release of Windows 95 in August 1995 was the beginning of the end for Novell and its plans to compete with Microsoft. Not only did Microsoft release a new operating system, but Microsoft also released new versions of Word and Excel to accompany it. Sales of Novell PerfectOffice (and Lotus applications as well) sank to almost nothing while sales of the Microsoft products were huge. Within three months, Novell announced they were going to sell their applications to someone (eventually that proved to be
Corel Cascade Parent Limited, doing business as Alludo (pronounced like "all you do"), is a Canadian software company headquartered in Ottawa, Ontario, specializing in graphics processing. Formerly called the Corel Corporation ( ; from the abbreviation ...
). By mid-1996, Microsoft had 95% of the market for business applications. , Microsoft still dominates the market for Windows business application software, although Quattro Pro and WordPerfect, which pre-dated the MS Office 4.2 suite, are still both updated and sold.


File formats

Quattro Pro file formats use various
filename extensions A filename extension, file name extension or file extension is a suffix to the name of a computer file (e.g., .txt, .docx, .md). The extension indicates a characteristic of the file contents or its intended use. A filename extension is typically ...
, including WB1, WB2, WB3, wq1 and wq2; some of these (WB2, wq1, and wq2) may open in the desktop applications of
Collabora Online Collabora Online is an open source online office suite that can be integrated with any web application, it is developed by Collabora Productivity, a division of Collabora. Collabora Online has LibreOffice at its core and allows for collaborative ...
,
LibreOffice LibreOffice () is a free and open-source productivity software, office productivity software suite, a project of The Document Foundation (TDF). It was fork (software development), forked in 2010 from OpenOffice.org, an open-sourced version of t ...
or
Apache OpenOffice Apache OpenOffice (AOO) is an open-source office productivity software suite. It is one of the successor projects of OpenOffice.org and the designated successor of IBM Lotus Symphony. It is a close cousin of LibreOffice, Collabora Online and N ...
and then be saved into the OpenDocument format or other file formats, Microsoft dropped support for Quattro Pro file formats after Office 2007.


Version history

* 1989: Quattro Pro 1.0 * 1991: Quattro Pro 2.0 * 1992: Quattro Pro 4.0 for DOS * 1992: Quattro Pro for Windows 1.0 - (''also in Borland Office for Windows (1993)'') * 1993: Quattro Pro for Windows 5.0 - (''also in Borland Office 2.0 for Windows'') * 1994: Quattro Pro for Windows 6.0 (''part of Novell PerfectOffice 3.0'') * 1996: Quattro Pro 7 (''part of Corel WordPerfect Suite 7'') * 1998: Quattro Pro 8 (''part of Corel WordPerfect Suite 8'') * 2000: Quattro Pro 9 (''part of Corel WordPerfect Office 2000'') * 2002: Quattro Pro 10 (''part of Corel WordPerfect Office 2002'') * 2003: Quattro Pro 11 (''part of Corel WordPerfect Office 11'') * 2004: Quattro Pro 12 (''part of Corel WordPerfect Office 12'') * 2006: Quattro Pro X3 (''part of Corel WordPerfect Office X3'') * 2008: Quattro Pro X4 (''part of Corel WordPerfect Office X4'') * 2010: Quattro Pro X5 (''part of Corel WordPerfect Office X5'') * 2012: Quattro Pro X6 (''part of Corel WordPerfect Office X6'') * 2014: Quattro Pro X7 (''part of Corel WordPerfect Office X7'') * 2016: Quattro Pro X8 (''part of Corel WordPerfect Office X8'') * 2018: Quattro Pro X9 (''part of Corel WordPerfect Office X9'') * 2020: Quattro Pro 2020 (''part of Corel WordPerfect Office 2020'')


See also

* More history of Surpass (pre-Quattro Pro code base) *
Comparison of spreadsheet software Spreadsheet is a class of application software design to analyze tabular data called "worksheets". A collection of worksheets is called a "workbook". Online spreadsheets do not depend on a particular operating system but require a standards-compli ...
*
Office Open XML software This is an overview of software support for the Office Open XML format, a document file format for saving and exchanging editable office documents. The list here is not exhaustive. ECMA-376 1st edition implementations The ECMA-376 1st edition ...


References

{{Spreadsheets Spreadsheet software Borland software DOS software Spreadsheet software for Windows 1988 software Corel software Assembly language software