![]() |
Tables Compared To Spreadsheets (Questions An |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: How do tables work with spreadsheets? How are they the same/different? Solutions: The Table feature is in some ways like, and in other ways unlike, a spreadsheet. Similarities: 1. A Table is divided into "cells" and the status line will display what cell you are currently in. 2. Tables use simple math and can have cell formulas. 3. You can copy cell formulas from one cell to another. 4. Cell formulas appear in the lower left of the screen. 5. You can link between WP 5.1 and any Lotus compatible spreadsheet, including PlanPerfect. You can do this by pressing Ctrl-F5, 5 for Spreadsheet, 2 for Create Link. You can also designate the specific range to link from the spreadsheet. Differences: 1. Tables do not have a command language. 2. You can join or split cells in tables. Question: What type of conversion is needed for a Lotus or PlanPerfect document? Answer: None, just retrieve it either by List Files or by Shift-F10. Question: What versions of Lotus are supported? Answer: All versions except 3.0. Question: Can I output to PlanPerfect or Lotus? Answer: No. Question: Is there a way to split an extra large spreadsheet into two different tables? Answer: Yes, block the information (while in the Table Edit screen) you would like to move to a different table and choose the move key and press move. Exit out of the table. Create a new table, position the cursor in cell A1 and retrieve the portion of table the was blocked. Question: When retrieving the large spreadsheet and the Warning tells you that the table exceeds right margins, how will it print if the margins are not altered? Answer: In WP 5.1 you have the ability to retrieve a Lotus or PlanPerfect spreadsheet without any conversion necessary. It will be placed in a table. If the retrieved spreadsheet is wider than the page allows, the message WARNING: TABLE EXTENDS BEYOND RIGHT MARGIN will appear telling the user to change the paper size, margins, base font, column widths, or eliminate unnecessary columns to accommodate the spreadsheet. If the user does not, when the table is printed, the last columns will overprint. Question: Is it possible to have a row and column border like in a spreadsheet? Answer: No, the status line is the indicator. Question: What will happen to the macros (cell macros from a spreadsheet program) imported into a table? Answer: They are treated as text if they were visible in the spreadsheet. Question: Will it do formulas with "if" statements or other Lotus/PlanPerfect like formulas? Answer: No, Tables Math is very simple, straight forward math and does not have a complex command language. Question: How complicated can the formulas be? Answer: Basic math steps, multiply, divide, add, and subtract. You are limited by the number of characters that fit on a line in the table math formula screen (79 characters or so). Question: Is recalculation necessary or will WP do it automatically? Answer: WP does not possess the ability to do it automatically, except when creating a formula it will calculate automatically. Question: Does copying a Math formula automatically increment the formula? Answer: Yes. Question: In Math can imputing a formula be done by pointing to a cell and pressing Enter? Answer: No. Question: How do you delete a formula? Answer: To delete the formula, be in the cell and press Backspace. This will not change the numbers already existing even if you recalculate, but it will delete the formula. To remove the numbers that may have been previously calculated, go back to a normal editing screen and delete the unwanted numbers. Question: Can you make formulas absolute so the cell references do not change when copying? Answer: No. |
Answer:
Details:
Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER. |