Dec 112017
 
Lotus Add-In that allows you to edit Range Names.
File EDNAME.ZIP from The Programmer’s Corner in
Category Lotus and other Spreadsheets
Lotus Add-In that allows you to edit Range Names.
File Name File Size Zip Size Zip Type
EDNAME.ADN 8784 4592 deflated
EDNAME.DOC 4381 1903 deflated

Download File EDNAME.ZIP Here

Contents of the EDNAME.DOC file




1-2-3 Edit With Names Add-in

Copyright (C) 1987, Lerman Associates
12 Endmoor Road
Westford, MA 01886

Developed by: Gerald Lerman
Compuserve ID: 73557,1453



WHAT IS EDNAME? WHAT DOES IT DO?


EDNAME (Edit with Names) is a 1-2-3 R2.0 and R2.01 add-in that, when
attached, alters the way the F2 (EDIT) key operates when editing formula
cells.

Normally when editing a formula cell, 1-2-3 displays cell coordinates
instead of range names. If the entire formula doesn't fit on the top
display line, it may be difficult to fully understand what cells and
ranges the formula references.

With EDNAME attached, formulas, when edited, are displayed with range
names filled in, instead of cell coordinates.


WHAT VERSIONS DOES IT RUN UNDER?

EDNAME runs under any presently released 1-2-3 version except 1 and 1A.
There is also an EDNAME version that works with any Symphony release.


CAN I TOGGLE BETWEEN EDITING WITH RANGE NAMES AND EDITING WITH CELL COOR-
DINATES?

When EDNAME first attaches, editing formulas will display range names
instead of the usual cell coordinates. When invoked, the EDNAME add-in
(see installation and operation below), will ask which editing state you
want. You can then turn off or on the option to edit with range names
visible.


HOW MUCH MEMORY DOES EDNAME USE?

There are three answers:

1) The shareware version requires about 8.5K.

2) Once registered, you will be sent the regular version which requires
about 6.5K.

3) Either version can be detached. The last edit mode in effect will
remain in effect. So if you always want to operate, for example, in
the mode where formula edits always display range names, you can
detach EDNAME while remaining in that mode. EDNAME at that point will
require no additional memory at all!

So, the only reason to keep EDNAME attached is for the convenience of
altering the editing mode.


WHAT DO I GIVE UP?

The 1-2-3 edit function is limited to 240 characters. This does not
change with EDNAME. Therefore, if a formula, once expanded with range
names, exceeds the 240 character limit, it will display, but it will be
truncated after 240 characters. So if you have a formula this long, you
will not be able to edit it with EDNAME in the range name display mode
lest you try storing a truncated formula.


WHY DIDN'T LOTUS PROVIDE THIS CAPABILITY?

Formulas displayed with cell coordinates generally take less space. It
is less likely that you would hit the 240 character limit on formula
editing. If this is a problem under EDNAME, you can switch back to the
normal 1-2-3 edit methodology by invoking EDNAME (see installation and
operation below).


IS EDNAME FREE?

Absolutely not! EDNAME is shareware. It means that you are free to try
it out for awhile. But if you decide to use it, you must pay a licensing
fee. An EDNAME license costs $12.95. Upon registering, you will receive
a slightly different and more convenient version.

The shareware version takes longer to load and requires that you agree to
the license provision each time you attach the add-in. The regular ver-
sion sent upon registration will not contain this procedure. The regular
version also requires about 2K less memory.


HOW TO I INSTALL AND OPERATE EDNAME?

Before you can "attach" EDNAME you must install the Lotus provided Add-in
Manager (ADN_MGR.DRV) within your driver set. You will not find this
program or any of the accessory programs in your 1-2-3 package.

When you buy an Add-in like SeeMORE, 4WORD, InWORD, etc., the program
comes with these Lotus provided programs. To use a shareware add-in you
must download the Add-in manager as well as the Add-in.

If you downloaded EDNAME from Compuserve, you can find the add-in manager
files and instructions in file ADNMGR.ARC which is in DL4.

To operate EDNAME, that is, to specify which editing mode you want,
invoke EDNAME by either selecting the ALT function key you assigned
EDNAME to (if you did), or enter ALT-F10, Invoke, EDNAME.




 December 11, 2017  Add comments

Leave a Reply