## XL4: How Fonts are Mapped from Lotus 1-2-3 to Excel

The information in this article applies to:

- Microsoft Excel for Windows, versions 4.0, 4.0a
- Microsoft Excel for the Macintosh, version 4.0

## SUMMARY

When you open and save Lotus 1-2-3 files in Microsoft Excel version 4.0, the current font may be substituted with a different font name.
The font used by Lotus 1-2-3 may not be available in Microsoft Excel. Therefore, Microsoft Excel will use a different font based on a predefined font table.
If a specified font name is not found in these tables, then the original font name is used when you load or save the file. This way, if the specified font is available on the system, Microsoft Excel or Lotus 1-2-3 will use that font. If the original font is not found, the default font will be used.

## MORE INFORMATION

The following tables describe the Impress to Microsoft Excel font conversion scheme and illustrate the six tables used in the font conversion process.

       Table
       Number      Conversion Scheme                 Description
       ---------------------------------------------------------------------

       1            Impress font to Windows font     Loading Impress files

       2            Impress font to Macintosh font   Loading Impress files

       3            Microsoft Excel for Macintosh    Saving FMT to Microsoft
                    to FMT                           Excel for Macintosh

       4            Microsoft Excel for Macintosh    Saving FM3 to
                    to FM3                           Microsoft Excel
                                                     for Macintosh

       5            Microsoft Excel for              Saving FMT to Microsoft
                    Windows to FMT                   Excel for Windows

       6            Microsoft Excel for              Saving FM3 to Microsoft
                    Windows to FM3                   Excel for Windows

Table 1

       Impress Font Name             Windows Font Name
       -----------------------------------------------

       HLV                           Helv
       TMS                           Tms Rmn
       COUR                          Courier
       SYMB                          Symbol
       HELV                          Helv
       TMSRMN                        Tms Rmn
       LGOTHIC                       LinePrinter
       LINEPR                        LinePrinter
       P-AVGARD                      Helv
       P-BOOKMN                      Tms Rmn
       P-HLV                         Helv
       P-HLV-C                       Helv
       P-CNTURY                      Tms Rmn
       P-PALTNO                      Tms Rmn
       P-TIMES                       Tms Rmn
       P-CHNCRY                      Tms Rmn
       P-DINGB                       Symbol
       PRESTIGE                      Tms Rmn
       DUTCH                         Tms Rmn
       SWISS                         Helv
       XSYM                          Symbol

Table 2

       Impress Font Name             Macintosh Font Name
       -------------------------------------------------

       HLV                           Helvetica
       TMS                           Times
       COUR                          Courier
       SYMB                          Symbol
       HELV                          Helvetica
       TMSRMN                        Times
       LGOTHIC                       Helvetica
       LINEPR                        Helvetica
       P-AVGARD                      Helvetica
       P-BOOKMN                      Times
       P-HLV                         Helvetica
       P-HLV-C                       Helvetica
       P-CNTURY                      Times
       P-PALTNO                      Palatino
       P-TIMES                       Times
       P-CHNCRY                      Times
       P-DINGB                       Symbol
       PRESTIGE                      Times
       DUTCH                         Times
       SWISS                         Helvetica
       XSYM                          Symbol

Table 3-4

       Microsoft Excel
       for Macintosh Font Name       FMT             FM3
       ------------------------------------------------------

       Helvetica                     Hlv             Swiss
       Athens                        Hlv             Swiss
       Cairo                         Hlv             Swiss
       Chicago                       Hlv             Swiss
       Courier                       Cour            Cour
       Geneva                        Hlv             Swiss
       London                        Hlv             Swiss
       Los Angeles                   Hlv             Swiss
       Mobile                        Hlv             Swiss
       Monaco                        Hlv             Swiss
       New York                      Dutch           Dutch
       Palatino                      P-Paltno        P-Paltno
       San Francisco                 Hlv             Swiss
       Symbol                        Symb            Xsym
       Times                         Tms             Dutch
       Venice                        Hlv             Swiss

Table 5-6

       Microsoft Excel for
       Windows font names            FMT             FM3
       ----------------------------------------------------

       Helv                          Hlv             Swiss
       CG Times (E1)                 Hlv             Swiss
       Courier                       Cour            Cour
       LinePrinter                   LinePr          LinePr
       Lucida Sans B                 Hlv             Swiss
       Lucida Sans B1                Hlv             Swiss
       Lucida Sans B2                Hlv             Swiss
       Modern                        Hlv             Swiss
       Preview                       Hlv             Swiss
       Roman                         Tms             Dutch
       Script                        Hlv             Swiss
       Symbol                        Symb            Xsym
       Symbol B                      Symb            Xsym
       System                        Hlv             Swiss
       Terminal                      Cour            Cour
       Tms Rmn                       Tms             Dutch
       Univers                       Hlv             Swiss
       MS Sans Serif                 Hlv             Swiss
       CG Times (WN)                 Tms             Dutch
       MT Extra                      Cour            Cour
       Times New Roman               Tms             Dutch
       Courier New                   Cour            Cour
       Fences                        Cour            Cour
       Fixedsys                      Cour            Cour
       MS LineDraw                   Cour            Cour
       MS Serif                      Tms             Dutch
       Arial                         Hlv             Swiss
       Small Fonts                   Hlv             Swiss
       MT Symbol                     Symb            Xsym

Additional query words: 4.00a wysiwyg 123 XL4

Keywords : kb3rdparty
Version : WINDOWS:4.0,4.0a; MACINTOSH:4.0
Platform : MACINTOSH WINDOWS
Issue type :
Technology : kbvcSearch

Last Reviewed: July 23, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use.