Answers to your questions about Lotus products. (Q&A) (spelling checker, using data table command, page advances, file-error message, summing a range of data, bar graphs, converting formulas, translating DIF files, memory decreases, using multiple criteria, saving files, using nested conditions, contest)

ANSWERS TO YOUR QUESTIONS ABOUT LOTUS PRODUCTS

Q&A REVISITED

ANOTHER WAY TO ATTACH

SPELLING CHECKER In the June 1988 issue, Joanna Roush asked if there is some way of deciding whether to attach Symphony Spelling Checker when she loads Symphony, considering the possibility of getting a flashing Mem indicator is she works on a large worksheet. You told her that she could enter one of the following commands at the DOS prompt: access -a speller symphony -a speller

There is an easier method for attaching and invoking spelling Checker. This method also eliminates the memory-full problems that occur if you load a large worksheet after Spelling Checker is attached. However, it requires several steps to set up.

Instead of having Symphony automatically attach the specific application, configure Symphony to automatically attach the Macro Library Manager: Select SERVICES Configuration Other Application Set 1 (or the next available number), indicate MACROMGRAPP, and select No Quit Update Quit.

The next step establishes and saves the macro library LIBR10.MLB in the default data directory. Enter the labels as shown in the example below.

Assign the range names by selecting MENU Range Name Labels Right and indicating range A1.A7. Select SERVICES Macros Save, enter LIBR10.MLB, enter range A1.B7, and select No.

The next step creates the file WORKNAME. The file must contain the following macro:

Assign the range name by selecting MENU Range Name Labels Right and indicating cell A1. Once you name the macro, select SERVICES Settings AutoExecute Set, indicate auto, and select Quit. The file WORKNAME is automatically loaded after you load Symphony. When this file is retrieved, auto starts the Macro Library Manager, loads LIBR10.MLB, and executes the SERVICES New Yes command to create a new worksheet. Save the file by selecting SERVICES File Save and indicating the name WORKNAME. Select SERVICES Configuration Auto, specify WORKNAME to load automatically, and select Update Quit.

To use the macros contained in the library, make sure you're working in a DOC window, then hold down the MACRO key (Alt on most computers) and press the macro letter. The first macro (MACRO-S) moves the cursor to the windowhs top-left corner and determines whether Spelling Checker is currently attached. If not, the macro attaches the application. The second macro (MACRO-Q) detaches the application.

If you've done what's been described above the following happens automatically each time you load symphony. (1) Symphony loads the Macro Library Manager into memory; (2) Symphony retrieves the file WORKNAME; (3) the autoexecute macro auto starts running; (4) the macro library loads LIBR10.MLB into memory.

At this point, attach Spelling Checker by pressing MACRO-S. To detach Spelling Checker, press MACRO-Q George Ritter Oak Ridge, Tenn.

USE DATA TABLE …