home *** CD-ROM | disk | FTP | other *** search
/ Monster Media 1993 #2 / Image.iso / wp / adconv60.zip / PLAN.DOC < prev    next >
Text File  |  1993-06-01  |  17KB  |  591 lines

  1.  
  2. This document deals with conversion of features from PlanPerfect 3.0
  3. and 5.x to WordPerfect 6.0.  Currently, converting tables from
  4. WordPerfect 6.0 to PlanPerfect is not supported.
  5.  
  6.  
  7.  
  8.  PLANPERFECT 3.0 and 5.x            WORDPERFECT 6.0
  9.  =======================            ===============
  10.  
  11.  Calculations
  12.  
  13.       Iteration                     Not converted
  14.  
  15.       Iteration Formula             Not converted
  16.  
  17.       Mode (Automatic, Manual)      Not converted
  18.  
  19.       Order                         Not converted
  20.  
  21.       Round Value                   Not converted
  22.  
  23.  Compose Characters                 All extended characters are
  24.                                     converted
  25.  
  26.  Edit Window (Text)                 Converted to individual cells,
  27.                                     with each line of text in a
  28.                                     separate cell
  29.  
  30.  Font
  31.  
  32.       Select for Cell or Block      Converted to font/size codes
  33.                                     within the table cell
  34.  
  35.       Select for Column             Converted to font/size codes
  36.                                     within table column
  37.  
  38.       Select for Worksheet          Converted to a font/size code at
  39.                                     the beginning of the table
  40.  
  41.  Format
  42.  
  43.       Alignment
  44.  
  45.            Cell
  46.  
  47.                 Center, Numbers     Converted to Center
  48.                 or Text             Justification assigned to table
  49.                                     cell
  50.  
  51.                 Left, Numbers or    Converted to Left Justification
  52.                 Text                assigned to table cell
  53.  
  54.                 Right, Numbers or   Converted to Right Justification
  55.                 Text                assigned to table cell
  56.  
  57.            Column
  58.  
  59.                 Center, Numbers     Converted to Center
  60.                 or Text             Justification assigned to table
  61.                                     column
  62.  
  63.                 Left, Numbers or    Converted to Left Justification
  64.                 Text                assigned to table column
  65.  
  66.  
  67.                 Right, Numbers or   Converted to Right Justification
  68.                 Text                assigned to table column
  69.  
  70.            Worksheet
  71.  
  72.                 Center, Numbers     Converted to Center
  73.                 or Text             Justification assigned to entire
  74.                                     table
  75.  
  76.                 Left, Numbers or    Converted to Left Justification
  77.                 Text                assigned to entire table
  78.  
  79.                 Right, Numbers or   Converted to Right Justification
  80.                 Text                assigned to entire table
  81.  
  82.       Attributes
  83.  
  84.            Alternate Font, Select   Converted to Italics attribute
  85.                                     (PlanPerfect 3.0 files only)
  86.  
  87.            Bold                     Converted to Bold attribute
  88.  
  89.            Cell or Block            Converted to attribute(s)
  90.                                     assigned to the current table
  91.                                     cell or block
  92.  
  93.            Column                   Converted to attribute(s)
  94.                                     assigned to the current table
  95.                                     column
  96.  
  97.            Double-Underline         Converted to Double-Underline
  98.                                     attribute
  99.  
  100.            Font                     Converted to font/size codes
  101.                                     within table cell
  102.  
  103.            Hide                     Converted to hidden text
  104.  
  105.            Italics                  Converted to Italics attribute
  106.  
  107.            Underline                Converted to Underline attribute
  108.  
  109.            Worksheet                Converted to attributes assigned
  110.                                     to the entire table
  111.  
  112.            Zero Suppress (Hide If   If a cell value is zero, it is
  113.            Zero)                    converted to hidden text.
  114.                                     Otherwise, no change.
  115.  
  116.       Column
  117.  
  118.            Column Width             Converted to approximate inch
  119.                                     equivalent
  120.  
  121.            Suppress                 Not converted
  122.  
  123.       Edit
  124.  
  125.            Appearance               Converted to equivalent
  126.                                     appearance attribute
  127.  
  128.            Size                     Converted to equivalent size
  129.                                     attribute
  130.  
  131.  
  132.       Format Page
  133.  
  134.            Headers/Footers
  135.  
  136.                 Text                Converted to header/footer text,
  137.                                     except if imported into existing
  138.                                     WordPerfect 6.0 document.
  139.  
  140.                 Alignment (|)       Use of | character to create
  141.                                     alignment is converted to
  142.                                     appropriate alignment codes
  143.                                     within header or footer.
  144.  
  145.                 Cell Reference      Not converted
  146.  
  147.                 ^B (Pg. Number)     Converted to Page Numbering code
  148.                                     within header or footer
  149.  
  150.                 ^D (Date)           Converted to Date code within
  151.                                     header or footer
  152.  
  153.            Line Height              Converted to line height code
  154.  
  155.            Margins
  156.  
  157.                 Bottom              Converted to Bottom Margin Code
  158.  
  159.                 Left                Converted to Left Margin code
  160.  
  161.                 Right               Converted to Right Margin code
  162.  
  163.                 Top                 Converted to Top Margin code
  164.  
  165.            Number Pages             Converted to Page Numbering code
  166.  
  167.            Page Number Position     Converted to Page Numbering code
  168.  
  169.            Paper/Size Type          Converted to Paper Size/Type
  170.                                     code
  171.  
  172.            Print 
  173.  
  174.                 Borders Y/N         Not converted
  175.  
  176.                 Print Titles Y/N    Not converted
  177.  
  178.            Printer Functions
  179.  
  180.                 Kerning             Kerning
  181.  
  182.       Type
  183.  
  184.            Accounting               Converted to Accounting number
  185.                                     type format
  186.  
  187.            Comma                    Converted to Comma number type
  188.                                     format
  189.  
  190.            Currency                 Converted to Currency number
  191.                                     type format
  192.  
  193.            Date                     Converted to Date number type
  194.                                     format
  195.  
  196.  
  197.            Decimal Aligned          Converted to the General number
  198.            Numbers                  type format, Left justification,
  199.                                     and Decimal Alignment position
  200.                                     at n digits.
  201.  
  202.            Fixed                    Converted to the Fixed number
  203.                                     type format
  204.  
  205.            General                  Converted to the General number
  206.                                     type format
  207.  
  208.            Integer                  Converted to the Integer number
  209.                                     type format
  210.  
  211.            Other
  212.  
  213.                 Commas              Not converted
  214.  
  215.                 Decimal Precision   Not converted
  216.  
  217.                 Gutter Space        Not converted
  218.  
  219.                 Negative Number     Not converted
  220.                 options
  221.  
  222.                 Parentheses         Not converted
  223.  
  224.                 Round for Calc.     Not converted
  225.  
  226.                 Spec. Characters    Not converted
  227.  
  228.            Percent                  Converted to the Percent number
  229.                                     type format
  230.  
  231.            Scientific               Converted to the Scientific
  232.                                     number type format
  233.  
  234.            Text Format              Converted to the Text type
  235.                                     format
  236.  
  237.            Date/Time Format         Converted to the Date/Time type
  238.                                     format
  239.  
  240.       Worksheet
  241.  
  242.            Borders, Display         Not converted
  243.  
  244.            Display
  245.  
  246.                 Formulas            Not converted
  247.  
  248.                 Spec. Char          Not converted
  249.                 Argument
  250.                 Separator
  251.  
  252.                 Spec. Char.         Converted to one of the currency
  253.                 Currency            formats listed in the .LRS file
  254.                 Symbol(S)
  255.  
  256.                 Spec. Char.         Converted to Decimal Align
  257.                 Decimal Align       Character code
  258.  
  259.  
  260.                 Spec. Char.         Converted to Thousands Separator
  261.                 Thousands           code
  262.                 Separator
  263.  
  264.            Sort Language            Converted to Language code
  265.  
  266.            Summary                  Converted to Document Summary
  267.  
  268.            Width                    Converted to table Column Width
  269.                                     setting
  270.  
  271.  Formula
  272.  
  273.       Absolute                      Converted to absolute cell
  274.                                     reference (entire cell reference
  275.                                     enclosed in square brackets)
  276.  
  277.       Logical Operators >, <, =,    Converted to equivalent logical
  278.       <>, >=, <=                    operators
  279.  
  280.       Mixed                         Converted to mixed cell
  281.                                     reference (square brackets may
  282.                                     surround either column reference
  283.                                     letter or row reference number)
  284.  
  285.       Operators +, -, /, *, ^, %    Converted to equivalent
  286.                                     arithmetic operators
  287.  
  288.       Relative                      Converted to cell reference
  289.  
  290.  Functions
  291.  
  292.       Arithmetic Functions
  293.  
  294.            ABS()                    ABS()
  295.  
  296.            ACOS()                   ACOS()
  297.  
  298.            ASIN()                   ASIN()
  299.  
  300.            ATAN()                   ATAN()
  301.  
  302.            ATAN2()                  ATAN2()
  303.  
  304.            AVE()                    AVE()
  305.  
  306.            COS()                    COS()
  307.  
  308.            DEGREES()                DEGREES()
  309.  
  310.            EXP()                    EXP()
  311.  
  312.            FACT()                   FACT()
  313.  
  314.            INT()                    INT()
  315.  
  316.            LN()                     LN()
  317.  
  318.            LOG()                    LOG()
  319.  
  320.            MAX()                    MAX()
  321.  
  322.            MIN()                    MIN()
  323.  
  324.  
  325.            MINUS()                  MINUS()
  326.  
  327.            MOD()                    MOD()
  328.  
  329.            PI()                     PI()
  330.  
  331.            POWER()                  POWER()
  332.  
  333.            PRODUCT()                PRODUCT()
  334.  
  335.            QUOTIENT()               QUOTIENT()
  336.  
  337.            RADIANS()                RADIANS()
  338.  
  339.            RANDOM()                 RANDOM()
  340.  
  341.            ROUND()                  ROUND()
  342.  
  343.            SIN()                    SIN()
  344.  
  345.            SQRT()                   SQRT()
  346.  
  347.            STDEV()                  STDEV()
  348.  
  349.            STDEVP()                 STDEVP()
  350.  
  351.            SUBTRACT()               SUBTRACT()
  352.  
  353.            SUM()                    SUM()
  354.  
  355.            TAN()                    TAN()
  356.  
  357.            VAR()                    VAR()
  358.  
  359.            VARP()                   VARP()
  360.  
  361.       Date & Time Functions
  362.  
  363.            DATE()                   DATE()
  364.  
  365.            DATETEXT()               DATETEXT()
  366.  
  367.            DATEVALUE()              DATEVALUE()
  368.  
  369.            DAY()                    DAY()
  370.  
  371.            HMS()                    HMS()
  372.  
  373.            HOUR()                   HOUR()
  374.  
  375.            MDY()                    MDY()
  376.  
  377.            MINUTE()                 MINUTE()
  378.  
  379.            MONTH()                  MONTH()
  380.  
  381.            SECOND()                 SECOND()
  382.  
  383.            TIME()                   TIME()
  384.  
  385.            TIMETEXT()               TIMETEXT()
  386.  
  387.            TIMEVALUE()              TIMEVALUE()
  388.  
  389.  
  390.            YEAR()                   YEAR()
  391.  
  392.       Financial Functions
  393.  
  394.            DDB()                    DDB()
  395.  
  396.            FV()                     FV()
  397.  
  398.            IRR()                    IRR()
  399.  
  400.            NPV()                    NPV()
  401.  
  402.            PMT()                    PMT()
  403.  
  404.            PV()                     PV()
  405.  
  406.            RATE()                   RATE()
  407.  
  408.            SLN()                    SLN()
  409.  
  410.            SYD()                    SYD()
  411.  
  412.            TERM()                   TERM()
  413.  
  414.       Logical Functions
  415.  
  416.            AND()                    AND()
  417.  
  418.            FALSE()                  FALSE()
  419.  
  420.            FOREACH()                Not converted
  421.  
  422.            IF()                     IF()
  423.  
  424.            ISERR()                  ISERR()
  425.  
  426.            ISERR2()                 ISERR2()
  427.  
  428.            ISNA()                   ISNA()
  429.  
  430.            ISTEXT()                 ISTEXT()
  431.  
  432.            ISVALUE()                ISVALUE()
  433.  
  434.            NA()                     NA()
  435.  
  436.            NOT()                    NOT()
  437.  
  438.            OR()                     OR()
  439.  
  440.            SIGN()                   SIGN()
  441.  
  442.            TRUE()                   TRUE()
  443.  
  444.       Special Functions
  445.  
  446.            BLOCK()                  BLOCK()
  447.  
  448.            CELL()                   CELL()
  449.  
  450.            CHOOSE()                 CHOOSE()
  451.  
  452.            COL()                    COL()
  453.  
  454.  
  455.            COUNT()                  COUNT()
  456.  
  457.            CURSOR()                 Not converted
  458.  
  459.            INDEX()                  INDEX()
  460.  
  461.            ITERATION()              Not converted
  462.  
  463.            LOOKUP()                 LOOKUP()
  464.  
  465.            LOOKUP2()                LOOKUP2()
  466.  
  467.            MATCH()                  MATCH()
  468.  
  469.            MATCH2()                 MATCH2()
  470.  
  471.            ROW()                    ROW()
  472.  
  473.            STATUS()                 Not converted
  474.  
  475.       Text Functions
  476.  
  477.            CHAR()                   CHAR()
  478.  
  479.            CODE()                   CODE()
  480.  
  481.            CONCAT()                 CONCAT()
  482.  
  483.            CURRENCY()               CURRENCY()
  484.  
  485.            FIND()                   FIND()
  486.  
  487.            LEFT()                   LEFT()
  488.  
  489.            LENGTH()                 LENGTH()
  490.  
  491.            LOWER()                  LOWER()
  492.  
  493.            MID()                    MID()
  494.  
  495.            PROPER()                 PROPER()
  496.  
  497.            REPEAT()                 REPEAT()
  498.  
  499.            REPLACE()                REPLACE()
  500.  
  501.            RIGHT()                  RIGHT()
  502.  
  503.            TEXT()                   TEXT()
  504.  
  505.            TRIM()                   TRIM()
  506.  
  507.            UPPER()                  UPPER()
  508.  
  509.            VALUE()                  VALUE()
  510.  
  511.  Graph                              Graphs are not supported in
  512.                                     WordPerfect 6.0
  513.  
  514.  Help, Cell Message                 Not converted
  515.  
  516.  Insert
  517.  
  518.       Printer Command               Not converted
  519.  
  520.  
  521.  Lock/Unlock
  522.  
  523.       Cell                          Converted to locked cell
  524.  
  525.       Column                        Converted to locked column
  526.  
  527.       Worksheet                     Converted to locked except blank
  528.                                     cells, which are converted to
  529.                                     Unlocked cells
  530.  
  531.  Macro
  532.  
  533.       Cell Macro                    Cell macros are not supported in
  534.                                     WordPerfect 6.0
  535.  
  536.  Model Mode On/Off                  Spreadsheet Model Mode is not
  537.                                     supported in WordPerfect 6.0
  538.  
  539.  Named
  540.  
  541.       Blocks                        Converted to named table block
  542.  
  543.       Cell                          Converted to named table cell(s)
  544.  
  545.       Columns                       Converted to named table
  546.                                     column(s)
  547.  
  548.       Rows                          Converted to named table
  549.                                     column(s)
  550.  
  551.  Page Break (\\Page)                Converted to a soft page break
  552.                                     within the table
  553.  
  554.  Password Add/Delete                Converted to document password
  555.  
  556.  Screen
  557.  
  558.       Titles 
  559.  
  560.            Across                   Converted to a Header Row
  561.  
  562.            Lock Y/N                 Converted to Unlock
  563.  
  564.  
  565.  
  566. Importing spreadsheets up to 64 columns is supported.  If you try to
  567. import a spreadsheet with more than 64 columns, all columns after the
  568. 64th column are truncated.
  569.  
  570. Importing a spreadsheet into a WordPerfect 6.0 document changes the
  571. Table Line defaults for all following tables to "None."  Tables
  572. following the imported spreadsheet will need to be edited and changed
  573. to restore the table lines and borders.
  574.  
  575. A period (.) in a table name is converted to an underscore (_).
  576.  
  577. Reference in a Header or Footer to a cell such as <A8> converts to the
  578. actual text <A8> instead of the contents of cell A8.
  579.  
  580. Functions not supported in WordPerfect 6.0 tables will convert as the
  581. calculated value of that function.  
  582.  
  583. Hidden columns will convert to a column width of .001.  Changing the
  584. column width in WordPerfect 6.0 will expand hidden columns and turning
  585.  
  586. on the 'Show All Hidden Text' option will allow the data in each table
  587. cell to be viewed.
  588.  
  589. Blank cells in a spreadsheet with global protection on will convert
  590. unlocked.
  591.