XL97: Problems Printing Unicode (Extended) Characters (191191)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q191191
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, make sure you understand how to restore it if
a problem occurs. For information about how to do this, view the "Restoring
the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key"
Help topic in Regedt32.exe.
SYMPTOMS
If you print a workbook containing extended characters, such as Greek or
Russian (Cyrillic) symbols, the characters may be printed as square boxes
even though they are displayed correctly on the screen.
CAUSE
This problem occurs because some printer drivers do not provide support for
Unicode characters and are unable to print them correctly.
WORKAROUND
To work around this problem, use any of the following methods.
Edit the Windows Registry
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall your operating system. Microsoft cannot
guarantee that problems resulting from the incorrect use of Registry Editor
can be solved. Use Registry Editor at your own risk.
For information about how to edit the registry, view the "Changing Keys And
Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete
Information in the Registry" and "Edit Registry Data" Help topics in
Regedt32.exe. Note that you should back up the registry before you edit it.
If you are running Windows NT, you should also update your Emergency
Repair Disk (ERD).
You can add a setting to the Microsoft Excel section of the Windows
registry that causes Excel to use the American National Standards Institute
(ANSI) character set instead of Unicode. This will enable Excel to print
the characters so that they are legible.
To change the Windows registry, follow these steps:
- On the Start menu, click Run.
- In the Open box, type regedit and click
OK.
- Locate the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel
- On the Edit menu, point to New and click DWORD Value. With "New
Value #1" selected, type NoWideTextRendering, and then press ENTER.
- On the Edit menu, click Modify. In the Edit DWORD Value dialog box,
click Hexidecimal under Base. Type the number 4. Click OK and quit
the Registry Editor.
Change the Properties for the Printer
Some printers offer a font setting called Print TrueType as Graphics. If
your printer provides this setting, try enabling this setting. For some
printers, this may solve this problem. To enable the Print True Type as
Graphics setting, follow these steps:
- On the Start menu, point to Settings, and then click Printers. In the
Printers dialog box, right-click your printer, and then click
Properties.
- In the Properties dialog box, click the Fonts tab. Click to select the
Print TrueType As Graphics setting, and then click OK.
- Restart Microsoft Excel.
NOTE: This workaround may not work for all printers.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 6/11/2002 |
---|
Keywords: | kbbug kbprint KB191191 |
---|
|