home *** CD-ROM | disk | FTP | other *** search
/ High Voltage Shareware / high1.zip / high1 / DIR8 / ADCONV60.ZIP / QPROWIN.DOC < prev    next >
Text File  |  1993-06-01  |  14KB  |  510 lines
  1.  
  2. This document deals with conversion of features from Quattro Pro 1.0
  3. for Windows to WordPerfect 6.0.  Currently, converting tables from
  4. WordPerfect 6.0 to Quattro Pro for Windows is not supported.
  5.  
  6.  
  7.  
  8.  QUATTRO PRO 1.0 for WINDOWS         WORDPERFECT 6.0
  9.  ===========================         ===============
  10.  
  11.  [Block]
  12.  
  13.       Cell Alignment
  14.  
  15.            Center                    Cell Format:Alignment
  16.                                      Justification: Center
  17.  
  18.            General                   Text Left/Numeric Right
  19.  
  20.            Left                      Cell Format:Alignment
  21.                                      Justification: Left
  22.  
  23.            Right                     Cell Format:Alignment
  24.                                      Justification: Right
  25.  
  26.       Cell Protection
  27.  
  28.            Protect                   Cell: Lock
  29.  
  30.            Unprotect                 Cell: Lock(Toggle)
  31.  
  32.       Column Width
  33.  
  34.            Auto Width                Not converted
  35.  
  36.            Reset Width               Not converted
  37.  
  38.            Set Width                 Column: Width #8
  39.  
  40.       Data Entry Input
  41.  
  42.            Dates Only                Maintained
  43.  
  44.            General                   Maintained
  45.  
  46.            Labels Only               Maintained
  47.  
  48.       Font
  49.  
  50.            Bold                      Bold
  51.  
  52.            Italic                    Italic
  53.  
  54.            Point sizes               Point Sizes
  55.  
  56.            Strikeout                 Not converted
  57.  
  58.            Type faces                Maintained
  59.  
  60.            Underlined                Not converted
  61.  
  62.       Line Drawing
  63.  
  64.            Line Segments
  65.  
  66.                 All                  Lines: All
  67.  
  68.  
  69.                 Inside               Lines: Inside
  70.  
  71.                 Outline              Lines: Outline
  72.  
  73.            Line Types
  74.  
  75.                 Double               Lines: Thick
  76.  
  77.                 No change            Not converted
  78.  
  79.                 No line              Lines: Single 
  80.  
  81.                 Single               Lines: Single
  82.  
  83.                 Thick                Lines: Thick
  84.  
  85.       Numeric Format
  86.  
  87.            , (comma)                 Number Type Format: Comma
  88.  
  89.            +/-                       Number Type Format: General
  90.  
  91.            Currency                  Number Type Format: Currency
  92.  
  93.            Date
  94.  
  95.                 1-(DD-MMM-YY)        Date Type Format: #4
  96.  
  97.                 2-(DD-MMM)           Date Type Format: B
  98.  
  99.                 1-(MMM-YY)           Date Type Format: #4
  100.  
  101.                 (Long Intl.)         Date Type Format: #2
  102.  
  103.                 (Short Intl.)        Date Type Format: A
  104.  
  105.            Fixed                     Number Type Format: Fixed
  106.  
  107.            General                   Number Type Format: General
  108.  
  109.            Hidden                    Mark Hidden Text: Hidden
  110.  
  111.            Percent                   Number Type Format: Percent
  112.  
  113.            Scientific                Number Type Format: Scientific
  114.  
  115.            Text                      Number Type Format: Text
  116.  
  117.            Time
  118.  
  119.                 1-(HH:MM:SS AM/PM)   Date Type Format: #6
  120.  
  121.                 2-(HH:MM AM/PM)      Date Type Format: #6
  122.  
  123.                 3-(Long Intl.)       Date Type Format: C
  124.  
  125.                 4-(Short Intl.)      Date Type Format: C
  126.  
  127.            User Defined              Not converted
  128.  
  129.       Reveal/Hide
  130.  
  131.            Hide Column               Mark: Hidden Text: Hidden
  132.  
  133.  
  134.            Hide Row                  Not converted
  135.  
  136.            Reveal Column             Mark: Hidden Text: Show All
  137.                                      Hidden Text
  138.  
  139.            Reveal Row                Not converted
  140.  
  141.       Row Height                     Not converted
  142.  
  143.       Shading
  144.  
  145.            Color blend 1-7           10% Shaded Fill
  146.  
  147.            Color, 1,2 - Blend        10% Shaded Fill
  148.  
  149.            None                      No Shading
  150.  
  151.       Text color                     Not converted
  152.  
  153.  [Page]
  154.  
  155.       Borders                        Not converted
  156.  
  157.       Conditional color              Not converted
  158.  
  159.       Default Width                  Maintained
  160.  
  161.            Unit: Char, In.,          Not converted
  162.            Centim.
  163.  
  164.            Width                     Maintained
  165.  
  166.       Display Zeros                  Not converted
  167.  
  168.       Line color Color Palette       Not converted
  169.       options
  170.  
  171.       Label Alignment
  172.  
  173.            Center                    Cell Format: Center Aligned
  174.  
  175.            Left                      Cell Format: Left Aligned
  176.  
  177.            Right                     Cell Format: Right Aligned
  178.  
  179.       Grid Lines                     Not converted
  180.  
  181.       Name                           Not converted
  182.  
  183.  FILE
  184.  
  185.       Page Setup
  186.  
  187.            Footer                    Footer - except when imported
  188.                                      into an existing WordPerfect 6.0
  189.                                      document
  190.  
  191.            Header                    Header - except when imported
  192.                                      into an existing WordPerfect 6.0
  193.                                      document
  194.  
  195.            Margins: Footer           Not converted
  196.  
  197.            Margins: Right            Margin [Right]
  198.  
  199.  
  200.            Margins: Bottom           Not converted
  201.  
  202.            Margins: Header           Margin [Bottom]
  203.  
  204.            Margins: Left             Margin [Left]
  205.  
  206.            Margins: Top              Margin [Top]
  207.  
  208.            Orientation: Landscape    Page Size [Standard Landscape]
  209.  
  210.            Orientation: Portrait     Page Size [Standard Portrait]
  211.  
  212.            Paper Type: Legal         Page Size [Legal]
  213.  
  214.            Paper Type: Letter size   Page Size [Standard]
  215.  
  216.            Scaling: Percent          Not converted
  217.  
  218.  GRAPH
  219.  
  220.       2D                             Not converted
  221.  
  222.       3D                             Not converted
  223.  
  224.       Combo                          Not converted
  225.  
  226.       Series                         Not converted
  227.  
  228.       Slide Show                     Not converted
  229.  
  230.       Text                           Not converted
  231.  
  232.       Titles                         Not converted
  233.  
  234.  Database Function                   Value is converted, function is
  235.                                      dropped
  236.  
  237.  Date&Time Function
  238.  
  239.       DATE()                         DATE()
  240.  
  241.       DATEVALUE()                    DATEVALUE()
  242.  
  243.       DAY()                          DAY()
  244.  
  245.       HOUR()                         HOUR()
  246.  
  247.       MINUTE()                       MINUTE()
  248.  
  249.       MONTH()                        MONTH()
  250.  
  251.       NOW()                          MDY()+HMS()
  252.  
  253.       SECOND()                       SECOND()
  254.  
  255.       TIME()                         TIME()
  256.  
  257.       TIMEVALUE()                    VALUE()
  258.  
  259.       TODAY()                        MDY()
  260.  
  261.       YEAR()                         YEAR()
  262.  
  263.  Financial Function
  264.  
  265.  
  266.       CTERM()                        TERM()
  267.  
  268.       DDB()                          DDB()
  269.  
  270.       FV()                           FV()
  271.  
  272.       FVAL()                         Value is converted, function is
  273.                                      dropped
  274.  
  275.       IPAYMT()                       Value is converted, function is
  276.                                      dropped
  277.  
  278.       IRATE()                        Value is converted, function is
  279.                                      dropped
  280.  
  281.       IRR()                          IRR()
  282.  
  283.       NPER()                         Value is converted, function is
  284.                                      dropped
  285.  
  286.       NPV()                          NPV()
  287.  
  288.       PAYMT()                        Value is converted, function is
  289.                                      dropped
  290.  
  291.       PMT()                          PMT()
  292.  
  293.       PPAYMT()                       Value is converted, function is
  294.                                      dropped
  295.  
  296.       PV()                           PV()
  297.  
  298.       PVAL()                         Value is converted, function is
  299.                                      dropped
  300.  
  301.       RATE()                         RATE()
  302.  
  303.       SLN()                          SLN()
  304.  
  305.       SYD()                          SYD()
  306.  
  307.       TERM()                         TERM()
  308.  
  309.  Logical Function
  310.  
  311.       FALSE()                        FALSE()
  312.  
  313.       FILEEXISTS()                   Not converted
  314.  
  315.       IF()                           IF()
  316.  
  317.       ISERR()                        ISERR()
  318.  
  319.       ISNA()                         ISNA()
  320.  
  321.       ISNUMBER()                     ISVALUE()
  322.  
  323.       ISSTRING()                     ISTEXT()
  324.  
  325.       TRUE()                         TRUE()
  326.  
  327.  Mathematical Function
  328.  
  329.       ABS()                          ABS()
  330.  
  331.  
  332.       ACOS()                         ACOS()
  333.  
  334.       ASIN()                         ASIN()
  335.  
  336.       ATAN()                         AATAN()
  337.  
  338.       ATAN2()                        ATAN2()
  339.  
  340.       COS()                          COS()
  341.  
  342.       DEGREES()                      DEGREES()
  343.  
  344.       EXP()                          EXP()
  345.  
  346.       INT()                          INT()
  347.  
  348.       LN()                           LN()
  349.  
  350.       LOG()                          LOG()
  351.  
  352.       MOD()                          MOD()
  353.  
  354.       PI()                           PI()
  355.  
  356.       RADIANS()                      RADIANS()
  357.  
  358.       RAND()                         RANDOM()
  359.  
  360.       ROUND()                        ROUND()
  361.  
  362.       SIN()                          SIN()
  363.  
  364.       SQRT()                         SQRT()
  365.  
  366.  Miscellaneous Function
  367.  
  368.       @@(CELL)
  369.  
  370.       CELL()                         Not converted
  371.  
  372.       CELLINDEX()                    Not converted
  373.  
  374.       CELLPOINTER()                  Not converted
  375.  
  376.       CHOOSE()                       CHOOSE()
  377.  
  378.       COLS()                         Not converted
  379.  
  380.       COMMAND()                      Not converted
  381.  
  382.       CURVALUE()                     Not converted
  383.  
  384.       DDELINK()                      Not converted
  385.  
  386.       ERR()                          Not converted
  387.  
  388.       HLOOKUP()                      LOOKUP()
  389.  
  390.       INDEX()                        INDEX()
  391.  
  392.       MEMAVAIL()                     Not converted
  393.  
  394.       MEMEMSAVAIL()                  Not converted
  395.  
  396.  
  397.       NA()                           NA()
  398.  
  399.       PROPERTY()                     Not converted
  400.  
  401.       ROWS()                         Not converted
  402.  
  403.       SHEETS()                       Not converted
  404.  
  405.       VERSION()                      Not converted
  406.  
  407.       VLOOKUP()                      LOOKUP()
  408.  
  409.  Statistical Function
  410.  
  411.       AVG()                          AVE()
  412.  
  413.       COUNT()                        COUNT()
  414.  
  415.       MAX()                          MAX()
  416.  
  417.       MIN()                          MIN()
  418.  
  419.       STD()                          STDEV()
  420.  
  421.       STDS()                         STDEV()
  422.  
  423.       SUM()                          SUM()
  424.  
  425.       SUMPRODUCT()                   Value is converted, function is
  426.                                      dropped
  427.  
  428.       VAR()                          VAR()
  429.  
  430.       VARS()                         VAR()
  431.  
  432.  String Function
  433.  
  434.       CHAR()                         CHAR()
  435.  
  436.       CLEAN()                        Not converted
  437.  
  438.       CODE()                         Not converted
  439.  
  440.       EXACT()                        Not converted
  441.  
  442.       FIND()                         Not converted
  443.  
  444.       HEXTONUM()                     Not converted
  445.  
  446.       LEFT()                         LEFT()
  447.  
  448.       LENGTH()                       LENGTH()
  449.  
  450.       LOWER()                        LOWER()
  451.  
  452.       MID()                          MID()
  453.  
  454.       N()                            Not converted
  455.  
  456.       NUMTOHEX()                     Not converted
  457.  
  458.       PROPER()                       PROPER()
  459.  
  460.       REPEAT()                       REPEAT()
  461.  
  462.  
  463.       REPLACE()                      Not converted
  464.  
  465.       RIGHT()                        RIGHT()
  466.  
  467.       S()                            Not converted
  468.  
  469.       STRING()                       TEXT()
  470.  
  471.       TRIM()                         Not converted
  472.  
  473.       UPPER()                        UPPER()
  474.  
  475.  
  476.  
  477. Cells which contain text such as a phone number or a social security
  478. number will be interpreted as a formula unless they have been inserted
  479. using the instructions Quattro Pro provides for text in cells.
  480.  
  481. Quattro Pro files that have a line draw line on the right side of the
  482. spreadsheet will have an extra column inserted in the WordPerfect 6.0
  483. table when converted.  A line draw line at the bottom of the
  484. spreadsheet will insert an extra row at the bottom of the WordPerfect
  485. 6.0 table when converted.
  486.  
  487. Basic formulas need to be recalculated in the WordPerfect 6.0 table
  488. after conversion.
  489.  
  490. Converted tables must be recalculated after conversion for  values to
  491. print and display properly.
  492.  
  493. Hidden columns will convert to a column width of .001.  Changing the
  494. column width in WordPerfect 6.0 will expand hidden columns and turning
  495. on the 'Show All Hidden Text' option will allow the data in each table
  496. cell to be viewed.
  497.  
  498. Functions not supported in WordPerfect 6.0 tables will convert as a 0
  499. and must be recalculated after conversion for the values to print and
  500. display properly.  Database functions not supported in WordPerfect 6.0
  501. tables will convert as a 0.
  502.  
  503. Importing spreadsheets up to 64 columns is supported.  If you try to
  504. import a spreadsheet with more than 64 columns, all columns after the
  505. 64th column are truncated.
  506.  
  507. Importing a spreadsheet into a WordPerfect 6.0 document changes the
  508. Table Line defaults for all following tables to "None."  Tables
  509. following the imported spreadsheet will need to be edited and changed
  510. to restore the table lines and borders.