Category : Lotus and other Spreadsheets
Archive   : ENHNCR13.ZIP
Filename : ENHNCR.DOC

 
Output of file : ENHNCR.DOC contained in archive : ENHNCR13.ZIP

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

ÚÄÄÄÄÄÄÄAÄÄÄÄÄÄÄÄBÄÄÄÄÄÄÄÄCÄÄÄÄÄÄÄÄDÄÄÄÄÄÄÄÄEÄÄÄÄÄÄÄÄFÄÄÄÄÄÄÄÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿
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

ÚÄÄÄAÄÄBÄÄCÄÄÄDÄÄÄÄEÄFÄGÄÄHÄÄIÄÄJÄÄKÄÄÄLÄÄÄÄMÄÄNÄÄOÄÄPÄÄQRÄSÄTÄUÄVÄWÄXÄYÄÄÄÄÄÄ¿
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