home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR8
/
ADCONV60.ZIP
/
QPROWIN.DOC
< prev
next >
Wrap
Text File
|
1993-06-01
|
14KB
|
510 lines
This document deals with conversion of features from Quattro Pro 1.0
for Windows to WordPerfect 6.0. Currently, converting tables from
WordPerfect 6.0 to Quattro Pro for Windows is not supported.
QUATTRO PRO 1.0 for WINDOWS WORDPERFECT 6.0
=========================== ===============
[Block]
Cell Alignment
Center Cell Format:Alignment
Justification: Center
General Text Left/Numeric Right
Left Cell Format:Alignment
Justification: Left
Right Cell Format:Alignment
Justification: Right
Cell Protection
Protect Cell: Lock
Unprotect Cell: Lock(Toggle)
Column Width
Auto Width Not converted
Reset Width Not converted
Set Width Column: Width #8
Data Entry Input
Dates Only Maintained
General Maintained
Labels Only Maintained
Font
Bold Bold
Italic Italic
Point sizes Point Sizes
Strikeout Not converted
Type faces Maintained
Underlined Not converted
Line Drawing
Line Segments
All Lines: All
Inside Lines: Inside
Outline Lines: Outline
Line Types
Double Lines: Thick
No change Not converted
No line Lines: Single
Single Lines: Single
Thick Lines: Thick
Numeric Format
, (comma) Number Type Format: Comma
+/- Number Type Format: General
Currency Number Type Format: Currency
Date
1-(DD-MMM-YY) Date Type Format: #4
2-(DD-MMM) Date Type Format: B
1-(MMM-YY) Date Type Format: #4
(Long Intl.) Date Type Format: #2
(Short Intl.) Date Type Format: A
Fixed Number Type Format: Fixed
General Number Type Format: General
Hidden Mark Hidden Text: Hidden
Percent Number Type Format: Percent
Scientific Number Type Format: Scientific
Text Number Type Format: Text
Time
1-(HH:MM:SS AM/PM) Date Type Format: #6
2-(HH:MM AM/PM) Date Type Format: #6
3-(Long Intl.) Date Type Format: C
4-(Short Intl.) Date Type Format: C
User Defined Not converted
Reveal/Hide
Hide Column Mark: Hidden Text: Hidden
Hide Row Not converted
Reveal Column Mark: Hidden Text: Show All
Hidden Text
Reveal Row Not converted
Row Height Not converted
Shading
Color blend 1-7 10% Shaded Fill
Color, 1,2 - Blend 10% Shaded Fill
None No Shading
Text color Not converted
[Page]
Borders Not converted
Conditional color Not converted
Default Width Maintained
Unit: Char, In., Not converted
Centim.
Width Maintained
Display Zeros Not converted
Line color Color Palette Not converted
options
Label Alignment
Center Cell Format: Center Aligned
Left Cell Format: Left Aligned
Right Cell Format: Right Aligned
Grid Lines Not converted
Name Not converted
FILE
Page Setup
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: Footer Not converted
Margins: Right Margin [Right]
Margins: Bottom Not converted
Margins: Header Margin [Bottom]
Margins: Left Margin [Left]
Margins: Top Margin [Top]
Orientation: Landscape Page Size [Standard Landscape]
Orientation: Portrait Page Size [Standard Portrait]
Paper Type: Legal Page Size [Legal]
Paper Type: Letter size Page Size [Standard]
Scaling: Percent Not converted
GRAPH
2D Not converted
3D Not converted
Combo Not converted
Series Not converted
Slide Show Not converted
Text Not converted
Titles 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()
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()
ISERR() ISERR()
ISNA() ISNA()
ISNUMBER() ISVALUE()
ISSTRING() ISTEXT()
TRUE() TRUE()
Mathematical Function
ABS() ABS()
ACOS() ACOS()
ASIN() ASIN()
ATAN() AATAN()
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)
CELL() Not converted
CELLINDEX() Not converted
CELLPOINTER() Not converted
CHOOSE() CHOOSE()
COLS() Not converted
COMMAND() Not converted
CURVALUE() Not converted
DDELINK() Not converted
ERR() Not converted
HLOOKUP() LOOKUP()
INDEX() INDEX()
MEMAVAIL() Not converted
MEMEMSAVAIL() Not converted
NA() NA()
PROPERTY() Not converted
ROWS() Not converted
SHEETS() Not converted
VERSION() Not converted
VLOOKUP() LOOKUP()
Statistical Function
AVG() AVE()
COUNT() COUNT()
MAX() MAX()
MIN() MIN()
STD() STDEV()
STDS() STDEV()
SUM() SUM()
SUMPRODUCT() Value is converted, function is
dropped
VAR() VAR()
VARS() VAR()
String Function
CHAR() CHAR()
CLEAN() Not converted
CODE() Not converted
EXACT() Not converted
FIND() Not converted
HEXTONUM() Not converted
LEFT() LEFT()
LENGTH() LENGTH()
LOWER() LOWER()
MID() MID()
N() Not converted
NUMTOHEX() Not converted
PROPER() PROPER()
REPEAT() REPEAT()
REPLACE() Not converted
RIGHT() RIGHT()
S() Not converted
STRING() TEXT()
TRIM() Not converted
UPPER() UPPER()
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.
Converted tables must be recalculated after conversion for values to
print and display properly.
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 a 0
and must be recalculated after conversion for the values to print and
display properly. Database functions not supported in WordPerfect 6.0
tables will convert as a 0.
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.