XL97: Diagonal Gradient Fill May Not Be Printed Correctly

• Microsoft Excel 97 for Windows
• Microsoft Windows 95

SYMPTOMS

When you print a worksheet in Microsoft Excel 97, drawing objects and AutoShapes that are filled with a diagonal gradient fill may be printed incorrectly. Specifically, the gradient fill may "bleed," or appear outside of the drawing object or AutoShape.

CAUSE

This problem may occur when the following conditions are true:

• You are printing to a non-PostScript printer that uses Printer Command Language version 5.0 (PCL5). These printers include the following:

        Hewlett-Packard LaserJet 4M
        Hewlett-Packard LaserJet 5Si
        Lexmark LaserPrinter 4039
  

      -and-
  

• You are using Microsoft Windows 95.

      -and-
  

• The printer driver is configured to print in vector mode.

WORKAROUND

You can work around this problem by changing the default print mode to raster mode. To do this, follow these steps:

1. Save your work and quit any running programs.

2. On the Start menu, point to Settings, and click Printers.

3. In the list of printers, right-click the printer driver for the printer. On the shortcut menu, click Properties.

4. Click the Graphics tab.

5. Click Use Raster Graphics.

6. Click OK.

1. Switch to the document that you want to print.

2. On the File menu, click Print. Then, click Properties.

3. Click the Graphics tab.

4. Click Use Raster Graphics.

5. Click OK. Then, click OK again to print the document.

Note that you may also be able to prevent this problem from occurring by installing a newer version of the printer driver for your printer if one is available. To determine whether a driver is available, contact the printer manufacturer.

STATUS

This problem occurs when you use Microsoft Excel 97 and you print objects that are filled with a diagonal gradient fill to a printer that uses PCL5.

MORE INFORMATION

In Microsoft Excel 97, you can fill a drawing object or AutoShape with a gradient fill. To do this, follow these steps:

1. Click to select the object. On the Format menu, click Object or AutoShape.

2. Click the Colors And Lines tab. Under the Fill section, click Fill Effects in the Color box.

3. Click the Gradient tab.

4. Under Colors, click one or two colors. Under Shading Styles, click one of the six options (Horizontal, Vertical, Diagonal Up, Diagonal Down, From Corner, or From Center). When you are done, click OK.

5. Click OK again.

If you fill an AutoShape with diagonal fill, the problem described in the "Symptoms" section in this article may occur when you print the worksheet or chart that contains the AutoShape. The workaround in this article may prevent the problem from occurring; however, it may cause another problem if text or another object is behind the AutoShape.

For more information about printing problems in Microsoft Excel 97, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q159227
   TITLE     : XL97: Drawing Objects and AutoShapes Printed Incorrectly