home *** CD-ROM | disk | FTP | other *** search
/ Monster Media 1993 #2 / Image.iso / wp / adconv60.zip / LOTUS123.DOC < prev    next >
Text File  |  1993-06-01  |  12KB  |  454 lines
  1.  
  2. This document deals with conversion of features from Lotus 1-2-3
  3. versions 2.01, 2.3, 2.4, 3.0, 3.1, and Lotus 1.0 for Windows to
  4. WordPerfect 6.0.  Currently, converting tables from WordPerfect 6.0 to
  5. Lotus 1-2-3 is not supported.
  6.  
  7.  
  8.  LOTUS 123 versions 1A, 2.01, 2.3,
  9.  2.4, 3.0, and 3.1
  10.  LOTUS 1.0 for Windows               WORDPERFECT 6.0
  11.  ======================              ===============
  12.  
  13.  Format
  14.  
  15.       +/-                            Number Type Format: General
  16.  
  17.       Currency                       Number Type Format: Currency
  18.  
  19.       Date1                          Date Type Format: #4
  20.  
  21.       Date2                          Date Type Format: B
  22.  
  23.       Date3                          Date Type Format: #4
  24.  
  25.       Date4                          Date Type Format: #2
  26.  
  27.       Date5                          Date Type Format: A
  28.  
  29.       Fixed                          Number Type Format: Fixed
  30.  
  31.       General                        Number Type Format: General
  32.  
  33.       Hidden                         Hidden Text
  34.  
  35.       Other-Auto                     Not converted
  36.  
  37.       Other-Color-Neg                Not converted
  38.  
  39.       Other-Label                    Not converted
  40.  
  41.       Other-Paren-Y/N                Negative Numbers: Parenthesis
  42.  
  43.       Percent                        Number Type Format: Percent
  44.  
  45.       Row Height                     Not converted
  46.  
  47.       Scientific                     Number Type Format: Scientific
  48.  
  49.       Text                           Number Type Format: Text
  50.  
  51.       Time1                          Date Type Format: #6
  52.  
  53.       Time2                          Date Type Format: #6
  54.  
  55.       Time3                          Date Type Format: C
  56.  
  57.       Time4                          Date Type Format: C
  58.  
  59.  Label
  60.  
  61.       Left                           Converted to Left Justification
  62.                                      assigned to table cell
  63.  
  64.       Center                         Converted to Center
  65.                                      Justification assigned to table
  66.                                      cell
  67.  
  68.  
  69.       Col-Width                      Column: Width #8
  70.  
  71.       Right                          Converted to Right
  72.                                      Justification assigned to table
  73.                                      cell
  74.  
  75.       Protection
  76.  
  77.            Disable                   Cell Lock (toggle)
  78.  
  79.            Enable                    Cell Lock
  80.  
  81.       Label                          Not converted
  82.  
  83.       Recalc                         Not converted
  84.  
  85.       Zero-No                        Not converted
  86.  
  87.       Zero-Yes                       Not converted
  88.  
  89.  DEFAULT
  90.  
  91.       Graphs                         Not converted
  92.  
  93.       OTHER-Int'l-ASCII              Not converted
  94.  
  95.       OTHER-Int'l-Currency-Prefix    Not converted
  96.  
  97.       OTHER-Int'l-Date A,B,C,D       Not converted
  98.  
  99.       OTHER-Int'l-File-Ts-           Not converted
  100.       Intern'tl
  101.  
  102.       OTHER-Int'l-File-Ts-Country    Not converted
  103.  
  104.       OTHER-Int'l-Negative-Parenth   Not converted
  105.  
  106.       OTHER-Int'l-PunctA-H           Not converted
  107.  
  108.       OTHER-Int'l-Rel-2LICS          Not converted
  109.  
  110.       OTHER-Int'l-Sign               Not converted
  111.  
  112.       OTHER-Int'l-Suffix             Not converted
  113.  
  114.       OTHER-Int'l-Time A,B,C,D       Not converted
  115.  
  116.       Printer-AutoLf-Yes/No          Not converted
  117.  
  118.       Printer-Bottom                 Bottom Margin
  119.  
  120.       Printer-Interfce               Not converted
  121.  
  122.       Printer-Left                   Left Margin
  123.  
  124.       Printer-Name                   Not converted
  125.  
  126.       Printer-Pg-Lgth                Not converted
  127.  
  128.       Printer-Right                  Right Margin
  129.  
  130.       Printer-Setup                  Not converted
  131.  
  132.       Printer-Top                    Top Margin
  133.  
  134.  
  135.       Printer-Wait-Y/N               Not converted
  136.  
  137.  Column
  138.  
  139.       Hide                           Hidden
  140.  
  141.       Reset-Width                    Column Width: default
  142.  
  143.       Set-Wdth                       Column Width: #8
  144.  
  145.       Unhide                         Show all Hidden Text
  146.  
  147.  Titles
  148.  
  149.       Both                           Not converted
  150.  
  151.       Hortz                          Converts to a title heading on
  152.                                      each page
  153.  
  154.       Vert                           Not converted
  155.  
  156.       Clear                          Not converted
  157.  
  158.  Page                                Hard Page Break
  159.  
  160.  DATA
  161.  
  162.       Fill                           Convert to value or text
  163.  
  164.       Table                          Convert to value or text
  165.  
  166.            1 Input                   Convert to value or text
  167.  
  168.            2 Input                   Convert to value or text
  169.  
  170.            Reset                     Convert to value or text
  171.  
  172.       Distribution                   Convert to value or text
  173.  
  174.       Matrix-Invert                  Convert to value or text
  175.  
  176.       Multiply                       Convert to value or text
  177.  
  178.       Parse                          Convert to value or text
  179.  
  180.       Query                          Convert to value or text
  181.  
  182.       Regression                     Convert to value or text
  183.  
  184.       Sort                           Convert to value or text
  185.  
  186.  Range
  187.  
  188.       Erase                          Not converted
  189.  
  190.       Justify                        Not converted
  191.  
  192.       Name                           Range Names convert
  193.  
  194.       Protect                        Cell: Lock
  195.  
  196.       Unprotect                      Cell: Lock (toggle)
  197.  
  198.  Database Function
  199.  
  200.  
  201.       DAVG()                         Not converted
  202.  
  203.       DCOUNT()                       Not converted
  204.  
  205.       DGET()                         Not converted
  206.  
  207.       DMAX()                         Not converted
  208.  
  209.       DMIN()                         Not converted
  210.  
  211.       DQUERY()                       Not converted
  212.  
  213.       DSTD()                         Not converted
  214.  
  215.       DSTDS()                        Not converted
  216.  
  217.       DSUM()                         Not converted
  218.  
  219.       DVAR()                         Not converted
  220.  
  221.       DVARS()                        Not converted
  222.  
  223.  Date and Time Function
  224.  
  225.       D360()                         Not converted
  226.  
  227.       DATE()                         DATE()
  228.  
  229.       DATEVALUE()                    DATEVALUE()
  230.  
  231.       DAY()                          DAY()
  232.  
  233.       HOUR()                         HOUR()
  234.  
  235.       MINUTE()                       MINUTE()
  236.  
  237.       MONTH()                        MONTH()
  238.  
  239.       NOW()                          MDY()+HMS()
  240.  
  241.       SECOND()                       SECOND()
  242.  
  243.       TIME()                         TIME()
  244.  
  245.       TIMEVALUE()                    TIMEVALUE()
  246.  
  247.       TODAY ()                       MDY()
  248.  
  249.       YEAR()                         YEAR()
  250.  
  251.  Financial Function
  252.  
  253.       CTERM()                        TERM()
  254.  
  255.       DDB()                          DDB()
  256.  
  257.       FV()                           FV()
  258.  
  259.       IRR()                          IRR()
  260.  
  261.       NPV()                          NPV()
  262.  
  263.       PMT()                          PMT()
  264.  
  265.  
  266.       PV()                           PV()
  267.  
  268.       RATE()                         RATE()
  269.  
  270.       SLN()                          SLN()
  271.  
  272.       SYD()                          SYD()
  273.  
  274.       TERM()                         TERM()
  275.  
  276.       VDB()                          Not converted
  277.  
  278.  Logical Function
  279.  
  280.       FALSE()                        FALSE()
  281.  
  282.       IF()                           IF()
  283.  
  284.       ISERR()                        ISERR()
  285.  
  286.       ISNA()                         ISNA()
  287.  
  288.       ISNUMBER()                     ISVALUE()
  289.  
  290.       ISRANGE()                      Not converted
  291.  
  292.       ISSTRING()                     ISTEXT()
  293.  
  294.       TRUE()                         TRUE()
  295.  
  296.  Mathematical Function
  297.  
  298.       ABS()                          ABS()
  299.  
  300.       ACOS()                         ACOS()
  301.  
  302.       ASIN()                         ASIN()
  303.  
  304.       ATAN()                         ATAN()
  305.  
  306.       ATAN2()                        ATAN2()
  307.  
  308.       COS()                          COS()
  309.  
  310.       EXP()                          EXP()
  311.  
  312.       INT()                          INT()
  313.  
  314.       LN()                           LN()
  315.  
  316.       LOG()                          LOG()
  317.  
  318.       MOD()                          MOD()
  319.  
  320.       PI()                           PI()
  321.  
  322.       RAND()                         RANDOM()
  323.  
  324.       ROUND()                        ROUND()
  325.  
  326.       SIN()                          SIN()
  327.  
  328.       SQRT()                         SQRT()
  329.  
  330.  
  331.       TAN()                          TAN()
  332.  
  333.  Special Function
  334.  
  335.       @@()                           Not converted
  336.  
  337.       CELL()                         Not converted
  338.  
  339.       CELLPOINTER()                  Not converted
  340.  
  341.       CHOOSE()                       CHOOSE()
  342.  
  343.       COLS()                         Not converted
  344.  
  345.       COORD()                        Not converted
  346.  
  347.       ERR()                          Not converted
  348.  
  349.       HLOOKUP()                      LOOKUP()
  350.  
  351.       INDEX()                        INDEX()
  352.  
  353.       INFO()                         Not converted
  354.  
  355.       NA()                           NA()
  356.  
  357.       ROWS()                         Not converted
  358.  
  359.       SHEETS()                       Not converted
  360.  
  361.       VLOOKUP()                      LOOKUP()
  362.  
  363.  Statistical Function
  364.  
  365.       AVG()                          AVE()
  366.  
  367.       COUNT()                        COUNT()
  368.  
  369.       MAX()                          MAX()
  370.  
  371.       MIN()                          MIN()
  372.  
  373.       STD()                          STDEV()
  374.  
  375.       STDS()                         STDEV()
  376.  
  377.       SUM()                          SUM()
  378.  
  379.       SUMPRODUCT()                   Not converted
  380.  
  381.       VAR()                          VAR()
  382.  
  383.       VARS()                         VAR()
  384.  
  385.  String Function
  386.  
  387.       CHAR()                         CHAR()
  388.  
  389.       CODE()                         Not converted
  390.  
  391.       EXACT()                        Not converted
  392.  
  393.       FIND()                         Not converted
  394.  
  395.  
  396.       LEFT()                         LEFT()
  397.  
  398.       LENGTH()                       LENGTH()
  399.  
  400.       LOWER()                        LOWER()
  401.  
  402.       MID()                          MID()
  403.  
  404.       N()                            Not converted
  405.  
  406.       PROPER()                       PROPER()
  407.  
  408.       REPEAT()                       REPEAT()
  409.  
  410.       REPLACE()                      Not converted
  411.  
  412.       RIGHT()                        RIGHT()
  413.  
  414.       S()                            Not converted
  415.  
  416.       STRING()                       TEXT()
  417.  
  418.       TRIM()                         Not converted
  419.  
  420.       UPPER()                        UPPER()
  421.  
  422.       VALUE()                        VALUE()
  423.  
  424.  
  425. Negative numbers that have parentheses set as the negative indicator
  426. convert with a minus sign (-) indicator with the minus sign between
  427. the $ sign for currency and the number.  For example, the number
  428. ($45.00) would convert to $-45.00.
  429.  
  430. Importing spreadsheets up to 64 columns is supported.  If you try to
  431. import a spreadsheet with more than 64 columns, all columns after the
  432. 64th column are truncated.
  433.  
  434. Importing a spreadsheet into a WordPerfect 6.0 document changes the
  435. Table Line defaults for all following tables to "None."  Tables
  436. following the imported spreadsheet will need to be edited and changed
  437. to restore the table lines and borders.
  438.  
  439. Spreadsheets formatted for printing using the WYSIWYG feature of Lotus
  440. will not retain that formatting as the formatting is stored in a file
  441. separate from the spreadsheet file.
  442.  
  443. Fonts 1 through 8 of DOS versions of Lotus will convert when the
  444. spreadsheet has not been formatted with WYSIWYG.  Fonts in Lotus 1-2-3
  445. for Windows spreadsheets will not convert as they are stored in a file
  446. separate from the spreadsheet file.
  447.  
  448. Hidden columns will convert to a column width of .001.  Changing the
  449. column width in WordPerfect 6.0 will expand hidden columns  and
  450. turning on the 'Show All Hidden Text' option will allow the data in
  451. each table cell to be viewed.
  452.  
  453. Functions not supported in WordPerfect 6.0 tables will convert as the
  454. calculated value of that function.