Download F9 User Guide

D. Using F9 with Lotus 1-2-3
When importing older spreadsheets, the Lotus 1-2-3 ’97 Add-in will edit the
F9 formulae to provide all of the parameters correctly and removes the tag,
so older worksheets should function without editing.
All Lotus Users
Lotus 1-2-3 for Windows is unstable during cell edits and copy operations
when F9 functions are involved. The errors occur due to the way Lotus1-2-3
interacts with F9 and Dynamic Data Exchange. To address this instability,
we have added two menu items to the Lotus 1-2-3 F9 menu: Recalculated
and Toggle Hold Recalculated.
Recalculated allows you to only recalculate a cell or range of cells on your
sheet. This can be very useful as your sheets get larger.
Selecting Toggle Hold Recalculated to turn Hold Recalculated ON causes
F9 to return the string “[F9] Recalculated” for all functions until either the
sheet is recalculated by pressing the F9 key, or until the cell is recalculated
using the Recalculated range menu item. When this option is ON, the
instabilities of Lotus 1-2-3 during cell editing and copying of F9 formulae is
addressed. Selecting this option again turns the option OFF. When this option
is OFF, F9 recalculates a formula on entry and copying.
Please Note: Make sure that F9 is attached before opening a file which uses
F9. Failing to do so will generate errors (@? formulae) in the cells containing
F9 formulae. If this occurs, close the file without saving it, attach F9 and
reopen the file. It is important that the file is not saved. If the file is saved
with the @? functions, all F9 functions (@GL) will be deleted and the
spreadsheet will no longer recalculate.
1-2-3 Release 4 Users
In Release 4 of 1-2-3 for Windows, if you use the Lotus 1-2-3 menu
Edit|Copy and Edit|Paste to copy F9 functions in your sheet, Lotus leaves
the cursor as an hourglass after the Paste operation and it will no longer
function on the sheet until you: press the Escape key; press any arrow key;
or click on the menu bar with the mouse. This does not happen if you use
the “Lotus Classic” function /COPY (and this method is also a lot faster)!
198