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 >
Wrap
Text File
|
1994-02-14
|
21KB
|
819 lines
================================================================
EXCEL.DOC
================================================================
This document deals with conversion of features from Excel 2.1,
3.0, and 4.0 to WordPerfect 6.0. Currently, converting tables
from WordPerfect 6.0 to Excel is not supported.
================================================================
Section 1 - Excel 2.1, 3.0 and 4.0 to WordPerfect 6.0
================================================================
The following table shows how codes are converted from Excel
format to WordPerfect 6.0.
EXCEL 2.1, 3.0 and 4.0 WORDPERFECT 6.0
====================== ===========
Alignment
Center Center
Enter/Tab Not Applicable
Fill Left Align, repeat characters
until cell full
General Right align if number, all
else Left
Justify Left and Right
Left Left
Right Right
Wrap text Cells won't combine for long
text
Charts Charts not supported
File
Page Set-up
Footer Footer - except if imported
into an existing WordPerfect
6.0 document
Header Header - except if imported
into an existing WordPerfect
6.0 document
Margins-Bottom Bottom Margin
Margins-Top Top Margin
Margins-Left Left Margin
Margins-Right Right Margin
Orientation-Landscape Landscape
Orientation-Portrait Portrait
Paper Size Paper Size
Format
Auto Format Not Applicable
Border Not Converted
Cell Protection
Hidden Hidden (except blank cells)
Locked Locked (except blank cells)
Center across section Center
Column Width
Best fit Maintains column width
Hide Hidden
UnHide Show all Hidden Text
Width Column: Width #8
Font
Color Color
Effect Underline Underline
Effect Strikeout Strikeout
Name Converts as close as possible
Size Size
Style Bold Italic Bold Italic
Style Bold Bold
Style Italic Italic
Style Regular Normal
Justify Left and Right Align
Number
All/General General
Currency Currency
Date Date Type Formats
Fraction General, rounds to whole
number
Number Fixed
Percent Percent
Scientific Scientific
Time Date/Time Formats
Patterns
Background 10% Shade Fill
Cell Shading 10% Shade Fill
Foreground 10% Shade Fill
Row Height
Hide Hidden
Non Standard Row Height
Standard Row Height
UnHide Show all Hidden Text
Style Not Applicable
Text orientation Horizontal only is converted
Vertical Center Not Converted
Vertical Bottom Not Converted
Vertical Top Not Converted
Functions Please see list of supported
functions in Section 2
Macros Not Converted
Options
Calculation Not Converted
Protect Document Cannot convert if password is
set
Set Page Break Horizontal Page Breaks
Importing spreadsheets up to 64 columns is supported. If you try
to import a spreadsheet with more than 64 columns, all columns
after the 64th column are truncated.
Importing a spreadsheet into a WordPerfect 6.0 document changes
the Table Line defaults for all following tables to "None."
Tables following the imported spreadsheet will need to be edited
and changed to restore the table lines and borders.
Range names longer than 25 characters are not converted.
Hidden cells convert unhidden.
Vertically aligned text will convert as horizontal.
Border line draw will convert to default table lines.
Hidden columns will convert to a column width of .001. Changing
the column width in WordPerfect 6.0 will expand hidden columns.
================================================================
Section 2 - Excel Function Codes
================================================================
The following table shows Excel Functions and how they convert to
WordPerfect 6.0.
EXCEL FUNCTIONS WordPerfect 6.0
=============== ===============
ABS() ABS()
ACCRINT() Not converted
ACCRINTM() Not converted
ACOS() ACOS()
ACOSH() Not converted
ADDRESS() Not converted
AND() AND()
AREAS() Not converted
ASIN() ASIN()
ASINH() Not converted
ATAN() ATAN()
ATAN2() ATAN2()
ATANH() Not converted
AVERAGE() AVE()
BASE() Not converted
BESSELI() Not converted
BESSELJ() Not converted
BESSELK() Not converted
BESSELY() Not converted
BETADIST() Not converted
BETAINV() Not converted
BIN2DEC() Not converted
BIN2HEX() Not converted
BIN2OCT() Not converted
BINOMDIST() Not converted
CALL() Not converted
CEILING() Not converted
CELL() Not converted
CHAR() CHAR()
CHIDIST() Not converted
CHIINV() Not converted
CHITEST() Not converted
CHOOSE() CHOOSE()
CLEAN() Not converted
CODE() Not converted
COLUMN() Column (arguments) is not
supported
COLUMNS() Not converted
COMBIN() Not converted
COMPLEX() Not converted
CONFIDENCE() Not converted
CONVERT() Not converted
CORREL() Not converted
COS() COS()
COSH() Not converted
COUNT() COUNT()
COUNTA() COUNT()
COUPDAYBS() Not converted
COUPDAYS() Not converted
COUPDAYSNC() Not converted
COUPNCD() Not converted
COUPNUM() Not converted
COUPPCD() Not converted
COVAR() Not converted
CRITBINOM() Not converted
CROSSTAB() Not converted
CUMIPMT() Not converted
CUMPRINC() Not converted
DATE() DATE()
DATEVALUE() DATEVALUE()
DAVERAGE() Not converted
DAY() DAY()
DAYS360() Not converted
DB() Not converted
DCOUNT() Not converted
DCOUNTA() Not converted
DDB() DDB()
DEC2BIN() Not converted
DEC2HEX() Not converted
DEC2OCT() Not converted
DELTA() Not converted
DEVSQ() Not converted
DGET() Not converted
DISC() Not converted
DMAX() Not converted
DMIN() Not converted
DOLLAR() CURRENCY()
DOLLARDE() Not converted
DOLLARFR() Not converted
DPRODUCT() Not converted
DSTDEV() Not converted
DSTDEVP() Not converted
DSUM() Not converted
DURATION() Not converted
DVAR() Not converted
DVARP() Not converted
EDATE() Not converted
EFFECT() Not converted
EOMONTH() Not converted
ERF() Not converted
ERFC() Not converted
ERROR.TYPE() Not converted
EVEN() Not converted
EXACT() Not converted
EXP() EXP()
EXPONDIST() Not converted
FACT() FACT()
FACTDOUBLE() Not converted
FALSE() FALSE()
FDIST() Not converted
FIND() FIND()
FINV() Not converted
FISHER() Not converted
FISHERINV() Not converted
FIXED() TEXT()
FLOOR() Not converted
FORECAST() Not converted
FREQUENCY() Not converted
FTEST() Not converted
FV() FV()
FVSCHEDULE() Not converted
GAMMADIST() Not converted
GAMMAINV() Not converted
GAMMALN() Not converted
GCD() Not converted
GEOMEAN() Not converted
GESTEP() Not converted
GROWTH() Not converted
HARMEAN() Not converted
HEX2BIN() Not converted
HEX2DEC() Not converted
HEX2OCT() Not converted
HLOOKUP() LOOKUP()
HOUR() HOUR()
HYPGEOMDIST() Not converted
IF() IF()
IMABS() Not converted
IMAGINARY() Not converted
IMARGUMENT() Not converted
IMCONJUGATE() Not converted
IMCOS() Not converted
IMDIV() Not converted
IMEXP() Not converted
IMLN() Not converted
IMLOG10() Not converted
IMLOG2() Not converted
IMPOWER() Not converted
IMPRODUCT() Not converted
IMREAL() Not converted
IMSIN() Not converted
IMSQRT() Not converted
IMSUB() Not converted
IMSUM() Not converted
INDEX() INDEX()
INDIRECT() Not converted
INFO() Not converted
INT() INT()
INTERCEPT() Not converted
INTRATE() Not converted
IPMT() Not converted
IRR() IRR()
ISBLANK() ISNA()
ISERR() ISERR()
ISERROR() ISERR()
ISEVEN() Not converted
ISLOGICAL() ISVALUE()
ISNA() ISNA()
ISNONTEXT() ISTEXT
ISNUMBER() ISVALUE()
ISODD() Not converted
ISREF() Not converted
ISTEXT() ISTEXT()
KURT() Not converted
LARGE() Not converted
LCM() Not converted
LEFT() LEFT()
LEN() LENGTH()
LINEST() Not converted
LN() LN()
LOG() LOG()
LOG10() LOG10()
LOGEST() Not converted
LOGINV() Not converted
LOGNORMDIST() Not converted
LOOKUP() LOOKUP()
LOWER() LOWER()
MATCH() MATCH()
MAX() MAX()
MDETERM() Not converted
MDURATION() Not converted
MEDIAN() Not converted
MID() MID()
MIN() MIN()
MINUTE() MINUTE()
MINVERSE() Not converted
MIRR() Not converted
MMULT() Not converted
MOD() MOD()
MODE() Not converted
MONTH() MONTH()
MROUND() Not converted
MULTINOMIAL() Not converted
N() Not converted
NA() NA()
NEGBINOMDIST() Not converted
NETWORKDAYS() Not converted
NOMINAL() Not converted
NORMDIST() Not converted
NORMINV() Not converted
NORMSDIST() Not converted
NORMSINV() Not converted
NOT() NOT()
NOW() MDY() + HMS()
NPER() TERM()
NPV() NPV()
OCT2BIN() Not converted
OCT2DEC() Not converted
OCT2HEX() Not converted
ODD() Not converted
ODDFPRICE() Not converted
ODDFYIELD() Not converted
ODDLPRICE() Not converted
ODDLYIELD() Not converted
OFFSET() Not converted
OR() OR()
PEARSON() Not converted
PERCENTILE() Not converted
PERCENTRANK() Not converted
PERMUT() Not converted
PI() PI()
PMT() PMT()
POISSON() Not converted
PPMT() Not converted
PRICE() Not converted
PRICEDISC() Not converted
PRICEMAT() Not converted
PROB() Not converted
PRODUCT() PRODUCT()
PROPER() PROPER()
PV() PV()
QUARTILE () Not converted
QUOTIENT() Not converted
RAND() RANDOM()
RANK() Not converted
RATE() RATE()
RECEIVED() Not converted
REGISTER() Not converted
REPLACE() Not converted
REPT() REPEAT()
RIGHT() RIGHT()
ROUND() ROUND()
ROW() ROW (arguments) is not
supported.
ROWS() Not converted
RSQ() Not converted
SEARCH() Not converted
SECOND() SECOND()
SERIESSUM() Not converted
SIGN() SIGN
SIN() SIN()
SINH() Not converted
SKEW() Not converted
SLN() SLN()
SLOPE() Not converted
SMALL() Not converted
SQRT() SQRT()
SQRTPI() Not converted
STANDARDIZE() Not converted
STDEV() STDEV()
STDEVP() STDEVP()
STEYX() Not converted
SUBSTITUTE() Not converted
SUM() SUM()
SUMPRODUCT() Not converted
SUMSQ() SUM()
SUMX2MY2() Not converted
SUMX2PY2() Not converted
SUMXMY2() Not converted
SYD() SYD()
T() Not converted
TAN() TAN()
TANH() Not converted
TBILLEQ() Not converted
TBILLPRICE() Not converted
TBILLYIELD() Not converted
TDIST() Not converted
TEXT() Not converted
TIME() TIME()
TIMEVALUE() TIMEVALUE()
TINV() Not converted
TODAY() MDY()
TRANSPOSE() Not converted
TREND() Not converted
TRIM() Not converted
TRIMMEAN() Not converted
TRUE() TRUE()
TRUNC() INT()
TTEST() Not converted
TYPE() Not converted
UPPER() UPPER()
VALUE() VALUE()
VAR() VAR()
VARP() VARP()
VDB() Not converted
VLOOKUP() LOOKUP()
WEEKDAY() ((arg) % 7 + 1) if arg is
cell reference
(Date value (arg) % 7 + 1) if
a string
WEIBULL() Not converted
WORKDAY() Not converted
XIRR() Not converted
XNPV() Not converted
YEAR() YEAR()
YEARFRAC() Not converted
YIELD() Not converted
YIELDDISC() Not converted
YIELDMAT() Not converted
ZTEST() Not converted