Lotus Symphony was an integrated software package for creating and editing text, spreadsheets, charts and other documents on the MS-DOS operating systems. It was released by Lotus Development as a follow-on to its popular spreadsheet program, Lotus 1-2-3,[1] and was produced from 1984 to 1992. Lotus Jazz on the Apple Macintosh was a sibling product.
IBM revived the name Lotus Symphony in 2007 for a new office suite based on OpenOffice.org, but the two programs are otherwise unrelated.
History
Lotus 1-2-3 had originally been billed as an integrated product with spreadsheet, database and graphing functions (hence the name "1-2-3"). Other products described as "integrated", such as Ashton-Tate's Framework and AppleWorks, from Apple Computer, normally included word processor functionality. Symphony was Lotus' response.
Overview
Symphony for MS-DOS is a program that loads entirely into memory on startup, and can run as an MS-DOS task on versions of Microsoft Windows (3.x/95/98/ME). Using the Command Prompt, and a .pif file, Symphony can also be used on Windows XP and its successors.[citation needed]
Using ALT+F10 the user can alternate among the five "environments" of the program, each a rendering of the same underlying data. The environments are:
SHEET, a spreadsheet program very similar to 1-2-3
Several "add-in applications" can be "attached" and activated, extending Symphony's capabilities, including a powerful macro manager, a document outliner, a spell-checker, statistics, various communications configurations, and a tutorial, which demonstrates Symphony usage by running macros. The program allows the screen to be split into panes and distinct Windows, showing different views of the underlying data simultaneously, each of which can display any of the five environments. The user is then able to see that changes made in one environment are reflected in others simultaneously, perhaps the package's most interesting feature.
All the data that Symphony handles is kept in spreadsheet-like cells. The other environments—word processing, database, communications, graphics—in essence only change the display format and focus of that data (including available menus, special keys, and functionality), which can be saved and retrieved as .WR1 files.
Symphony's spreadsheet engine was similar to, but not the same as the one used in Lotus 1-2-3, once the most popular of its kind. Additional enhancements included:
The ability to create unique application looking spreadsheets using customizable macro driven menus and display Windows, the result being menu driven applications that, to the user, resembled little of their original spreadsheet heritage.
A rearranged worksheet menu, placing COPY as the first menu item, then the other most frequently used items after that.
Additional @ formula functions building on 1-2-3's spreadsheet only formulas.
Multiple menu systems, retaining 1-2-3's uniquely identified first-character menu items.
The addition of the TAB key to anchor ranges, instead of just using the period key.
The ability to copy "to a location" and end up at that location, instead of at the copy "from location."
Symphony put the power of the spreadsheet at the user's fingertips and used all of the available keys on IBM's 84-key PC keyboard. In this way, the user could use both hands to select menu functions, navigate menus and spreadsheets, as well as, all other Symphony functions by touch. The introduction of the US IBM PC 104-key keyboard and later ergonomic keyboards diluted this advantage.
Compared to other word processors of the day such as MicroproWordStar 3.3, WordPerfect 4.2, and Microsoft Word 2.0, Symphony's word processing environment was simple, but effective and uncomplicated.
Compared to other database programs of the day—Ashton-Tate's dBase III, MDBS Knowledgeman, Borland Paradox 2.0 and Borland Reflex 1.0—Symphony's FORM environment was not as robust, lacking the analytical abilities of Reflex and the pseudo relational power of dBase III. However, it was integrated directly into the spreadsheet and included the ability to "generate" a FORM from spreadsheet fields. The generator would automatically create the database input form, all the underlying spreadsheet architecture, with range names and query fields, turning a simple spreadsheet into an instant database in seconds. 3.0-Symphony extended earlier enhancements with additional add-ons, most notably:
WYSIWYG (what-you-see-is-what-you-get) GUI (graphical user interface) and the addition of mouse support
BASE, the ability to integrate with any dBase IV file, no matter its size.
ExtraK add-on, extending memory capabilities for spreadsheet larger than 4MB.
Like its predecessor Lotus 1-2-3, Symphony contained a reasonably powerful programming language referred to as its "Symphony Command Language (or SCL) ", which could be saved either within a spreadsheet or separately in "libraries" in the form of macros: lists of menu operations, data, and other macro keywords. (One is "menucall," which allows users to call their own menus, embedded into spreadsheets, which behave just like Symphony's own.) Symphony's "learn" mode for macro recording automated this process, helping the end-user to quickly write macros to duplicate repetitive tasks or to go beyond that, without the need to understand computer programming. One of the most significant features of Symphony was the integration of the various modules using this command language. In its day, it was one of the few programs that would be able to log onto a stock market source, select data using dynamic or pre-assigned criteria, place that data into a spreadsheet, perform calculations, then chart the data and print out the results. All of this could take place unattended on a preset schedule.
Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software. 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 in the business market.
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.
WordPerfect (WP) is a word processing application, now owned by Alludo, with a long history on multiple personal computer platforms. At the height of its popularity in the 1980s and early 1990s, it was the dominant player in the word processor market, displacing the prior market leader WordStar.
WordStar is a word processor application for microcomputers. It was published by MicroPro International and originally written for the CP/M-80 operating system, with later editions added for MS-DOS and other 16-bit PC OSes. Rob Barnaby was the sole author of the early versions of the program.
Turbo Pascal is a software development system that includes a compiler and an integrated development environment (IDE) for the Pascal programming language running on CP/M, CP/M-86, and DOS. It was originally developed by Anders Hejlsberg at Borland, and was notable for its extremely fast compilation. Turbo Pascal, and the later but similar Turbo C, made Borland a leader in PC-based development.
SmartSuite is a discontinued office suite from Lotus Software. The company made versions of its office suite for IBM OS/2 and Microsoft Windows.
Lotus Software was an American software company based in Massachusetts; it was "offloaded" to India's HCL Technologies in 2018.
Quattro Pro is a spreadsheet program developed by Borland and now sold by Corel, most often as part of Corel's WordPerfect Office suite.
In computer software, an operating environment or integrated applications environment is the environment in which users run application software. The environment consists of a user interface provided by an applications manager and usually an application programming interface (API) to the applications manager.
The Microsoft Windows Script Host (WSH) is an automation technology for Microsoft Windows operating systems that provides scripting abilities comparable to batch files, but with a wider range of supported features. This tool was first provided on Windows 95 after Build 950a on the installation discs as an optional installation configurable and installable by means of the Control Panel, and then a standard component of Windows 98 and subsequent and Windows NT 4.0 Build 1381 and by means of Service Pack 4. The WSH is also a means of automation for Internet Explorer via the installed WSH engines from IE Version 3.0 onwards; at this time VBScript became means of automation for Microsoft Outlook 97. The WSH is also an optional install provided with a VBScript and JScript engine for Windows CE 3.0 and following and some third-party engines including Rexx and other forms of Basic are also available.
Framework, launched in 1984, was an office suite to run on the (x86) IBM PC and compatibles with the MS-DOS operating system.
DESQview (DV) is a text mode multitasking operating environment developed by Quarterdeck Office Systems which enjoyed modest popularity in the late 1980s and early 1990s. Running on top of DOS, it allows users to run multiple programs concurrently in multiple windows.
Microsoft Works is a discontinued productivity software suite developed by Microsoft and sold from 1987 to 2009. Its core functionality included a word processor, a spreadsheet and a database management system. Later versions had a calendar application and a dictionary while older releases included a terminal emulator. Works was available as a standalone program, and as part of a namesake home productivity suite. Because of its low cost, companies frequently pre-installed Works on their low-cost machines. Works was smaller, less expensive, and had fewer features than Microsoft Office and other major office suites available at the time.
Common User Access (CUA) is a standard for user interfaces to operating systems and computer programs. It was developed by IBM and first published in 1987 as part of their Systems Application Architecture. Used originally in the MVS/ESA, VM/CMS, OS/400, OS/2 and Microsoft Windows operating systems, parts of the CUA standard are now implemented in programs for other operating systems, including variants of Unix. It is also used by Java AWT and Swing.
Paradox is a relational database management system currently published by Corel Corporation.
Q&A was a database and word processing software program for IBM PC–compatible computers published by Symantec and partners from 1985 to 1998. It was written by a team headed by Symantec founder Dr. Gary Hendrix, Denis Coleman, and Gordon Eubanks.
Integrated software is a software for personal computers that combines the most commonly used functions of many productivity software programs into one application.
IBM Lotus Symphony is a discontinued suite of applications for creating, editing, and sharing text, spreadsheet, presentations, and other documents and browsing the World Wide Web. It was first distributed as commercial proprietary software, then as freeware, before IBM contributed the suite to the Apache Software Foundation in 2014 for inclusion in the free and open-source Apache OpenOffice software suite.
Software Publishing Corporation (SPC) was a Mountain View, California-based manufacturer of business software, originally well known for its "pfs:" series of business software products, it was ultimately best known for its pioneering Harvard Graphics business and presentation graphics program.
This page is based on this Wikipedia article Text is available under the CC BY-SA 4.0 license; additional terms may apply. Images, videos and audio are available under their respective licenses.
