XL2000: Printing at Non-Square Resolution Distorts AutoShapes (211680)

SYMPTOMS

When you print or print preview a worksheet or chart in Microsoft Excel 2000, drawing objects and AutoShapes may appear distorted. For example, you may notice the following problems:

Arrowheads are distorted and uneven with the lines they are attached to.
Thick lines do not end squarely; instead, they are cut off at an angle.

CAUSE

This behavior occurs when all of the following conditions are true:

The active printer is a dot matrix printer. -and-
The printer driver is set to a non-square printer resolution: that is, with different values for horizontal and vertical resolution, such as 360 x 180 dots per inch (dpi).

RESOLUTION

To prevent this problem from occurring, set the printer driver to print using a square resolution, such as 360 x 360 dpi or 180 x 180 dpi. To do this, follow these steps:

In Excel 2000, click Print on the File menu.
In the list of Printers, select the dot matrix printer, and then click Properties.
On the Graphics tab, select a square resolution in the Resolution list, and then click OK.
In the Print dialog box, click OK, or Preview, or Cancel, depending on whether you want to print, preview, or return to the worksheet or chart.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

NOTE: The problem does not always occur when you print using non-square resolution.

MORE INFORMATION

Most printers, including laser printers, PostScript printers, and some InkJet printers, print using square resolution: that is, the horizontal resolution equals the vertical resolution. For example, a laser printer might use a resolution of 300 x 300 dpi or 600 x 600 dpi. However, some dot matrix printers can print using non-square resolutions.