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