                               WordPerfect 5.1

                               Printing Tables

Q:   How do tables use "lines" and what hardware supports them?
A:   All printed lines are graphic lines so any printer which supports
     graphics will print tables with the lines.  You may still use tables if
     you have a non graphic printers but the lines will not print out.  On the
     actual text screen, line draw characters are used so that any screen will
     show the table.  Tables take up less bytes but take more time to print
     than line draw.

Q:   If a table is printed on a daisy wheel printer what will happen?
A:   Graphic lines won't print.  The columns would still line up but without
     the graphic lines.

Q:   Can I print tables with line draw characters rather than graphic lines?
A:   No. If you really want line draw characters then set a "table" up with
     line draw.

Q:   Is there a way to change the default to show and print no lines in
     tables?
A:   No

Q:   If I don't want the lines to print, how can I shut them off?
A:   When printing set Graphic quality to none.  You may also remove all table
     lines by entering into the Table edit screen, blocking, and turning all
     lines to none.

Q:   When retrieving a large spreadsheet and the warning tells me that the
     table exceeds right margins, how will it print if the margins are not
     altered?
A:   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
     you to change your paper size, margins, base font, column widths, or
     eliminate unnecessary columns to accommodate the spreadsheet.  If you do
     not, when the table is printed, the last columns will overprint.

Q:   Can I print the math formulas?
A:   No
 
                         Using Attributes In Tables
 
Q:   How do I change an attribute?
A:   You can change attributes in a column, row, or block.  If you change
     these attributes through the table edit screen, the codes will not appear
     in reveal codes.  You can also change attributes the regular way on the
     5.1 edit screen and these will show in reveal codes.
     Codes placed in the cell from normal edit screen should override any
     conflicting formatting that may have been placed in the table edit
     screen.  

Q:   After setting a table column/cell attribute (ie bold) how do I shut it
     off if I change your mind?
A:   If the code was placed in the table edit menu then it must be changed in
     the table edit menu and toggled off.  If the code was placed in the
     normal edit screen then the code will be seen in Reveal Codes and may be
     deleted.

Q:   Can I change to a specific font within a table?  How?
A:   Yes.  Ctrl-F8, 4, now select the font.  From that point to the rest of
     the cell and the cells to the right of that point and down the font will
     be changed until another font is selected.

Q:   What is the order of precedence for formatting codes?
A:   1. Text screen.  2. Table edit cell.  3. Table edit column.  (Codes
     entered from the document editing screen will override codes entered from
     a Table Edit Screen.  Cell codes override column codes.)

Q:   If a cell is joined, will the attributes be lost?
A:   Yes.  The attribute of the farthest left cell will be given to the new
     joined cell.

Q:   How are the attributes of the column/cell displayed when the column/cell
     had its attributes set in the Table Edit Menu?
A:   Only via the position number.  If there is a formula, that will show in
     the lower left corner of the screen as will align character (prior to a
     period) if applicable.  There is no other way.

Q:   Can I see all the attributes on the screen without viewing it?
A:   Yes and no.  If your screen shows all the combinations of attributes
     distinctly then sure.  But the monochrome monitor has its limits.  Right,
     center, or left justified are not shown except visually.  Bold will be
     bold, underline, will usually be underline.  The other depends on the
     monitor.  If the attribute was set in Table edit mode, it can't be seen
     in the normal editing screen, give up trying to find it in reveal codes,
     you will have to print or view.  This could be a potential problem.

Q:   Can I specify shading?
A:   Each cell can be turned on or off for shading.  The shading is found in
     Lines in the Table Edit menu.  Default for the darkness of shading may be
     found in Options.
 
                        Cell Manipulations In Tables
 
Q:   Is it possible to change cell/column size after a table is created?
A:   Yes, the column can be changed with the control arrows in the Table Edit
     menu, or via the Format, Column, Width---keep in mind that you will not
     be allowed to exceed your margins.  The cell can only be changed by what
     is held in it.

Q:   Can I split one row differently than the rest of the table?  Can one cell
     be longer than another cell in the same row?
