Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Friday, June 26, 2020

Quattro Pro

Quattro Pro was a spreadsheet utility, originally developed by Borland Software. It was renamed to Corel Quattro Pro when Corel purchased it. The features that lacked in the previous Quattro Pro have been included in its successor, the WordPerfect Office Suite.

Quattro Pro was designed as a contender for the Microsoft Office Excel and for the Lotus 1-2-3 alternatives.

Borland started in spreadsheets in 1987 with a product called Quattro. Word has it that the internal code name was Buddha because the program was intended to “assume the Lotus position” in the market. Borland changed the name to Quattro Pro for its 1990 release.

Similar to Lotus 1-2-3, Quattro Pro was first shipped and released as a DOS program, and was later rewritten to be adapted to the Windows platform.

In the fall of 1989, Borland began shipping Quattro Pro, which was a more powerful product that built upon the original Quattro and trumped 1-2-3 in just about every area.

In 1991 Borland ranked best Quattro Pro beats Lotus 1-2-3. Two industry studies objectively confirm the facts: Customers rank Borland best among software companies, and Quattro® Pro outperforms all Lotus® spreadsheets.

Like Lotus, Borland was slow to jump on the Windows bandwagon. When Quattro Pro for Windows finally shipped in the fall of 1992, however, it provided some tough competition for the other two Windows spreadsheets, Excel 4.0 and 1-2-3 Release 1.1 for Windows. Since about 1996 Quattro pro has run a distant second to Excel’s market domination.

In 1994, Novell purchased WordPerfect International and Borland’s entire spreadsheet business. In 1996, WordPerfect and Quattro Pro were both purchased by Corel Corporation.

Corel Quattro Pro is a spreadsheet application used to process business and financial transactions of various kinds. To carry its various tasks, Corel Quattro Pro organizes each one of its notebooks into worksheets.
Quattro Pro

Saturday, September 28, 2019

Early history of Lotus 1-2-3

Lotus 1-2-3 made it easier to use spreadsheets and it added integrated charting, plotting and database capabilities. Lotus 1-2-3 established spreadsheet software as a major data presentation package as well as a complex calculation tool.

Development of Lotus 1-2-3 is closely tied to VisiCalc. Mitchell Kapor worked as a project manager in VisiCalc. He left VisiCalc in 1981, and together with Jonathan Sachs, founded a company called Lotus.

Before he cofounded Lotus, Kapor disclosed and offered Personal Software (VisiCorp) his initial Lotus program. Supposedly VisiCorp executives declined the offer because Lotus 1-2-3's functionality was "too limited".

They chose IBM PC as their platform, which later proved to be a good move. Lotus 1-2-3 enabled chart creation, as well as some database capabilities. It was the first program that supported operations on call ranges, cell naming and macros. Lotus 1-2-3‘s original release date was on January 26, 1983.

Lotus 1-2-3 was presented to the public and, according to the testimony of the PC World magazine, it surpassed VisiCalc by the number of copies sold by October 1983. By April 1987, Lotus Development delivered 2.5 million copies of their software for personal computers (Lotus 1-2-3 was not the only application they developed) to 65 countries. Lotus 1-2-3 was the leading spreadsheet of DOS era.
Early history of Lotus 1-2-3

Sunday, April 8, 2018

Microsoft Excel

Microsoft Excel is perhaps the most popular spreadsheet use both in business and in universities. The first electronic spreadsheet dates back to 1969 when Rene Pardo and Remy Landau, then recent graduates from Harvard University, created LANPAR (LANguage for Programming Arrays at Random). It was invented to solve a problem that Bell Canada and AT&T had at the time.

The first spreadsheet on a personal computer was called VisiCalc (short for visible calculator) and was created by Daniel Bricklin and Bob Frankston in 1978. Bricklin, a Harvard Business School student, was looking for an easier way to conduct a case study.

He envisioned “an electronic blackboard and electronic chalk in a classroom”. He recruited Frankston to help him write the code. VisiCalc was an instant success and was one of the first “killer apps”.

By early 1980s, Lotus 1-2-3 was the leading spreadsheet. Lotus had bought and then discontinued VisiCalc. Borland’s Quattro Pro was another well-known product at that time.

In 1985, Microsoft Corporation came up with Excel for the Macintosh computer. This product was remarkable for its use pull down-menus and a point and click device called a mouse. Other spreadsheets use a command line interface that required knowledge of cryptic DOS command.

Microsoft Excel
When Microsoft named its spreadsheet software “Excel,” it apparently did not now that Manufacturers Hanover Trust already had an automated banking program called Excel. As part of the settlement for trademark infringement, Microsoft agreed to refer always to its product as Microsoft Excel.

Pivot tables are the single most powerful feature in all of Excel. They came along during the 90s when Microsoft and Lotus were locked in a bitter battle for dominance of the spreadsheet market. The race to continually add enhanced features to their respective products during the mid90s led to many incredible features, but none as powerful as the pivot table.
Microsoft Excel

Popular Posts

Selected articles