From 1-2-3 to Symphony A Functional Comparison A. Commonly Used 1-2-3/Symphony Equivalents (Function key names are shown in square brackets) 1-2-3 Symphony Commands and Functions / [SERVICES] and [MENU] (Also / in SHEET window) @Today @Now (Automatically converted except in macros) Data Distribution Range Distribution Data Fill Range Fill Data Table Range What-If Graph View Graph Preview Graph Save Image-Save Input Range Database Range Period (.) as an anchor TAB (Period works in SHEET window) Print Setup Strings Print Init-String Range Justify DOC window's word wrap Range Label-Prefix Range Label-Alignment Worksheet Erase Yes [SERVICES] New Yes Worksheet Global Default In SHEET: [MENU] Settings Miscellaneous Access System Disk- and [SERVICES] Application Attach DOS.APP and File-Manager (DOS. APP is an Add-in that Lotus sends with Symphony. It allows you to move conveniently between DOS and Symphony without actually exiting Symphony.) Autoexecute macro [SERVICES] Settings Autoload worksheet [SERVICES] Configuration .DRV .SET (For Driver Sets) .WKS .WRK Macros /xc {branch} {location} /xr {return} /xg {branch location} /xi {if condition} {true} {false} /xl {getlabel prompt, location} /xm {menucall macroname} /xn {getnumber prompt, location} /xq {quit} / {menu} or {m} {services} or {s} {BS} {backspace} or {bs} {del} {delete} {ESC} {escape} or {esc} {PgDn} {pgdn} or {bigdown} {PgUp} {pgup} or {bigup} B. Settings Respecification The following 1-2-3 settings are carried over into Symphony: @ Functions Data Distribution Ranges Data Fill Ranges Data Input Cells Data Table (What-If) Ranges Individually set row or column titles Label-Prefix settings Named Ranges Numeric Format settings Recalculation Iterations settings Recalculation Method settings Recalculation Order settings The following need to be respecified in Symphony: Spreadsheet Global Column Width Settings In SHEET window: [MENU] Settings Width (Symphony default is 9) Formulas containing both Adjust so that both do not occur numeric and string in the same formula. There are new expressions string handling capabilities. Split windows [SERVICES] Window Pane Database Data Fill Start, Step and In SHEET window: [MENU] Range Fill Stop values Database ranges entered with In SHEET window: [MENU] Query Settings /Data Query Basic Ranges In FORM window: [MENU] Settings Basic Ranges Data Sort Keys and Order In SHEET window: [MENU] Query Settings (Symphony does not sort Sort-Keys the top row of field names.) In FORM window: [MENU] Settings Sort-Keys Graphs All settings In SHEET window: [MENU] Graph 1st-Settings ... 2nd-Settings In GRAPH window: [MENU] 1st-Settings ... 2nd-Settings Macros Most macros Learn mode or programming with Symphony Command Language. Many functions done with macros in 1-2-3 are done with commands and settings in Symphony. Printing Print Destination [SERVICES] Print Settings Print Margins Print Source Range Setup Strings (Init-Strings) C. Compatible File Formats Symphony's Translate utility is a program allowing you to move data between Symphony and other programs as follows: Source Destination VisiCalc Symphony DIF (Data Interchange Format) Symphony Symphony DIF Symphony dBASE-II dBASE-II Symphony See Introduction to Symphony, Chapter 4, for more information.