Microsoft KB Archive/69307

Monochrome Bitmaps Paste into Excel Inverted PSS ID Number: Q69307 Article last modified on 02-26-1993 PSS database name: W_eXceL

3.00

WINDOWS

Summary:

On occasion, monochrome bitmaps will paste into Excel with inverted or altered colors. Any adjustment to the color palette should resolve this problem. Two ways to do this are:

  Choose Patterns from the Format menu and change the foreground or background color. Then change it back. -or-   Open the Colors section of the Control Panel. Close the Control Panel and return to Excel. 

Either of these methods will allow the next paste of the bitmap to paste correctly.

Microsoft has confirmed this to be a problem in Microsoft Excel version 3.0. This problem was corrected in Microsoft Excel version 4.0.

More Information:

Steps to Reproduce Problem

 * 1) Start Paintbrush and open the CHESS.BMP file.
 * 2) Save the CHESS.BMP file as a monochrome bitmap by choosing Save As from the File menu, selecting the Options button, and selecting Monochrome Bitmap. Change the name of the file in the Filename box to TEST.
 * 3) Choose Open from the File menu and open the TEST file.
 * 4) Select a block of the graphic with the scissors and choose Copy from the Edit menu.
 * 5) Open Excel and choose Paste from the Edit menu. The image will paste inverted.

Copyright Microsoft Corporation 1993.