home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
wp
/
adconv60.zip
/
QPRO.DOC
< prev
next >
Wrap
Text File
|
1993-06-01
|
11KB
|
462 lines
This document deals with conversion of features from Quattro Pro 3.0
and 4.0 to WordPerfect 6.0. Currently, converting tables from
WordPerfect 6.0 to Quattro Pro is not supported.
QUATTRO PRO 3.0 and 4.0 WORDPERFECT 6.0
======================= ===============
STYLE MENU
Alignment
Center Cell Format: Alignment: Center
General Text Left/Numbers Right
Left Cell Format: Alignment: Left
Right Cell Format: Alignment: Right
Date
1-(DD-MMM-YY) Date Type Format: #4
2-(DD-MMM) Date Type Format: B
3-(MMM-YY) Date Type Format: #4
(Long Intl.) Date Type Format: #2
(Short Intl.) Date Type Format: A
, (comma) Number Type Format: Comma
+/- Number Type Format: General
Column Width Column Width #8
Currency Number Type Format: Currency
Expose Column Mark: Hidden Text: Show all Hidden Text
Fixed Number Type Format: Fixed
Font
Type faces Typeface
Point sizes Point Size
Color gallery Not Converted
Bold Bold added to font name
Italic Italic added to font name
Underlined Not Converted
Reset Default Font
General Number Type Format: General
Height Not Converted
Hidden Mark: Hidden Text: Hidden
Hide Column Mark: Hidden Text: Hidden
Insert Break Not Converted
Line Draw
All Lines: All
Bottom Lines: Bottom
Horizontal Lines: Horizontal
Inside Lines: Inside
Left Lines: Left
Outside Lines: Outside
Right Lines: Right
Top Lines: Top
Types
None Single
Single Single
Double Double
Thick Thick
Vertical Lines: Vertical
Percent Number Type Format: Percent
Protection
Protect Cell: Lock
Unprotect Cell: Lock (Toggle)
Reset Mark: Hidden Text: Show Hidden Text
Reset Width Not Converted
Scientific Number Type Format: Scientific
Shading
Black 100% Shaded Fill
Grey 10 % Shaded Fill
None None, Shading Off
Style Not Converted
Text Number Type Format: Text
Time
1-(HH:MM:SS Date/Time Type Format: #6
AM/PM)
2-(HH:MM AM/PM) Date/Time Type Format: #6
3-(Long Intl.) Date/Time Type Format: C
4-(Short Intl.) Date/Time Type Format: C
PRINT MENU
Heading
Left Not Converted
Top Titles - if 0 row based
Layout
Break Pages Hard Row - Hard Page
Dimensions Not Converted
Footer Footer - except when imported into an
existing WordPerfect 6.0 document
Header Header - except when imported into an
existing WordPerfect 6.0 document
Margins
Bottom Bottom Margin
Left Left Margin
Page Length Not Converted
Right Right Margin
Top Top Margin
Orientation
Banner Not Converted
Landscape Page Size [Standard Landscape]
Portrait Page Size [Standard Portrait]
Protection
Disable Unlocked Cells
Enable Locked Cells
Formulas, Unlocked Cells
Unprotect
Formulas, Locked Cells
Protect
GRAPH MENU
Graphs Not Converted
Database Function Value is converted, function is dropped
Date & Time Function
DATE() DATE()
DATEVALUE() DATEVALUE()
DAY() DAY()
HOUR() HOUR()
MINUTE() MINUTE()
MONTH() MONTH()
NOW() MDY()+HMS()
SECOND() SECOND()
TIME() TIME()
TIMEVALUE() Value is converted, function is dropped
TODAY() MDY()
YEAR() YEAR()
Financial Function
CTERM() TERM()
DDB() DDB()
FV() FV()
FVAL() Value is converted, function is dropped
IPAYMT() Value is converted, function is dropped
IRATE() Value is converted, function is dropped
IRR() IRR()
NPER() Value is converted, function is dropped
NPV() NPV()
PAYMT() Value is converted, function is dropped
PMT() PMT()
PPAYMT() Value is converted, function is dropped
PV() PV()
PVAL() Value is converted, function is dropped
RATE() RATE()
SLN() SLN()
SYD() SYD()
TERM() TERM()
Logical Function
FALSE() FALSE()
FILEEXISTS() Not Converted
IF() IF()
ISAAF() Not Converted
ISAPP() Not Converted
ISERR() ISERR()
ISNA() ISNA()
ISNUMBER() ISVALUE()
ISSTRING() TEXT()
TRUE() TRUE()
Mathematical Function
ABS() ABS()
ACOS() ACOS()
ASIN() ASIN()
ATAN() ATAN()
ATAN() ATAN()
ATAN2() ATAN2()
COS() COS()
DEGREES() DEGREES()
EXP() EXP()
INT() INT()
LN() LN()
LOG() LOG()
MOD() MOD()
PI() PI()
RADIANS() RADIANS()
RAND() RANDOM()
ROUND() ROUND()
SIN() SIN()
SQRT() SQRT()
Miscellaneous Function
@@CELL() Not Converted
CELL() Value is converted, function is dropped
CELLINDEX() Not Converted
CELLPOINTER() Not Converted
CHOOSE() CHOOSE()
COLS() Not Converted
CURVALUE() Not Converted
ERR() Not Converted
HLOOKUP() LOOKUP()
INDEX() INDEX()
MEMAVAIL() Not Converted
MEMEMSAVAIL() Not Converted
NA() NA()
ROWS() Not Converted
VERSION() Not Converted
VLOOKUP() LOOKUP()
Statistical Function
AVG() AVG()
COUNT() COUNT()
MAX() MAX()
MIN() MIN()
STD() STD()
STDS() STDEV()
SUM() SUM()
SUMPRODUCT() Value is converted, function is dropped
VAR() VAR()
VARS() VAR()
String Function
CHAR() CHAR()
CLEAN() Value is converted, function is dropped
CODE() Not Converted
EXACT() Not Converted
FIND() Not Converted
HEXTONIUM() Value is converted, function is dropped
LEFT() LEFT()
LENGTH() LENGTH()
LOWER() LOWER()
MID() MID()
N() Value is converted, function is dropped
NUMTOHEX() Value is converted, function is dropped
PROPER() PROPER()
REPEAT() REPEAT()
REPLACE() Not Converted
RIGHT() RIGHT()
S() Value is converted, function is dropped
STRING() TEXT()
TRIM() Not Converted
UPPER() UPPER()
VALUE() VALUE()
Cells which contain text such as a phone number or a social security
number will be interpreted as a formula unless they have been inserted
using the instructions Quattro Pro provides for text in cells.
Quattro Pro files that have a line draw line on the right side of the
spreadsheet will have an extra column inserted in the WordPerfect 6.0
table when converted. A line draw line at the bottom of the
spreadsheet will insert an extra row at the bottom of the WordPerfect
6.0 table when converted.
Basic formulas need to be recalculated in the WordPerfect 6.0 table
after conversion.
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.
Parentheses for negative numbers will convert for values that have
been formatted for currency and financial.
Hidden columns will convert to a column width of .001. Changing the
column width in WordPerfect 6.0 will expand hidden columns and turning
on the 'Show All Hidden Text' option will allow the data in each table
cell to be viewed.
Functions not supported in WordPerfect 6.0 tables will convert as the
calculated value of that function.