Commodore Plus 4 - Page 149

Sections. Spreadsheet Commands 137
where the cell cursor is currently located. The cells are copied into the same
column positions. The cells in the row that is being copied are not affected; this is
a duplication, not a transfer.
To use the RCO command, move the cell cursor into any cell in the row that is
the destination of the copied row. Then type the RCO command followed by the
row number of the row whose cells you are copying. Type a semicolon at the end
of the command and press RETURN. The message WORKING is displayed on
the status line while the procedure is being executed. Then the cells from the
copied row appear in the same row positions in the new row. The cells in the old
row are not affected.
Several precautions must be taken with the RCO command:
1. The RCO command overwrites any cell entries that are already present in the
cell 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 row is copied into the row where
the frozen cell is located.
2. The RCO command does not adjust formulas when the row is copied. If any of
the cells is used in a formula, you must change the formula manually. It is best
to use RCO only to copy data into a row below all the rows you have already
entered. Copying rows into the midst of filled rows can lead to errors and
oversights even if you use the RINS command to insert a blank row before you
copy. Like RCO, RINS does not adjust the formulas in the affected rows.
3. Be sure to type a semicolon at the end of the RCO command or the command
will not work.
Example: rco3; Copies all the entries from row 3 into the row where the cell cursor
is currently located.
RDEL SS
Deletes all the cell entries in an entire row. If there are any rows below the
deleted row, they are moved up one row to fill in the deleted row. Be careful when
you use the Row DELete command: RDEL does not adjust any formulas that are
affected by a row deletion. Any formulas that refer to cells below a deleted row
will most likely be affected, and you will have to change the formulas manually.
Example: rdel Deletes the current row.
RESET SS
Clears the work areas of all the built-in programs and starts the built-in
software over as if you had just turned the software on. The computer goes back