A:   Yes.

Q:   When a cell's size is changed, what happens to the text inside?
A:   It wraps.  If you calculate a number that will not fit in the columns
     width, then it wraps.  It may not wrap and rewrite the screen
     immediately, if it looks wrong in the text screen, go in view and back
     out which forces it to rewrite.

Q:   When I size and add cells/columns where does wp add them?
A:   In the Table Edit menu, pressing the Delete key will ask to delete rows,
     or columns.  If rows, you choose row, 3, it will delete the row that you
     cursor is in and two rows down.  If columns, and 3, it will delete the
     present column and additional two columns to the right.  Pressing the
     Insert key will insert a row or column below the current row or to the
     right of the current column.

Q:   Can I change cell numbers?
A:   Unlike footnotes, endnotes and pages a cell's address cannot be changed. 
     It could become altered using split, join and hiding lines to make it
     appear as a different number.

Q:   Can I lock cells?  Why would I?  What are the limits?
A:   Yes.  The purpose is to keep you from changing material in the cell
     accidentally.  You can not modify material in a locked cell without
     unlocking it.  This is most common for a form fill-in, the creator of the
     table locks certain cells the temporary help should not play with.  The
     Limits?  A row or column containing a locked cell can be deleted from the
     Table Edit menu (without even a protest by wp).  Kind of like deleting a
     pass-worded file.

Q:   Can I move a locked cell?
A:   Yes, and the locked cell will sort too.

Q:   What do locked cells "look" like?
A:   The cell number has a square bracket around it. ie Cell [A1] Doc 1 Pg 1
     Ln 1.2.

                          Tables Like A Spreadsheet
 
Q:   How do tables work with spreadsheets?  How are they the same/different?
A:   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 5.1 and any Lotus compatible spreadsheet. 
          (This includes PlanPerfect.)
 
     Differences:
     1.   Tables do not have a command language.
     2.   You can join or split cells in tables.

Q:   What type of conversion is needed for a Lotus or Plan Perfect
     spreadsheet?
A:   None.  Just retrieve it either by List Files or by Shift F10.

Q:   What versions of Lotus come over?
A:   All but the 3.0.

Q:   Can I output to Plan or Lotus?
A:   No.  Nor are there plans to allow such.

Q:   Can I retrieve only part of a spreadsheet?
A:   Yes, by linking specific cells from that spreadsheet.  You can not
     retrieve part of a spreadsheet with Shift-F10.

Q:   Is there a way to split an extra large spreadsheet into two different
     tables?
A:   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 the table that was blocked.

Q:   Is it possible to have a row and column border like in a spreadsheet?
A:   No, the status line is the indicator.

Q:   What will happen to the macros imported (cell macros from a spreadsheet
     program) into a table?
A:   They are treated as text if they were visible in the spreadsheet.

Q:   Will Tables do formulas with "if" statements or other "Lotus/Plan"like
     formulas?
A:   No.  Tables math is very simple and straight forward math and does not
     have a complex command language.

Q:   How complicated can the formulas be?
A:   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.

Q:   Is recalculation necessary or will WP do it automatically?
A:   WP does not possess the ability to do it automatically, except when
     creating a formula it will calculate automatically.

Q:   Does copying a Math formula automatically increment the formula?
A:   Yes

Q:   In the Math, imputing a formula, can it be done by pointing to a cell and
     pressing enter?
A:   No.

Q:   How do I delete a formula?
A:   The same place the formula was entered (via the Table Edit, Math,
     Formula) delete the formula.  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.

Q:   Can I make formulas absolute so the cell references do not change when
     copying?
A:   No.

                 Converting 4.2 And 5.0 Features Into Tables
 
Q:   Can I convert a 4.2/5.0 math document to tables?
A:   Yes there is absolutely no problem placing the information in tables by
     blocking the information and pressing the tables key and selecting create
     from tab.  The possible problem is that the formulas will not come over
     though the numbers that were created by a calculation will.

Q:   Can I convert 5.0 parallel columns to Tables?
A:   Yes.  Just block the entire material press the table key select create
     and from parallel columns and its taken care of.  If you blocked a
     parallel column do not choose tabular column or vice a versa!
 
                         Text Vs. Numbers In Tables
 
Q:   Will the program know if I am entering text or numbers?
A:   It will know if you enter text or numbers.  Currently it will calculate
     if a number precedes letters, it will ignore the letters in the
     calculation.  It is recommended that if phone numbers or something like
     it is entered and would not like to consider the cell as a number then
     Format, Cell, Type, Text, and WP will consider the cell as text
     regardless of the contents.
 
                            Tables And Generation
 
Q:   How is a table treated in generation?
A:   A list will automatically generate a table as a "table box" which is list
     8.  Also, if you have a table box above and one below a Table, the one
     below will read as table box 3, the Table being counted as number 2.

Q:   In the cross referencing (auto reference in 5.0) can I refer to specific
     cells?
A:   No.
 
                       Using Reveal Codes With Tables
 
Q:   How can I use reveal codes to edit Tables?
A:   The code [Cell] will show in reveal codes for each cell of your table. 
     The [Row] will appear for each row.  You cannot delete a [Cell] or [Row]
     code (or the table end def code).  This is a safeguard.  The only way to
     remove a [Cell] or [Row] is to delete or edit the table via the table
     edit menu.  When a table definition is deleted from reveal codes, the
     [Cell] codes are turned to tabs, and [Row] codes into [HRt]'s.  If this
     is done accidentally, you can block the screen and go into Tables.  This
     will create your table again but it may need some editing to get it back
     to its original form.  To reduce editing you may wish to place a tab
     setting at the top of the "former" table then block and go into Tables.

Q:   If I have more than one table per page how can I tell which table I am in
     when cross referencing.
A:   There doesn't seem to be a really good answer except find the definition
     code which will show which table it is.
 
                              Table Limitations
 
Q:   What is the minimum a cell can hold?  
A:   A cell must always have at least one line.  You may define a row of cells
     to have a minimal area, ie .001 and it will accept type but will not
     print.  It will only print if the minimal row height is at least as high
     as the minimal line height.  ie.  You can have a 6pt font which has a
     line height of .111 and that would be the minimum height that a row of
     cells can be set. In reality the minimum row height + distance between
     cell line and text is the actual minimum cell height.

Q:   Is there a K limit to one cell?
A:   No.

Q:   What is the minimum/maximum column width?
A:   The Minimum is one character plus the right and left border space (set in
     the Table Edit, Options) and the left border.  ie. .1" + .1" + .1" + .1"
     =.4" is the minimum using the system defaults and a Courier 10 pitch.
 
     The Maximum is the distance between left and right margins less the left
     border + right border (if only one column in the Table) and distance
     between text and border (both left and right).  ie 8.5 wide paper with 1"
     margins= 6.5 -.1" -.1" -.1" - .1" = 6.1" of usable cell/column.

Q:   How does WP decide how wide to make each cell?
A:   WP initially uses all available space between the margins.  Once the
     table is created wp will keep the cell between the margins and will not
     exceed them (exception being large imported spreadsheets).  If the
     margins increase WP will not expand the table to fit them unless Options,
     Position, Full is chosen in the Table Edit menu.

Q:   What are column and row limits?
A:   32 Columns by 32,765 Rows.  The larger the table the slower the
     calculations and manipulation.

Q:   What is the default table size?  Cell?  Row?
A:   WP will check the margins and default the width of the table to be the
     width of the margins.  Default is 3 columns by 1 row.

Q:   Is there a limit to the number of tables in a document?
A:   No.
 
                               Sorting Tables
 
Q:   In Sort, will it always default to table mode when inside of a table?
A:   Yes.  Unless you blocked something before entering sort.  Incidentally,
     when in the Sort by Table mode selecting 7 Type will produce absolutely
     nothing not even an error message.

Q:   Can you View while in the sorting menu in Tables to see which cells you
     should be sorting by?
A:   Yes.

Q:   Will sorting move a locked cell?
A:   Yes.

Q:   Can a select statement be done in a table?
A:   Yes. 

                             Tables And Graphics
 
Q:   Can I have graphics in a table?
A:   Yes.  It is best not to have a page graphic in a table.  Paragraph and
     character graphics work best.  The graphic will not be able to exceed the
     limits of the column width but generally have quite a bit of latitude
     with length.

Q:   Does the cell with a graphic in it re-size automatically?
A:   Vertically yes.  Horizontally the graphic is limited to the width of the
     cell less the border space between lines and text.

Q:   Can I do a table in a graphic box?
A:   Yes.  A table will work fine in a box, be aware that the table must
     occupy a minimum of space.  If the table size will not fit into the
     graphic it could exceed the graphic on the printed page.

Q:   Parallel columns, will they work with tables?
A:   Tables cannot be placed into columns.  Tables can be placed into graphic
     boxes which can be placed into columns.  With that in mind, that also
     should tell you how to make text wrap around a table.
 
                         Tables And Bitstream Fonts
 
Q:   Will tables work with 3rd party fonts like Bitstream?
A:   Yes, Table lines will work with the 3rd party fonts because they are
     graphics not related to fonts.
 
                             Tables And Headers
 
Q:   What is a header in a table?
A:   A Table Header much like a header in the format page menu, is something
     that will print at the top of each page.  In tables the header key will
     allow you to designate how many rows will be printed at the top of each
     page of a multi-paged table.  Ie: The first two rows contains several
     column heading.  Anywhere on my table in the table edit screen I can
     specify header and choose two rows.  Wp will automatically attach the
     first two rows of the table to each page that table covered.

Q:   If I have a table header defined, can I have normal headers and footers?
A:   Yes, the two are related only by the fact that to see them you should
     view document.  In every other way they are different.

Q:   Can I place a table in a normal header or footer?
A:   Yes.
 
                               Editing Tables
 
Q:   Can I use a center, tab, right align, etc in a table?
A:   Yes.  If tab setting are already in use, the home tab, home center, home
     right align and home flush right will change the attribute of a
     particular tab setting in or out of the table menu.

Q:   Can I justify within cells?
A:   Justification can be made left, right, center or full (5.0 called this
     justification on) either by cell or column in the Table Edit mode or in
     the normal editing screen.

Q:   Is there an automatic way to center information in a cell top to bottom?
A:   No, there is no code like center text in cell.  However you may use enter
     keys to move it down.

Q:   Which formatting codes take precedence over the other formatting codes?
A:   Codes entered from the document editing screen will override codes
     entered from a Table Edit Screen.  Cell codes override column codes.

Q:   How do I delete specific areas of a table?
A:   Block and delete in a normal edit screen, not in the table edit screen.

Q:   Can I scale a Table?
A:   In the Table Edit screen , you change the Size of a table or Insert rows
     or columns or Delete rows or columns. 

Q:   Is the GoTo key available in tables?
A:   Yes but only in the Table Edit mode.

Q:   How do I move from column to column?
A:   Tab, arrow keys, mouse.  While in Table Edit, tabs, and arrow keys only.

Q:   Do I need to exit Table Edit mode to input text or view document?
A:   Yes.
 
                          Block/Copy/Move In Tables
 
Q:   Can I block and copy to a second column?
A:   Yes.  In the Table Edit mode press control F4 and choose column and copy
     the column.  Pretty straight forward.

Q:   Can I move one row or column to another location in the same Table?  Into
     another table?
A:   Yes.

Q:   Can I block and copy tables?
A:   Yes.
 
                          Cancel/Restore And Tables
 
Q:   Can a Table def code be restored by an F1, 1 Restore?
A:   No.

Q:   Does Restore work in the Table Edit screen?
A:   Yes, deletions done via the Delete key in the Table Edit screen, may be
     restored in the table edit screen.  Deleting via the Size key cannot be
     restored.
