Commodore Plus 4 - Page 136

124 The Built-in Software
CCO SS
Lets you copy the cell entries from one column into another. CCO (Column
COpy) writes a duplicate of all cell entries from the column you are copying into
the column where the cell cursor is currently located. The cells are copied into the
same row positions. The cells in the column that is being copied are not affected;
this is a duplication, not a transfer.
To use the CCO command, move the cell cursor into any cell in the column that
is the destination of the copied column. Then type the CCO command followed
by the column number of the column whose cells you are copying. Type a
semicolon at the end of the command and press RETURN. The message WORK
ING is displayed on the status line while the procedure is being executed. The cells
from the copied column then appear in the same row positions in the new column.
The cells in the old column are not affected.
Several precautions must be taken with the CCO command:
1. The CCO command overwrites any cell entries that are already present in the
cells into which you are copying. This means that those cell entries are lost. You
can protect a cell against overwriting by freezing the value with the FRE
command. A frozen cell remains intact when a column is copied into the
column where the frozen cell is located.
2. The CCO command does not adjust formulas when the column is copied. If
any of the cells is used in a formula, you must change the formula manually. It
is best to use CCO only to copy data into a column past all the columns you
have already entered. Copying columns into the midst of filled columns can
lead to errors and oversights even if you use the CINS command to insert a
blank column before you copy. Like CCO, CINS does not adjust the formulas
in the affected columns.
3. Be sure to type a semicolon at end of the CCO command or the command will
not work.
Example: cco3; Copies all the entries from column 3 into the column where the cell
cursor is currently located.
CDEL SS
Deletes all the cell entries in an entire column. If there are any columns to the
right of the deleted column, they are moved one column to the left to fill in the
deleted column. Be careful when you use the CDEL (Column DELete) command:
CDEL does not adjust any formulas that are affected by a column deletion.
Formulas that refer to cells to the right of a deleted column will most likely be
affected, and you will have to change the formulas manually.
Example: cdel Deletes the column where the cursor is currently located.