Home | Polski Polski
Attached
Go back

Reprinted from Byte 11/1989, pp. 81.

OS/2 Gets a Spreadsheet

The new Excel, an upgrade to the powerful spreadsheet, joins the OS/2 bandwagon. After testing a prerelease version, I came to the conclusion that Excel for OS/2 with Presentation Manager is distinguished from its DOS ancestor less by its feature set than by the underlying benefits of OS/2.

Excel for OS/2 with Presentation Manager
This image can be zoomedExcel for OS/2 with Presentation Manager
Among those benefits are large memory addressing, support for virtual memory, built-in Dynamic Data Exchange (DDE), multitasking, and a richer graphical environment, including more fonts, more accurate screen representation, and an IBM common-user-access-compliant interface. Large memory permits a different working style, in which many spreadsheets are loaded and open at the same time. With multitasking, you can be sorting a database and printing a file in the background while working on Excel in the foreground.

However, operating in single-user mode on an AT-class machine, and without many other PM applications with which to share data, the advantages of OS/2 are not immediately apparent. In fact, even the larger memory addressing (I had 3 megabytes installed, plus room on my disk for virtual memory) didn’t prevent me from getting warning messages that some of my operations were too big and would require giving up Undo in order to proceed.

Excel for Windows is a fine application, distinguished by its graphical power and, through Windows, its ability to link spreadsheets to one another and to other documents. The PM version carries on this tradition, adding support for up to 256 fonts (in both a faster, less-accurate screen mode and a slower but more WYSIWYG representation) and a new Data Consolidate feature that emulates the three-dimensional capabilities that are found in competing spreadsheets.

The new Excel doesn’t permit a single file to contain multiple worksheets, as does Lotus 1-2-3 release 3.0. However, with Data Consolidate, you can “summarize” worksheets by pointing and clicking on areas in each sheet that are then dynamically linked to a summary sheet. To my disappointment, this feature was not intuitive nor well documented.

The facts

Excel for OS/2 with Presentation Manager
$495; upgrade from Windows, $50

Requirements:
IBM PC AT, 80286, PS/2, or compatible with 2.5 megabytes of RAM, OS/2 1.1 Standard Edition or higher, a hard disk drive with 3 megabytes free (not including the space used for OS/2), and EGA or VGA graphics.

Microsoft Corp.
16011 Northeast 36th Way
P.O. Box 97017
Redmond, WA 98073
(206) 882-8080
Inquiry 988.

Other additions in Excel PM are quite minor. A nice menu item called Window Show Clipboard lets you see the contents of the clipboard, and modifications to existing commands permit greater customization of the work environment. New commands necessary to interact with OS/2 (e.g., a menu item to call the Control Task Manager) have been added, while several macro functions have been modified to comply with PM. The file load and save commands will support the 32-character filenames in OS/2 1.2. And Q+E, Microsoft’s new SQL querying tool for Excel, will ship with every copy of the PM version.

In performance, the beta version of Excel PM that I tested was comparable to the Windows version in recalculations – sometimes faster, sometimes slower, but never by more than 10 percent – but its speed was substantially slower in two key areas: file loading and saving, and screen movement. Loading a 600K-byte file under OS/2 took 70 percent longer than under Windows, and a test of scrolling right took 31 percent longer. In all comparable benchmarks, Excel PM was much slower than the 2.x DOS versions of Lotus 1-2-3 (using the same files converted to .XLS format) and was a little slower than Lotus 1-2-3 release 3.0.

Is Excel PM worth it for DOS/Windows users looking to upgrade? When you consider that you will need an 80286 machine or higher (an 80386 really helps), at least 2.5 megabytes of RAM, a large hard disk drive with 12 megabytes of free space, OS/2, and the application itself, the cost may not be justified now. But when OS/2 becomes a standard, and more applications that use multitasking and DDE enter the market, this new Excel will likely be a must-have program.

Andrew Reinhardt



 
Page added on 30th September 2004.

Copyright © 2002-2005 Marcin Wichary
Printable version | Contact | Site map