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

ID: Q101122


The information in this article applies to:


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        : 

Last Reviewed: July 23, 1999