home *** CD-ROM | disk | FTP | other *** search
/ Network Support Encyclopedia 96-1 / novell-nsepro-1996-1-cd2.iso / download / app / adcov6.exe / EXCEL.DOC < prev    next >
Text File  |  1994-02-14  |  21KB  |  819 lines
  1. ================================================================
  2. EXCEL.DOC
  3. ================================================================
  4.  
  5. This document deals with conversion of features from Excel 2.1,
  6. 3.0, and 4.0 to WordPerfect 6.0.  Currently, converting tables
  7. from WordPerfect 6.0 to Excel is not supported.
  8.  
  9.  
  10. ================================================================
  11. Section 1 - Excel 2.1, 3.0 and 4.0 to WordPerfect 6.0
  12. ================================================================
  13.  
  14. The following table shows how codes are converted from Excel
  15. format to WordPerfect 6.0.
  16.  
  17.  EXCEL 2.1, 3.0 and 4.0            WORDPERFECT 6.0
  18.  ======================            ===========
  19.  
  20.  Alignment
  21.  
  22.       Center                       Center
  23.  
  24.       Enter/Tab                    Not Applicable
  25.  
  26.       Fill                         Left Align, repeat characters
  27.                                    until cell full
  28.  
  29.       General                      Right align if number, all
  30.                                    else Left
  31.  
  32.       Justify                      Left and Right
  33.  
  34.       Left                         Left
  35.  
  36.       Right                        Right
  37.  
  38.       Wrap text                    Cells won't combine for long
  39.                                    text
  40.  
  41.  Charts                            Charts not supported
  42.  
  43.  File
  44.  
  45.       Page Set-up
  46.  
  47.            Footer                  Footer - except if imported
  48.                                    into an existing WordPerfect
  49.                                    6.0 document
  50.  
  51.            Header                  Header - except if imported
  52.                                    into an existing WordPerfect
  53.                                    6.0 document
  54.  
  55.            Margins-Bottom          Bottom Margin
  56.  
  57.            Margins-Top             Top Margin
  58.  
  59.            Margins-Left            Left Margin
  60.  
  61.            Margins-Right           Right Margin
  62.  
  63.            Orientation-Landscape   Landscape
  64.  
  65.            Orientation-Portrait    Portrait
  66.  
  67.            Paper Size              Paper Size
  68.  
  69.  Format
  70.  
  71.       Auto Format                  Not Applicable
  72.  
  73.       Border                       Not Converted
  74.  
  75.       Cell Protection
  76.  
  77.            Hidden                  Hidden (except blank cells)
  78.  
  79.            Locked                  Locked (except blank cells)
  80.  
  81.       Center across section        Center
  82.  
  83.       Column Width
  84.  
  85.            Best fit                Maintains column width
  86.  
  87.            Hide                    Hidden
  88.  
  89.            UnHide                  Show all Hidden Text
  90.  
  91.            Width                   Column: Width #8
  92.  
  93.       Font
  94.  
  95.            Color                   Color
  96.  
  97.            Effect Underline        Underline
  98.  
  99.            Effect Strikeout        Strikeout
  100.  
  101.            Name                    Converts as close as possible
  102.  
  103.            Size                    Size
  104.  
  105.            Style Bold Italic       Bold Italic
  106.  
  107.            Style Bold              Bold
  108.  
  109.            Style Italic            Italic
  110.  
  111.            Style Regular           Normal
  112.  
  113.       Justify                      Left and Right Align
  114.  
  115.       Number
  116.  
  117.            All/General             General
  118.  
  119.            Currency                Currency
  120.  
  121.            Date                    Date Type Formats
  122.  
  123.            Fraction                General, rounds to whole
  124.                                    number
  125.  
  126.            Number                  Fixed
  127.  
  128.            Percent                 Percent
  129.  
  130.            Scientific              Scientific
  131.  
  132.            Time                    Date/Time Formats
  133.  
  134.       Patterns
  135.  
  136.            Background              10% Shade Fill
  137.  
  138.            Cell Shading            10% Shade Fill
  139.  
  140.            Foreground              10% Shade Fill
  141.  
  142.       Row Height
  143.  
  144.            Hide                    Hidden
  145.  
  146.            Non Standard            Row Height
  147.  
  148.            Standard                Row Height
  149.  
  150.            UnHide                  Show all Hidden Text
  151.  
  152.       Style                        Not Applicable
  153.  
  154.       Text orientation             Horizontal only is converted
  155.  
  156.       Vertical Center              Not Converted
  157.  
  158.       Vertical Bottom              Not Converted
  159.  
  160.       Vertical Top                 Not Converted
  161.  
  162.  Functions                         Please see list of supported
  163.                                    functions in Section 2
  164.  
  165.  Macros                            Not Converted
  166.  
  167.  Options
  168.  
  169.       Calculation                  Not Converted
  170.  
  171.       Protect Document             Cannot convert if password is
  172.                                    set
  173.  
  174.       Set Page Break               Horizontal Page Breaks
  175.  
  176.  
  177. Importing spreadsheets up to 64 columns is supported.  If you try
  178. to import a spreadsheet with more than 64 columns, all columns
  179. after the 64th column are truncated.
  180.  
  181. Importing a spreadsheet into a WordPerfect 6.0 document changes
  182. the Table Line defaults for all following tables to "None." 
  183. Tables following the imported spreadsheet will need to be edited
  184. and changed to restore the table lines and borders.
  185.  
  186. Range names longer than 25 characters are not converted.
  187.  
  188. Hidden cells convert unhidden.
  189.  
  190. Vertically aligned text will convert as horizontal.
  191.  
  192. Border line draw will convert to default table lines.
  193.  
  194. Hidden columns will convert to a column width of .001.  Changing
  195. the column width in WordPerfect 6.0 will expand hidden columns.
  196.  
  197.  
  198. ================================================================
  199. Section 2 - Excel Function Codes
  200. ================================================================
  201.  
  202. The following table shows Excel Functions and how they convert to
  203. WordPerfect 6.0.
  204.  
  205.  EXCEL FUNCTIONS                  WordPerfect 6.0
  206.  ===============                  ===============
  207.  
  208.  ABS()                            ABS()
  209.  
  210.  ACCRINT()                        Not converted
  211.  
  212.  ACCRINTM()                       Not converted
  213.  
  214.  ACOS()                           ACOS()
  215.  
  216.  ACOSH()                          Not converted
  217.  
  218.  ADDRESS()                        Not converted
  219.  
  220.  AND()                            AND()
  221.  
  222.  AREAS()                          Not converted
  223.  
  224.  ASIN()                           ASIN()
  225.  
  226.  ASINH()                          Not converted
  227.  
  228.  ATAN()                           ATAN()
  229.  
  230.  ATAN2()                          ATAN2()
  231.  
  232.  ATANH()                          Not converted
  233.  
  234.  AVERAGE()                        AVE()
  235.  
  236.  BASE()                           Not converted
  237.  
  238.  BESSELI()                        Not converted
  239.  
  240.  BESSELJ()                        Not converted
  241.  
  242.  BESSELK()                        Not converted
  243.  
  244.  BESSELY()                        Not converted
  245.  
  246.  BETADIST()                       Not converted
  247.  
  248.  BETAINV()                        Not converted
  249.  
  250.  BIN2DEC()                        Not converted
  251.  
  252.  BIN2HEX()                        Not converted
  253.  
  254.  BIN2OCT()                        Not converted
  255.  
  256.  BINOMDIST()                      Not converted
  257.  
  258.  CALL()                           Not converted
  259.  
  260.  CEILING()                        Not converted
  261.  
  262.  CELL()                           Not converted
  263.  
  264.  CHAR()                           CHAR()
  265.  
  266.  CHIDIST()                        Not converted
  267.  
  268.  CHIINV()                         Not converted
  269.  
  270.  CHITEST()                        Not converted
  271.  
  272.  CHOOSE()                         CHOOSE()
  273.  
  274.  CLEAN()                          Not converted
  275.  
  276.  CODE()                           Not converted
  277.  
  278.  COLUMN()                         Column (arguments) is not
  279.                                   supported
  280.  
  281.  COLUMNS()                        Not converted
  282.  
  283.  COMBIN()                         Not converted
  284.  
  285.  COMPLEX()                        Not converted
  286.  
  287.  CONFIDENCE()                     Not converted
  288.  
  289.  CONVERT()                        Not converted
  290.  
  291.  CORREL()                         Not converted
  292.  
  293.  COS()                            COS()
  294.  
  295.  COSH()                           Not converted
  296.  
  297.  COUNT()                          COUNT()
  298.  
  299.  COUNTA()                         COUNT()
  300.  
  301.  COUPDAYBS()                      Not converted
  302.  
  303.  COUPDAYS()                       Not converted
  304.  
  305.  COUPDAYSNC()                     Not converted
  306.  
  307.  COUPNCD()                        Not converted
  308.  
  309.  COUPNUM()                        Not converted
  310.  
  311.  COUPPCD()                        Not converted
  312.  
  313.  COVAR()                          Not converted
  314.  
  315.  CRITBINOM()                      Not converted
  316.  
  317.  CROSSTAB()                       Not converted
  318.  
  319.  CUMIPMT()                        Not converted
  320.  
  321.  CUMPRINC()                       Not converted
  322.  
  323.  DATE()                           DATE()
  324.  
  325.  DATEVALUE()                      DATEVALUE()
  326.  
  327.  DAVERAGE()                       Not converted
  328.  
  329.  DAY()                            DAY()
  330.  
  331.  DAYS360()                        Not converted
  332.  
  333.  DB()                             Not converted
  334.  
  335.  DCOUNT()                         Not converted
  336.  
  337.  DCOUNTA()                        Not converted
  338.  
  339.  DDB()                            DDB()
  340.  
  341.  DEC2BIN()                        Not converted
  342.  
  343.  DEC2HEX()                        Not converted
  344.  
  345.  DEC2OCT()                        Not converted
  346.  
  347.  DELTA()                          Not converted
  348.  
  349.  DEVSQ()                          Not converted
  350.  
  351.  DGET()                           Not converted
  352.  
  353.  DISC()                           Not converted
  354.  
  355.  DMAX()                           Not converted
  356.  
  357.  DMIN()                           Not converted
  358.  
  359.  DOLLAR()                         CURRENCY()
  360.  
  361.  DOLLARDE()                       Not converted
  362.  
  363.  DOLLARFR()                       Not converted
  364.  
  365.  DPRODUCT()                       Not converted
  366.  
  367.  DSTDEV()                         Not converted
  368.  
  369.  DSTDEVP()                        Not converted
  370.  
  371.  DSUM()                           Not converted
  372.  
  373.  DURATION()                       Not converted
  374.  
  375.  DVAR()                           Not converted
  376.  
  377.  DVARP()                          Not converted
  378.  
  379.  EDATE()                          Not converted
  380.  
  381.  EFFECT()                         Not converted
  382.  
  383.  EOMONTH()                        Not converted
  384.  
  385.  ERF()                            Not converted
  386.  
  387.  ERFC()                           Not converted
  388.  
  389.  ERROR.TYPE()                     Not converted
  390.  
  391.  EVEN()                           Not converted
  392.  
  393.  EXACT()                          Not converted
  394.  
  395.  EXP()                            EXP()
  396.  
  397.  EXPONDIST()                      Not converted
  398.  
  399.  FACT()                           FACT()
  400.  
  401.  FACTDOUBLE()                     Not converted
  402.  
  403.  FALSE()                          FALSE()
  404.  
  405.  FDIST()                          Not converted
  406.  
  407.  FIND()                           FIND()
  408.  
  409.  FINV()                           Not converted
  410.  
  411.  FISHER()                         Not converted
  412.  
  413.  FISHERINV()                      Not converted
  414.  
  415.  FIXED()                          TEXT()
  416.  
  417.  FLOOR()                          Not converted
  418.  
  419.  FORECAST()                       Not converted
  420.  
  421.  FREQUENCY()                      Not converted
  422.  
  423.  FTEST()                          Not converted
  424.  
  425.  FV()                             FV()
  426.  
  427.  FVSCHEDULE()                     Not converted
  428.  
  429.  GAMMADIST()                      Not converted
  430.  
  431.  GAMMAINV()                       Not converted
  432.  
  433.  GAMMALN()                        Not converted
  434.  
  435.  GCD()                            Not converted
  436.  
  437.  GEOMEAN()                        Not converted
  438.  
  439.  GESTEP()                         Not converted
  440.  
  441.  GROWTH()                         Not converted
  442.  
  443.  HARMEAN()                        Not converted
  444.  
  445.  HEX2BIN()                        Not converted
  446.  
  447.  HEX2DEC()                        Not converted
  448.  
  449.  HEX2OCT()                        Not converted
  450.  
  451.  HLOOKUP()                        LOOKUP()
  452.  
  453.  HOUR()                           HOUR()
  454.  
  455.  HYPGEOMDIST()                    Not converted
  456.  
  457.  IF()                             IF()
  458.  
  459.  IMABS()                          Not converted
  460.  
  461.  IMAGINARY()                      Not converted
  462.  
  463.  IMARGUMENT()                     Not converted
  464.  
  465.  IMCONJUGATE()                    Not converted
  466.  
  467.  IMCOS()                          Not converted
  468.  
  469.  IMDIV()                          Not converted
  470.  
  471.  IMEXP()                          Not converted
  472.  
  473.  IMLN()                           Not converted
  474.  
  475.  IMLOG10()                        Not converted
  476.  
  477.  IMLOG2()                         Not converted
  478.  
  479.  IMPOWER()                        Not converted
  480.  
  481.  IMPRODUCT()                      Not converted
  482.  
  483.  IMREAL()                         Not converted
  484.  
  485.  IMSIN()                          Not converted
  486.  
  487.  IMSQRT()                         Not converted
  488.  
  489.  IMSUB()                          Not converted
  490.  
  491.  IMSUM()                          Not converted
  492.  
  493.  INDEX()                          INDEX()
  494.  
  495.  INDIRECT()                       Not converted
  496.  
  497.  INFO()                           Not converted
  498.  
  499.  INT()                            INT()
  500.  
  501.  INTERCEPT()                      Not converted
  502.  
  503.  INTRATE()                        Not converted
  504.  
  505.  IPMT()                           Not converted
  506.  
  507.  IRR()                            IRR()
  508.  
  509.  ISBLANK()                        ISNA()
  510.  
  511.  ISERR()                          ISERR()
  512.  
  513.  ISERROR()                        ISERR()
  514.  
  515.  ISEVEN()                         Not converted
  516.  
  517.  ISLOGICAL()                      ISVALUE()
  518.  
  519.  ISNA()                           ISNA()
  520.  
  521.  ISNONTEXT()                      ISTEXT
  522.  
  523.  ISNUMBER()                       ISVALUE()
  524.  
  525.  ISODD()                          Not converted
  526.  
  527.  ISREF()                          Not converted
  528.  
  529.  ISTEXT()                         ISTEXT()
  530.  
  531.  KURT()                           Not converted
  532.  
  533.  LARGE()                          Not converted
  534.  
  535.  LCM()                            Not converted
  536.  
  537.  LEFT()                           LEFT()
  538.  
  539.  LEN()                            LENGTH()
  540.  
  541.  LINEST()                         Not converted
  542.  
  543.  LN()                             LN()
  544.  
  545.  LOG()                            LOG()
  546.  
  547.  LOG10()                          LOG10()
  548.  
  549.  LOGEST()                         Not converted
  550.  
  551.  LOGINV()                         Not converted
  552.  
  553.  LOGNORMDIST()                    Not converted
  554.  
  555.  LOOKUP()                         LOOKUP()
  556.  
  557.  LOWER()                          LOWER()
  558.  
  559.  MATCH()                          MATCH()
  560.  
  561.  MAX()                            MAX()
  562.  
  563.  MDETERM()                        Not converted
  564.  
  565.  MDURATION()                      Not converted
  566.  
  567.  MEDIAN()                         Not converted
  568.  
  569.  MID()                            MID()
  570.  
  571.  MIN()                            MIN()
  572.  
  573.  MINUTE()                         MINUTE()
  574.  
  575.  MINVERSE()                       Not converted
  576.  
  577.  MIRR()                           Not converted
  578.  
  579.  MMULT()                          Not converted
  580.  
  581.  MOD()                            MOD()
  582.  
  583.  MODE()                           Not converted
  584.  
  585.  MONTH()                          MONTH()
  586.  
  587.  MROUND()                         Not converted
  588.  
  589.  MULTINOMIAL()                    Not converted
  590.  
  591.  N()                              Not converted
  592.  
  593.  NA()                             NA()
  594.  
  595.  NEGBINOMDIST()                   Not converted
  596.  
  597.  NETWORKDAYS()                    Not converted
  598.  
  599.  NOMINAL()                        Not converted
  600.  
  601.  NORMDIST()                       Not converted
  602.  
  603.  NORMINV()                        Not converted
  604.  
  605.  NORMSDIST()                      Not converted
  606.  
  607.  NORMSINV()                       Not converted
  608.  
  609.  NOT()                            NOT()
  610.  
  611.  NOW()                            MDY() + HMS()
  612.  
  613.  NPER()                           TERM()
  614.  
  615.  NPV()                            NPV()
  616.  
  617.  OCT2BIN()                        Not converted
  618.  
  619.  OCT2DEC()                        Not converted
  620.  
  621.  OCT2HEX()                        Not converted
  622.  
  623.  ODD()                            Not converted
  624.  
  625.  ODDFPRICE()                      Not converted
  626.  
  627.  ODDFYIELD()                      Not converted
  628.  
  629.  ODDLPRICE()                      Not converted
  630.  
  631.  ODDLYIELD()                      Not converted
  632.  
  633.  OFFSET()                         Not converted
  634.  
  635.  OR()                             OR()
  636.  
  637.  PEARSON()                        Not converted
  638.  
  639.  PERCENTILE()                     Not converted
  640.  
  641.  PERCENTRANK()                    Not converted
  642.  
  643.  PERMUT()                         Not converted
  644.  
  645.  PI()                             PI()
  646.  
  647.  PMT()                            PMT()
  648.  
  649.  POISSON()                        Not converted
  650.  
  651.  PPMT()                           Not converted
  652.  
  653.  PRICE()                          Not converted
  654.  
  655.  PRICEDISC()                      Not converted
  656.  
  657.  PRICEMAT()                       Not converted
  658.  
  659.  PROB()                           Not converted
  660.  
  661.  PRODUCT()                        PRODUCT()
  662.  
  663.  PROPER()                         PROPER()
  664.  
  665.  PV()                             PV()
  666.  
  667.  QUARTILE ()                      Not converted
  668.  
  669.  QUOTIENT()                       Not converted
  670.  
  671.  RAND()                           RANDOM()
  672.  
  673.  RANK()                           Not converted
  674.  
  675.  RATE()                           RATE()
  676.  
  677.  RECEIVED()                       Not converted
  678.  
  679.  REGISTER()                       Not converted
  680.  
  681.  REPLACE()                        Not converted
  682.  
  683.  REPT()                           REPEAT()
  684.  
  685.  RIGHT()                          RIGHT()
  686.  
  687.  ROUND()                          ROUND()
  688.  
  689.  ROW()                            ROW (arguments) is not
  690.                                   supported.
  691.  
  692.  ROWS()                           Not converted
  693.  
  694.  RSQ()                            Not converted
  695.  
  696.  SEARCH()                         Not converted
  697.  
  698.  SECOND()                         SECOND()
  699.  
  700.  SERIESSUM()                      Not converted
  701.  
  702.  SIGN()                           SIGN
  703.  
  704.  SIN()                            SIN()
  705.  
  706.  SINH()                           Not converted
  707.  
  708.  SKEW()                           Not converted
  709.  
  710.  SLN()                            SLN()
  711.  
  712.  SLOPE()                          Not converted
  713.  
  714.  SMALL()                          Not converted
  715.  
  716.  SQRT()                           SQRT()
  717.  
  718.  SQRTPI()                         Not converted
  719.  
  720.  STANDARDIZE()                    Not converted
  721.  
  722.  STDEV()                          STDEV()
  723.  
  724.  STDEVP()                         STDEVP()
  725.  
  726.  STEYX()                          Not converted
  727.  
  728.  SUBSTITUTE()                     Not converted
  729.  
  730.  SUM()                            SUM()
  731.  
  732.  SUMPRODUCT()                     Not converted
  733.  
  734.  SUMSQ()                          SUM()
  735.  
  736.  SUMX2MY2()                       Not converted
  737.  
  738.  SUMX2PY2()                       Not converted
  739.  
  740.  SUMXMY2()                        Not converted
  741.  
  742.  SYD()                            SYD()
  743.  
  744.  T()                              Not converted
  745.  
  746.  TAN()                            TAN()
  747.  
  748.  TANH()                           Not converted
  749.  
  750.  TBILLEQ()                        Not converted
  751.  
  752.  TBILLPRICE()                     Not converted
  753.  
  754.  TBILLYIELD()                     Not converted
  755.  
  756.  TDIST()                          Not converted
  757.  
  758.  TEXT()                           Not converted
  759.  
  760.  TIME()                           TIME()
  761.  
  762.  TIMEVALUE()                      TIMEVALUE()
  763.  
  764.  TINV()                           Not converted
  765.  
  766.  TODAY()                          MDY()
  767.  
  768.  TRANSPOSE()                      Not converted
  769.  
  770.  TREND()                          Not converted
  771.  
  772.  TRIM()                           Not converted
  773.  
  774.  TRIMMEAN()                       Not converted
  775.  
  776.  TRUE()                           TRUE()
  777.  
  778.  TRUNC()                          INT()
  779.  
  780.  TTEST()                          Not converted
  781.  
  782.  TYPE()                           Not converted
  783.  
  784.  UPPER()                          UPPER()
  785.  
  786.  VALUE()                          VALUE()
  787.  
  788.  VAR()                            VAR()
  789.  
  790.  VARP()                           VARP()
  791.  
  792.  VDB()                            Not converted
  793.  
  794.  VLOOKUP()                        LOOKUP()
  795.  
  796.  WEEKDAY()                        ((arg) % 7 + 1) if arg is
  797.                                   cell reference
  798.                                   (Date value (arg) % 7 + 1) if
  799.                                   a string
  800.  
  801.  WEIBULL()                        Not converted
  802.  
  803.  WORKDAY()                        Not converted
  804.  
  805.  XIRR()                           Not converted
  806.  
  807.  XNPV()                           Not converted
  808.  
  809.  YEAR()                           YEAR()
  810.  
  811.  YEARFRAC()                       Not converted
  812.  
  813.  YIELD()                          Not converted
  814.  
  815.  YIELDDISC()                      Not converted
  816.  
  817.  YIELDMAT()                       Not converted
  818.  
  819.  ZTEST()                          Not converted