Go to the Previous PageGo to the Main ViewGo to the Next PageGo to a printer friendly version of this document
Chapter 7 HP Emulation Mode -- Working with Commercial Software
(User's Guide OL830)
Lotus 1-2-3@, Releases 1A to 2.01

Lotus 1-2-3 Releases 1A to 2.01 provides relatively limited access to printer features. Possibilities can be broadened, however, through skillful manipulation of embedded printer commands. Release 2.2 and later support laser printer features directly.

Installing the Driver
Run the 1-2-3 Install program. From the first screen, select either the First Time Installation or the Change Selected Equipment option. First Time Installation will set up various other equipment parameters before moving to the printer selection screen. (Answer "Yes" when the program asks if you have a text printer.) If you select Change &lected Equipment, you can move to the printer selection screen directly.

The first text printer screen will ask for the brand of printer. If you cannot find an OL800, OL400, or HP LaserJet printer driver, you should select "Unlisted" (the last option) and "No Backspace" from the Printer Features screen. If your version of 1-2-3 does contain an appropriate driver, you do not need to change printer features.

If you are running First Time Installation, the program will ask several questions, then ask, "Do you want to print graphs?" You should answer Yes. The Graphics Printer selection screen will appear. Here, you should select HP as the brand; a list of HP printers will now appear, and you should select LaserJet II, if present, or LaserJet+. If you are running Change Selected Equipment, you should select Changing Graphics Printers when you return from Changing Text Printers.

Be sure to save your changes, and exit from the Install program.

Once you have installed your printer or printers with the Install program, there are some printing options you might wish to change from within Lotus 1-2-3. To see these items, use the /Worksheet Global Default Printer command sequence (/WGDP). This will bring up a menu with the following options: Interface, Auto-LF, Left, Right, Top, Bottom, Pg-Length, Wait, Setup, Name, Quit.

The following table gives the recommended default settings for Okidata LED page printers.

Global Defaults

For parallel interface
For serial interface
Page length60Set default for 60 lines at 6 lpi
Top margin0Set top margin to 0, since the printer automatically skips 3 lines at the top
Bottom margin0Likewise, set bottom margin to 0
Auto LFNTurn off automatic linefeed
Setup\027EEnter when prompted for setup string
Quit2To exit printer menu

To save the new settings, type U from the Default menu after leaving the Printer menu.

The setup string in the table above clears any printer commands prior to printing. You can change the setup string for an individual job to do things like change fonts, orientation, or line spacing. From the Printer Options menu (\PPO), type S, and you will see the default string, \027E. Add to it the commands for any features you want to add. The table below lists the codes for some of the more commonly used features.

If you shift from portrait to landscape (or vice versa), or if you change fonts or line spacing, you'll have to use the M or P selections on the Options menu to adjust the right margin and page length accordingly. Leaving the left margin at the default setting of 4, the following tables list the proper settings.

Right Margin
Line Printer128172

Page Length
Line SpacingPortraitLandscape
6 lpi6045
8 lpi8060

If you wish, you can save this setup information separately (useful if you have several printers, or several basic setups) by using the Name option. You can see your current settings by using the /Worksheet Global Default Status command (/WGDS).


To print graphs, you must save the graph in a .PIC file, exit the program, and run the PrintGraph utility program.

To print your worksheet, use the /Print Printer (/PP) command sequence. This calls up a menu with the following options: Range, Line, Page, Options, Clear, Align, Go, Quit. To print an area, first select the range to be printed. Then select Align to "zero" the printer's print position. Then select Go. The printer will print. When printing is completed, select Page to make sure the last page of data is printed. (Otherwise, partial pages will remain in the printer. This is the same as using the FORM FEED button.)

If you wish to apply some feature to only a portion of your spreadsheet, you can embed commands. This is done as follows:

1. Insert a blank row above the first row to be printed with the attribute.

2. Move the cell pointer to the left column in the print range of the inserted row.

3. Type two vertical bars, followed by the printer command.

4. Remember to turn the feature off after the text by repeating this process.

Common Embedded Features


If you wish to change your page settings, you should note that 1-2-3 reserves three lines for headers and three lines for footers for each page, whether or not you actually print them. Since your printer skips three lines on the top and bottom with its 60 line page length, the reserved lines are added to the skipped lines to yield effective top and bottom margins of 6 lines each--with 0 line top and bottom margins specified. Top or bottom margin settings are added to the 6 lines.

Available Features

You should note that 1-2-3 up to Release 2.01 expects only fixed-space fonts. If you use proportional fonts such as Dutch, spacing will be erratic. You should stay with the Line Printer and Courier fonts. Release 2.2 and later doesn't have this limitation.
Oki Data has taken care to insure that the information is complete, accurate and up-to-date. However, Oki Data assumes no responsibility for errors or omissions which may occur. All the information provided is subject to change from time to time at the sole discretion of Oki Data.
Copyright 2020, Oki Data, Americas, Inc.