home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
wp
/
adconv60.zip
/
PLAN.DOC
< prev
next >
Wrap
Text File
|
1993-06-01
|
17KB
|
591 lines
This document deals with conversion of features from PlanPerfect 3.0
and 5.x to WordPerfect 6.0. Currently, converting tables from
WordPerfect 6.0 to PlanPerfect is not supported.
PLANPERFECT 3.0 and 5.x WORDPERFECT 6.0
======================= ===============
Calculations
Iteration Not converted
Iteration Formula Not converted
Mode (Automatic, Manual) Not converted
Order Not converted
Round Value Not converted
Compose Characters All extended characters are
converted
Edit Window (Text) Converted to individual cells,
with each line of text in a
separate cell
Font
Select for Cell or Block Converted to font/size codes
within the table cell
Select for Column Converted to font/size codes
within table column
Select for Worksheet Converted to a font/size code at
the beginning of the table
Format
Alignment
Cell
Center, Numbers Converted to Center
or Text Justification assigned to table
cell
Left, Numbers or Converted to Left Justification
Text assigned to table cell
Right, Numbers or Converted to Right Justification
Text assigned to table cell
Column
Center, Numbers Converted to Center
or Text Justification assigned to table
column
Left, Numbers or Converted to Left Justification
Text assigned to table column
Right, Numbers or Converted to Right Justification
Text assigned to table column
Worksheet
Center, Numbers Converted to Center
or Text Justification assigned to entire
table
Left, Numbers or Converted to Left Justification
Text assigned to entire table
Right, Numbers or Converted to Right Justification
Text assigned to entire table
Attributes
Alternate Font, Select Converted to Italics attribute
(PlanPerfect 3.0 files only)
Bold Converted to Bold attribute
Cell or Block Converted to attribute(s)
assigned to the current table
cell or block
Column Converted to attribute(s)
assigned to the current table
column
Double-Underline Converted to Double-Underline
attribute
Font Converted to font/size codes
within table cell
Hide Converted to hidden text
Italics Converted to Italics attribute
Underline Converted to Underline attribute
Worksheet Converted to attributes assigned
to the entire table
Zero Suppress (Hide If If a cell value is zero, it is
Zero) converted to hidden text.
Otherwise, no change.
Column
Column Width Converted to approximate inch
equivalent
Suppress Not converted
Edit
Appearance Converted to equivalent
appearance attribute
Size Converted to equivalent size
attribute
Format Page
Headers/Footers
Text Converted to header/footer text,
except if imported into existing
WordPerfect 6.0 document.
Alignment (|) Use of | character to create
alignment is converted to
appropriate alignment codes
within header or footer.
Cell Reference Not converted
^B (Pg. Number) Converted to Page Numbering code
within header or footer
^D (Date) Converted to Date code within
header or footer
Line Height Converted to line height code
Margins
Bottom Converted to Bottom Margin Code
Left Converted to Left Margin code
Right Converted to Right Margin code
Top Converted to Top Margin code
Number Pages Converted to Page Numbering code
Page Number Position Converted to Page Numbering code
Paper/Size Type Converted to Paper Size/Type
code
Print
Borders Y/N Not converted
Print Titles Y/N Not converted
Printer Functions
Kerning Kerning
Type
Accounting Converted to Accounting number
type format
Comma Converted to Comma number type
format
Currency Converted to Currency number
type format
Date Converted to Date number type
format
Decimal Aligned Converted to the General number
Numbers type format, Left justification,
and Decimal Alignment position
at n digits.
Fixed Converted to the Fixed number
type format
General Converted to the General number
type format
Integer Converted to the Integer number
type format
Other
Commas Not converted
Decimal Precision Not converted
Gutter Space Not converted
Negative Number Not converted
options
Parentheses Not converted
Round for Calc. Not converted
Spec. Characters Not converted
Percent Converted to the Percent number
type format
Scientific Converted to the Scientific
number type format
Text Format Converted to the Text type
format
Date/Time Format Converted to the Date/Time type
format
Worksheet
Borders, Display Not converted
Display
Formulas Not converted
Spec. Char Not converted
Argument
Separator
Spec. Char. Converted to one of the currency
Currency formats listed in the .LRS file
Symbol(S)
Spec. Char. Converted to Decimal Align
Decimal Align Character code
Spec. Char. Converted to Thousands Separator
Thousands code
Separator
Sort Language Converted to Language code
Summary Converted to Document Summary
Width Converted to table Column Width
setting
Formula
Absolute Converted to absolute cell
reference (entire cell reference
enclosed in square brackets)
Logical Operators >, <, =, Converted to equivalent logical
<>, >=, <= operators
Mixed Converted to mixed cell
reference (square brackets may
surround either column reference
letter or row reference number)
Operators +, -, /, *, ^, % Converted to equivalent
arithmetic operators
Relative Converted to cell reference
Functions
Arithmetic Functions
ABS() ABS()
ACOS() ACOS()
ASIN() ASIN()
ATAN() ATAN()
ATAN2() ATAN2()
AVE() AVE()
COS() COS()
DEGREES() DEGREES()
EXP() EXP()
FACT() FACT()
INT() INT()
LN() LN()
LOG() LOG()
MAX() MAX()
MIN() MIN()
MINUS() MINUS()
MOD() MOD()
PI() PI()
POWER() POWER()
PRODUCT() PRODUCT()
QUOTIENT() QUOTIENT()
RADIANS() RADIANS()
RANDOM() RANDOM()
ROUND() ROUND()
SIN() SIN()
SQRT() SQRT()
STDEV() STDEV()
STDEVP() STDEVP()
SUBTRACT() SUBTRACT()
SUM() SUM()
TAN() TAN()
VAR() VAR()
VARP() VARP()
Date & Time Functions
DATE() DATE()
DATETEXT() DATETEXT()
DATEVALUE() DATEVALUE()
DAY() DAY()
HMS() HMS()
HOUR() HOUR()
MDY() MDY()
MINUTE() MINUTE()
MONTH() MONTH()
SECOND() SECOND()
TIME() TIME()
TIMETEXT() TIMETEXT()
TIMEVALUE() TIMEVALUE()
YEAR() YEAR()
Financial Functions
DDB() DDB()
FV() FV()
IRR() IRR()
NPV() NPV()
PMT() PMT()
PV() PV()
RATE() RATE()
SLN() SLN()
SYD() SYD()
TERM() TERM()
Logical Functions
AND() AND()
FALSE() FALSE()
FOREACH() Not converted
IF() IF()
ISERR() ISERR()
ISERR2() ISERR2()
ISNA() ISNA()
ISTEXT() ISTEXT()
ISVALUE() ISVALUE()
NA() NA()
NOT() NOT()
OR() OR()
SIGN() SIGN()
TRUE() TRUE()
Special Functions
BLOCK() BLOCK()
CELL() CELL()
CHOOSE() CHOOSE()
COL() COL()
COUNT() COUNT()
CURSOR() Not converted
INDEX() INDEX()
ITERATION() Not converted
LOOKUP() LOOKUP()
LOOKUP2() LOOKUP2()
MATCH() MATCH()
MATCH2() MATCH2()
ROW() ROW()
STATUS() Not converted
Text Functions
CHAR() CHAR()
CODE() CODE()
CONCAT() CONCAT()
CURRENCY() CURRENCY()
FIND() FIND()
LEFT() LEFT()
LENGTH() LENGTH()
LOWER() LOWER()
MID() MID()
PROPER() PROPER()
REPEAT() REPEAT()
REPLACE() REPLACE()
RIGHT() RIGHT()
TEXT() TEXT()
TRIM() TRIM()
UPPER() UPPER()
VALUE() VALUE()
Graph Graphs are not supported in
WordPerfect 6.0
Help, Cell Message Not converted
Insert
Printer Command Not converted
Lock/Unlock
Cell Converted to locked cell
Column Converted to locked column
Worksheet Converted to locked except blank
cells, which are converted to
Unlocked cells
Macro
Cell Macro Cell macros are not supported in
WordPerfect 6.0
Model Mode On/Off Spreadsheet Model Mode is not
supported in WordPerfect 6.0
Named
Blocks Converted to named table block
Cell Converted to named table cell(s)
Columns Converted to named table
column(s)
Rows Converted to named table
column(s)
Page Break (\\Page) Converted to a soft page break
within the table
Password Add/Delete Converted to document password
Screen
Titles
Across Converted to a Header Row
Lock Y/N Converted to Unlock
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.
A period (.) in a table name is converted to an underscore (_).
Reference in a Header or Footer to a cell such as <A8> converts to the
actual text <A8> instead of the contents of cell A8.
Functions not supported in WordPerfect 6.0 tables will convert as the
calculated value of that function.
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.
Blank cells in a spreadsheet with global protection on will convert
unlocked.