Dec 102017
 
The only shareware utility for changing Lotus 1-2-3 colors which is known to work with 1-2-3 version 2.2. Not an add-in; takes NO RAM (alters ".SET") file after making backup.
File ENHNCR13.ZIP from The Programmer’s Corner in
Category Lotus and other Spreadsheets
The only shareware utility for changing Lotus 1-2-3 colors which is known to work with 1-2-3 version 2.2. Not an add-in; takes NO RAM (alters “.SET”) file after making backup.
File Name File Size Zip Size Zip Type
ENHNCR.COM 63436 30548 deflated
ENHNCR.DOC 13758 4787 deflated

Download File ENHNCR13.ZIP Here

Contents of the ENHNCR.DOC file


Part of the ENHANCER series of programs ENHNCR.COM Ver. 1.3, Mar 24, 1988

Copyright (C) I. B. Miller 1985, 1986, 1987, 1988

If you find this of value and use it please send a
contribution ($35.00) suggested. ( Non business use less is suggested)

To: Enhancers
29 Vesta Drive
Richmond Hill, Ontario, Canada
L4B-2M2

This program is used by myself with LOTUS Development programs and
is supported by me, but obviously LOTUS does not support it.


ENHNCR is a program which will allow the user to set any of 14 of
the regular 16 bytes in the COLOR TABLE in a Lotus 123 or Symphony
driver set ( and the extended 17 to 23 used when the driver set is for an
EGA card. In addition the program will allow the user to revise the
character DISPLAY TABLE to use the line graphics characters in the IBM
character set rather than the Lotus LICS characters which are good for non
English countries but which are not much use in English reports. The
program can also do the same to the PRINT TABLE, which as Lotus provides it
converts line drawing characters to two or three stroke print sequences
intended to do accented letters so that if your printer can handle them it
will print linedrawing characters. ( The HP Laserjet does a really
beautiful job of printing reports with lines ). Also the CHARACTER TRANSLATE
TABLE can be changed so files can be imported and printed with the characters

How the colors are determined:
-----------------------------
The color table in the Symphony and 123 drivers is made up of 16 or 23 bytes
depending on whether or not an EGA driver is included. These bytes are used
to control screen colors for the following items.

byte no 1 is Regular cell (Protected)
byte no 2 is Cursor in regular cell (Protected) Seen on regular screens
byte no 3 is Unprotected cell and help screens
byte no 4 is Cursor in unprotected cell
byte no 5 is Underscore
byte no 6 is Underscore & Reverse
byte no 7 is Bold & Underscore Seen only on Symphony
byte no 8 is Underscore, Bold & Reverse COM screens
byte no 9 is Blink
byte no 10 is Wait Sign or Reverse & Blink Seen on regular screens
byte no 11 is Bold & Blink and help screens
byte no 12 is Bold, Reverse & Blink
byte no 13 is Underscore & Blink Seen only on Symphony
byte no 14 is Underscore, Blink & Reverse COM screens
byte no 15 is Reverse, Bold, Underscore & Blink
byte no 16 is Bold, Underscore & Blink
byte no 17 is X or x/y axis and titles & Text
byte no 18 is A or first item Used only if an EGA
byte no 19 is B or second item driver. Seen only on
byte no 20 is C or third item graphics display.
byte no 21 is D or fourth item
byte no 22 is E or fifth item
byte no 23 is F or sixth item

IBM Graphics character set:
--------------------------
Here is a screen dump of a sheet showing how easy it is to use these
characters

BS9: ' SHEET

ABCDEF
51 April 22, 1987 12:46
52
53
54 The macro will give this display and allow
55 choice of any character in window at right to
56 be copied to wherever your cursor was when the
57 was pressed.

58
59
60 Note that I only use characters 176 to 254 as the
61 characters between 128 and 175 are not supported
62 by the HP Laserjet, and I did not feel it to be
63 worthwhile. If anyone wants them I could change
64 the program for them.
65
66
67
68
69
70
CHARS
11-May-87 10:40 PM Calc Num

Here is a screendump showing a range of useable lines, boxes, etc.

B3: SHEET

ABCDEFGHIJKLMNOPQRSTUVWXY
1 Created using Symphony and a driver modified with ENHNCR.COM
2 Box Characters
3 218 196 194 191 201 205 203 187 219 220 223
4 | | | | | | | | | | |
5
6 195-><180 204-><185
7 197/ <179 206/ <186 <221
8
9 ^ ^ ^ ^ ^ ^ <222
10 192 193 217 200 202 188
11 <178
12 213 205 209 184 214 196 210 183
13 | | | | | | | | <177
14
15 198-><181 199-><182 <176
16 216/ <179 215/ 215/ <186
17 <254
18 ^ ^ ^ ^ ^ ^
19 212 207 190 211 208 189
20
MAIN
11-May-87 10:37 PM Calc Num

SAMPLE:
-------
of a report printed from a Symphony spreadsheet

Any Parent Company
consolidated cash flow
full year 1986 (millions)
(variance) = unfavourable
1st 2nd 3rd
Subsidiary Subsidiary Subsidiary consolidated

var. var. var. var.
actual plan actual plan actual plan actual plan

source of funds

net profit 1.2 0.3 1.2 (0.3) 1.2 0.2 3.6 0.2
depreciation 0.3 (0.1) 0.4 0.1 0.2 - 0.9 0.0

cash from operations 1.5 0.2 1.6 (0.2) 1.4 0.2 4.5 0.2

application of funds

net inc/-dec in
working capital 2.0 (0.1) 1.0 0.2 -0.9 0.7 2.1 0.8

capital expenditure 0.8 0.1 0.2 (0.1) 0.3 - 1.3 0.0

cash expended/-recovered 2.8 0.0 1.2 0.1 -0.6 0.7 3.4 0.8

cash generated/-utilized
during the period -1.3 0.2 0.4 (0.1) 2.0 0.9 1.1 1.0

Note: This is squashed so as to be more visible on screen.

CTF or Character Translation Files: (Version 1.2 & later modify the default)
----------------------------------- (Character translation Table in the )
( Symphony Users) (Driver set - as LOTUS 123 users can't )
(use the CTF files only Symphony users )
I have placed DEFAULT.CTF & PCSET.CTF files on this disk to allow import
and export, as well as printing to a file, which include the line characters
which are by default eliminated by Lotus. See your Symphony manual for
details of how to use these if you want to experiment.

PRINTING: Or "the importance of avoiding RESET commands to the Printer"
-------- -------------------------------------------------------------

Please note that the Drivers provided by Lotus generally send a
printer RESET prior to printing part of a spreadsheet. The drivers also
send two or three printstroke sequences to print what the LICs character
set has for accented characters according to a print swap table. ENHNCR
changes the print swap table to stop this and allow the IBM character set
including linedrawing graphics characters to be printed. If a regular
printer driver for, say ( as an example ) an Epson is used with an uploaded
character set, then the character set you uploaded will be trashed by the
RESET. The solution is to use the LOTUS INSTALL program to pick the driver
for UNLISTED COMPLETE CAPABILITY, as this driver does not do any RESET.

This is also a good idea if you are using set up sequences embedded
throughout your spreadsheet as I do and change when printing many ranges
from one sheet, by use of the UCC driver referred to above, there is no
problem with the printer being RESET to defaults between ranges.

COLORS: Or "the importance of INSTALLing the proper drivers"
------ ----------------------------------------------------

Most of the calls I receive are from users who cannot get their
colors to appear on the screen as expected. Most of these calls are a
result of the original INSTALLation being run and the user requesting TEXT
and GRAPHS be shown at the same time. The answer should be NO as when it
makes both possible it uses a GRAPHICS mode for the display rather than TEXT
therefore ENHNCR cannot find a color table or character translation tables
to work on - I dont know if I want to correct for this as it would be quite
a task to redo the graphics character fonts to eliminate LICS characters
and substitute IBM standard . Another way of saying this in some versions
of 123 or Symphony is to specify SEPARATE text and GRAPHS. Barring a bug
in version 1.0 of this program which has been fixed in release 1.2 there
have been no sustantiated cases of NO COLOR which upon investigation were
not as a result of the wrong drivers being placed in the driver set with
the INSTALL program. ( Choice of CGA and single color monitor also gives
BLACK and WHITE ) --------------------

If you are still having difficulty please feel free to send me a
copy of your driver set in its original form and as modified by ENHNCR,
along with a description of your system and your contribution. I cannot
send you a driver set as I cannot distribute them but I can certainly help
find for certain the problem and return yours. I have available CGA EGA
and VGA monitors and Boards and can test out most configurations. ( Since
the drivers are copyright material I cannot give one out - but if you send
me yours I feel free to assume it is legally in your possession and I can
modify it and return it to you.)

Disclaimer
----------
The program ENHNCR.COM will allow you to work with many colors and
see them on screen interactively without any of the work involved in
remembering all these numbers and color coding schemes. I believe it will
make color control easy, and also allow easy use of the IBM character set.

However for obvious reasons the user is totally responsible for use
of this program and determining that it is suitable for use by him, and he
uses this program with no warranty from myself.

If you have any comments or suggestions please contact
me either at Home in the evenings at (416) 737-8004 after 7PM Eastern
or at the PCanada(pc-1266) BBS (416) 751-6337

I am also on Compuserve as 72167,2563

Ivor B. Miller



 December 10, 2017  Add comments

Leave a Reply