Hotline Q & A SYMPHONY The following are answers to questions commonly asked by our dealers and test sites about Symphony's capabilities. FILE HANDLING Q. When I do a File Retrieve, the file name extensions are .WRK for both worksheet and document files. Am I doing File Save correctly? A. Yes. Symphony gives the .WRK file name extension to both spreadsheets and documents. As does 1-2-3, Symphony uses .PIC and .PRN file name extensions to indicate graph-image and print files respectively. Q. When accessing a directory through File Retrieve or File Save, [23;1H[J Key S or to continue[23;30H!s [23;1H[J the ESC key does not erase the current directory. A. To erase the current directory name, simply press [ESC] twice. This allows you to type in the name of another sub-directory. WORD PROCESSING Q. In a DOC window, there are times when word wrap doesn't seem to work. Why? A. Word wrap is disabled when overstrike INS is turned on, or when justification is set to NONE. Press [INSERT] to turn off overstrike mode or change the justification in the format line. Q. Why are non-left aligned labels considered to be non-text, i.e., why can't they be edited in word processing? A. Centered (^) and right-aligned labels (") use leading spaces. The Symphony program would need to be significantly larger to handle these labels as text. Q. Values entered in a SHEET window cannot be edited in a DOC window. A. True. The worksheet values you entered in SHEET are protected. SPREADSHEET Q. When printing spreadsheets, long labels are truncated at the column width. A. True. When defining an output range, the entire visible portion of the labels must be highlighted. Q. Where are the global options? A. Press [Menu] and select Settings to establish column width, recalculation mode, label prefix, etc. Q. How do I transfer a row to a column without using DIF? A. Use Symphony's new Range Transpose command. Q. Will there be a function for TIME calculation? A. There are several. @TIME returns the serial value of a time of day. @TIMEVALUE returns a serial value of a time entered as a string. There are also @HOUR, @MINUTE, and @SECOND, which will accept a serial value, and return the corresponding time value. Q. I'm using the range name "1st" in my worksheet, but Symphony will not allow me to use @ functions involving that range. A. Correct. For computational purposes, range names cannot begin with a number, but Symphony will accept a range name like "1st" for move, erase, and copy commands. GRAPHING Q. How do I explode the Pie Charts? A. By assigning a B range for the graph settings, and giving a value of 100 to 107 to the section you want exploded. Q. How do I do a log/semi-log scale graph? A. By hitting the daily double at Aqueduct! But seriously...Symphony has built this into its graph capabilities. Select Graph 2nd Settings X-Axis Type Logarithmic. Do the same for the Y-Axis if appropriate. FORMS/DATABASE Q. What is the parse review range? A. This is an area that Symphony uses to store any data that does not match the criteria established by a form definition. An example of such data would be the salutation and login sequence which remains on the screen during a communications session with a mainframe. Q. Has the Data Distribution command been eliminated from Symphony? A. Not at all. It can now be found under Range Distribution. Q. I'm creating a mailing list with Symphony, but it will not accept the part of the formula I've used to reference zip codes. A. Symphony's string handling capabilities are one of its nicest features, but it still sees numbers the same way as 1-2-3 does. To create a formula that involves columns of numbers as well as text, use the @STRING function for any numerical data. COMMUNICATIONS Q. Symphony's Settings Name Phone-and-Login sequence doesn't work with my Hayes Smartmodem 1200. A. Check to be sure that dip-switch number six is set to ON -- the up position. Q. Why does my monitor display two characters for every one I strike? A. Check your COMM Settings Sheet to be sure that Echo is set to OFF. Q. When I dial a remote computer, I hear the phone ring, and I hear the high pitched sound that indicates that I've reached the computer, but I can't connect. A. You're transmitting at different baud rates. Find out the baud rate of the computer you're trying to access and adjust your own baud rate accordingly -- probably downward. The two most common baud rates between computers are 300 and 1200. SYMPHONY COMMAND LANGUAGE Q. Can I turn my screen off while the macro is executing? A. Yes. The new {paneloff} command will surpress the display of the control panel, and the {windowsoff} command will supress the window displays. Hotline Q & A SYMPHONY The following are answers to questions commonly asked by our dealers and test sites about Symphony's capabilities. FILE HANDLING Q. When I do a File Retrieve, the file name extensions are .WRK for both worksheet and document files. Am I doing File Save correctly? A. Yes. Symphony gives the .WRK file name extension to both spreadsheets and documents. As does 1-2-3, Symphony uses .PIC and .PRN file name extensions to indicate graph-image and print files respectively. Q. When accessing a directory through File Retrieve or File Save, the ESC key does not erase the current directory. A. To erase the current directory name, simply press [ESC] twice. This allows you to type in the name of another sub-directory. WORD PROCESSING Q. In a DOC window, there are times when word wrap doesn't seem to work. Why? A. Word wrap is disabled when overstrike INS is turned on, or when justification is set to NONE. Press [INSERT] to turn off overstrike mode or change the justification in the format line. Q. Why are non-left aligned labels considered to be non-text, i.e., why can't they be edited in word processing? A. Centered (^) and right-aligned labels (") use leading spaces. The Symphony program would need to be significantly larger to handle these labels as text. Q. Values entered in a SHEET window cannot be edited in a DOC window. A. True. The worksheet values you entered in SHEET are protected. SPREADSHEET Q. When printing spreadsheets, long labels are truncated at the column width. A. True. When defining an output range, the entire visible portion of the labels must be highlighted. Q. Where are the global options? A. Press [Menu] and select Settings to establish column width, recalculation mode, label prefix, etc. Q. How do I transfer a row to a column without using DIF? A. Use Symphony's new Range Transpose command. Q. Will there be a function for TIME calculation? A. There are several. @TIME returns the serial value of a time of day. @TIMEVALUE returns a serial value of a time entered as a string. There are also @HOUR, @MINUTE, and @SECOND, which will accept a serial value, and return the corresponding time value. Q. I'm using the range name "1st" in my worksheet, but Symphony will not allow me to use @ functions involving that range. A. Correct. For computational purposes, range names cannot begin with a number, but Symphony will accept a range name like "1st" for move, erase, and copy commands. GRAPHING Q. How do I explode the Pie Charts? A. By assigning a B range for the graph settings, and giving a value of 100 to 107 to the section you want exploded. Q. How do I do a log/semi-log scale graph? A. By hitting the daily double at Aqueduct! But seriously...Symphony has built this into its graph capabilities. Select Graph 2nd Settings X-Axis Type Logarithmic. Do the same for the Y-Axis if appropriate. FORMS/DATABASE Q. What is the parse review range? A. This is an area that Symphony uses to store any data that does not match the criteria established by a form definition. An example of such data would be the salutation and login sequence which remains on the screen during a communications session with a mainframe. Q. Has the Data Distribution command been eliminated from Symphony? A. Not at all. It can now be found under Range Distribution. Q. I'm creating a mailing list with Symphony, but it will not accept the part of the formula I've used to reference zip codes. A. Symphony's string handling capabilities are one of its nicest features, but it still sees numbers the same way as 1-2-3 does. To create a formula that involves columns of numbers as well as text, use the @STRING function for any numerical data. COMMUNICATIONS Q. Symphony's Settings Name Phone-and-Login sequence doesn't work with my Hayes Smartmodem 1200. A. Check to be sure that dip-switch number six is set to ON -- the up position. Q. Why does my monitor display two characters for every one I strike? A. Check your COMM Settings Sheet to be sure that Echo is set to OFF. Q. When I dial a remote computer, I hear the phone ring, and I hear the high pitched sound that indicates that I've reached the computer, but I can't connect. A. You're transmitting at different baud rates. Find out the baud rate of the computer you're trying to access and adjust your own baud rate accordingly -- probably downward. The two most common baud rates between computers are 300 and 1200. SYMPHONY COMMAND LANGUAGE Q. Can I turn my screen off while the macro is executing? A. Yes. The new {paneloff} command will surpress the display of the control panel, and the {windowsoff} command will supress the window displays. E_NUMBER,TODAY}/ÿ}'{con