XL98: Special or Accented Characters Are Saved Incorrectly in the Lotus File Format

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, if you save a workbook, close the workbook, and then reopen the workbook, extended characters in the workbook may be replaced by other characters.

CAUSE

This problem may occur if you save the workbook in any of the following Lotus 1-2-3 formats:

WK4 (1-2-3)
WK3 (1-2-3)
WK3,FM3 (1-2-3)

WORKAROUND

If you save a workbook that contains extended characters in the Lotus WK1 format, the extended characters are saved correctly. However, the WK1 format does not support many features that are used by Microsoft Excel, such as multiple sheets in a workbook. Use this workaround with caution.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above.

MORE INFORMATION

Extended characters are characters that include accents, circumflexes, cedillas, umlauts, or other diacritical marks. Usually, you can enter an extended character by using a special key combination or by using a function, such as the CHAR function.

Example

1. In Microsoft Excel 98 Macintosh Edition, create a new workbook.



2. Select cell A1.



3. Press the following keys in sequence. Do not press RETURN until you have pressed all of the keys:

   OPTION+` (the key above the TAB key)
   a
   SPACE
   OPTION+`
   e
   SPACE
   OPTION+`
   i
   SPACE
   OPTION+`
   o
   SPACE
   OPTION+`
   u
   RETURN

   The characters "a," "e," "i," "o," and "u" appear in the cell, each with a grave accent.



4. On the File menu, click Save. In the Save File As Type list, click WK4 (1-2-3). Then, click Save.



5. On the File menu, click Close. Click Don't Save.



6. Reopen the file you saved in step 4.

   Old character   New character
   -------------------------------------------------

   grave "a"       "e" with a circumflex
   grave "e"       "A" with a circle (Scandinavian)
   grave "i"       "o" with a circumflex
   grave "o"       "y" with an umlaut
   grave "u"       "O" with a diagonal strikethrough 

Additional query words: XL98

Keywords : kbconversion xlloadsave xl123Quattro
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug