|
- Numbering rows in a table
- Method A: Use QuickFill
- Type a "1" in the
first (top left) cell, then a "2" in the next cell
down, in column A. Select the entire column (tip: move the cursor
inside the column until it turns to an up arrow, then double-click
your mouse), right-click the selected column, and choose QuickFill
from the context menu that appears. All cells in that column
will be populated with incrementing numbers.
- Method B: Use a table formula
- Postion the cursor in the first
(top) cell of the column you want numbered, then click on Table>Formula
Toolbar.
- Click on Functions, then select
All, and scroll down to Row(). Clck on Row(), then Insert. The
formula will appear to the right of the blue arrow in the formula
field. Click on the blue checkmark and the function will put
the row number in the cell.
- Alternative: Just type (without
quotes) "+Row()" into the formula field, then click
the blue checkmark.
- Click on Copy Formula. Select
Down, and enter the number of rows into which to copy the function.
(Tip: To copy it to all rows in the column, click and hold the
small up arrow to the right of the field; it will increment numbers
until it reaches the maximum.)
- Method C: Use a macro to populate
all cells in the column
- Here's a macro that can do the
same thing as QuickFill, but can be played anytime -- especially
after inserting or deleting rows, which can cause disruptions
in numbering the rows.
- Note that the table formula
method will not suffer disruptions since +Row() always returns
the current row number. Note also that the macro assumes you
want to start numbering in cell A1; if not, delete the first
PosTableBegin command.
|
// QuickFill.wcm
// Deletes any existing items
in the first column, then adds incrementing numbers (1..n) in
that column.
If(NOT ?InTable)
Quit
Endif
Messagebox(vAns; "Caution";
"The first column's contents will be deleted and replaced
with incrementing numbers." ; OKCancel!)
If(vAns=2)
Quit
Endif
PosTableBegin
SelectTableColumn
SelectDelete
Type("1")
PosCellDown
Type("2")
SelectTableColumn
TableDataFill
SelectOff
PosTableBegin
Quit |
- A more robust version of the
QuickFill macro can be found in the Library.
- Method D: Use automatic paragraph
outline numbers in the column's cells (see
here)
- Wrapping text around a table
- The table should already have
been created. In the Reveal Codes window, carefully select and
copy (Ctrl+C) everything between (and including) the [Tbl
Def] and [Tbl Off] codes to the Windows clipboard.
- Open a new, empty document and
paste the table into it for temporary safe-keeping. Return to
the original document and delete the original table (including
the [Tbl Def] and [Tbl Off] codes). Reformat any document text,
if needed.
- Create a graphics box on the
page with Insert, Graphics, Custom Box, Table, OK. Double-click
on the empty box to edit it (or right-click it, then choose Content,
Edit). Paste the table (Ctrl+V) from the clipboard into the Editor
window that appears, then exit back to the document with File,
Close or by clicking the Close icon on the property bar. (Note
that the box can be resized later; the table will resize automatically
inside the box, unless you have fixed the sizes of columns.)
- Select the box by right-clicking
on it and choosing Select Box from the context menu. (Eight "drag
handles" appear around the perimeter.) This will let you
drag the box into a new position on the page. Or, you can use
Position from the context menu to specify an exact location.
(The box can be repositioned later, if needed.)
- While still selected, right-click
the box and Choose Position, Attach...; this lets you "anchor"
the box in a specific location. (For small tables you probably
want to anchor it to a specific paragraph so it will move with
that paragraph.)
- Right-click the box again. From
the context menu you can wrap the text around the box in various
ways, or re-size the box, reposition it, add a border, add a
caption, etc. You should experiment with the various options
to get the effect you want.
- Exit from the box by clicking
elsewhere on the page.
- Related tips:
- If you resize columns to a specific
width, set the table to "Center" position on the "page"
(right-click the table, use Format on the context menu, then
look under the Table tab). "Full" overrides the column
widths, but lets you automatically expand/contract the table
width by adjusting the graphic box's dimensions.
- This is a good technique to
use if you need to rotate a table 90 degrees, since you can rotate
the contents of the box by right-clicking it and choosing Content,
Rotate.... This can be useful when mixing
landscape pages with portrait pages.
- Force a table cell that could possibly evaluate
to zero to display blank
(i.e., not show a "0"):
- Assuming you are calculating
figures in two columns (e.g., cell A1 times cell B1) and want
the result to be shown in the third column (e.g., cell C1) only
if it is not equal to zero. Then, in Cell C1 (here, we
assume the result of A*B should be multiplied by .50) -
- +IF((A1*B1)=0, "",
(A1*B1)*.50)
- (Note the use of two double
quotes with no space between them.)
- Sorting
WordPerfect tables
- It is a good idea to save the
document before performing any sort on it. Make sure to enable
"Allow Undo" in the Options button drop list.
- The individual items in a sort
are considered to be "records." WordPerfect lets you
sort five kinds of records: lines, paragraphs, merge records,
parallel columns, and the rows in a table. Each row of a table
is divided by cells (Columns), lines (Rows), and words. Cells
are numbered from left to right, starting with cell 1.
- To define a custom Table sort:
Place your cursor in the table, click Tools, Sort, New. Give
the sort a name, then with the Table Row button enabled, define
the "Sort by" rule (or key), which defines the
order in which the sort will be conducted. You can define additional
rules with the Add Key button.
- Normally, lowercase sorts before
uppercase. To reverse this, click the Options button and choose
"Uppercase sorts before lowercase."
- To sort by the last word, use
"-1" (without quotes) in the Word field, "-2"
for the next to last word, etc.
- Note that WordPerfect codes
([Tab], [Hd Left Ind], etc.) are treated as field
separators by the sort feature. Spaces, forward slashes (/)
and hyphens separate words.
- Sorting regular paragraphs in reverse order
- If you are keeping a diary,
journal, or other document where you enter new lines (or paragraphs)
at the end of the document, but now want to reverse the order
of the items so that the most recent are at the top:
- Select all paragraphs in the
document. Click Table, Create and set the Columns = 1 and Text
Delimiters = Paragraphs. Click OK. You should now have a table
with all document paragraphs in separate cells.
- With the cursor in the table,
click Table, Insert, Columns = 1, Before, OK. You should now
have a two-column table with the first column being empty.
- Enter a 1 in the top cell of
the first column, and a 2 in the cell just below it. Select just
the entire first column, then click Table, QwickFill. This should
sequentially number all cells in the first column. Click in the
second column (or outside the table) to deselect the first column.
- With the cursor in the table,
click Tools, Sort to bring up the Sort dialog. Choose "First
cell in a table row," then click New. Give the new sort
routine a name (e.g., "Reverse table sort"). The "Sort
by" radio buttons should be set to "Table row."
Then, under "Keys," set the Type = Numeric and Sort
Order = Descending. Click OK. With the new routine name ("Reverse
table sort") selected in the Sort dialog, click Sort. The
entire table should immediately sort into reverse order.
- Place the cursor in the first
(numbered) column. Click Table, Delete, Columns, 1, OK. You should
now have a one-column table again.
- With the cursor in the table,
click Table, Convert. Select the "Convert tables to text"
button, and the "Separate text with paragraphs (hard returns)."
Click OK.
- "Bracketing"
text outside the left margin with a large "[" bracket
- Here's
the effect. Note that
the text lines up with the left margin, and the bracket is "outdented."
- Here's how to do it and create a QuickWord from it to
make it easy to re-create anytime:
- Open a new blank document. Create
a 1-row, 2-column table with Table, Create.
- Drag the middle vertical cell
border to the left as far as it will go. This leaves a minimum-width
left-hand column (you can resize this column to a specific dimension
by right-clicking in the column, then choosing Format, Column).
Typically, this is 0.67" wide. The right-hand column (the
cell) will extend to the right margin.
- Right-click in the right-hand
column and choose Borders/Fill, and then click the Cell tab.
Remove ("X") all 4 borders from that cell. This should
leave the first cell (i.e., the left-hand column) with a 3-sided
border shaped like a left bracket ("[").
- Right-click in the right-hand
column and set the top/bottom row margins with Format, Row (e.g.,
to 0.40" for each). Be sure to enable (check) "Divide row across pages" and click on the "Multiple lines" option. Set the inside left/right
column margins to 0.0" with Format, Column; while there,
align the contents in cells, if desired.
- Exit from the table. Place the
cursor just before (i.e., just to the left of) the [Tbl On]
code. Change the left margin to 0.933" with Format, Margins.
(This assumes your default left margin is 1.0". If not,
set the margin appropriately so that the left margin dimension
plus the width of the table's left column equal your normal left
margin setting.)
- Place the cursor just after
the [Tbl Off] code and change the left margin back to 1.0"
(or your preferred left margin setting).
- The table should now be outdented
beyond the left margin by the width of the first column.
- To automate
creating the table in future sessions -- turn it into a QuickWord:
- Before adding any text to the table do this:
- In Reveal Codes, place the insertion
cursor before (just to the left of) the [Tbl Def] code.
-
- In Reveal Codes, select
the six adjacent codes (first remove any stray hard returns between
them). These are the codes to select:
[Lft Mar][Tbl Def][Row][Cell][Tbl Off][Lft Mar]
- With the codes selected, create
a QuickWord with Tools, QuickWords.
Perhaps give it the name of "\[" (without quote marks).
- Back in your document, type
(without quotes) "\[".
- Result: A new table with the
"[" border outdented by the same amount as the first
(empty) cell in the table.
- Enter text in the second column
of the table. The bracket will extend downward as you do this
-- including onto the following page if necessary.
|
Barry MacDonnell's