Making Changes
**************

Copying
=======

Both the cells, and the calculated values in the cells, can be copied from one location to another. Note, however, that any relative cell addresses present in formulas will refer to different cells -- those at the same offset from the new location.  In a0 mode, this means that the relative addresses in the new locations' formula(s) will change to reflect the new cells they refer to.

M-c
     Copy a region.  Given two ranges, it copies the source range into the destination range.  If the destination range size is a multiple of the source range size, the source range is copied multiple times.  If the destination range is given as a cell, that cell is the location of the top-left corner of the destination range. (copy-region)

M-C-c
     Copy just the values of one region to another. (copy-values-in-region)

Consider the  spreadsheet, where B2 contains @sum(C2.D2):

                  | Col B | Col C | Col D |
            ------|-------|-------|-------|
            Row 2 |   8   |   3   |   5   |
            ------|-------|-------|-------|
            Row 3 |       |   4   |   2   |
            ------|-------|-------|-------|
            Row 4 |       |   1   |   3   |
            ------|-------|-------|-------|

If you type M-c B2 RET B3.B4, then B2 is unchanged, but B3 contains @sum(C3.D3), since it was copied from a formula with relative addresses. Similarly, B4 contains @sum(C4.D4).  The display shows

                  | Col B | Col C | Col D |
            ------|-------|-------|-------|
            Row 2 |   8   |   3   |   5   |
            ------|-------|-------|-------|
            Row 3 |   6   |   4   |   2   |
            ------|-------|-------|-------|
            Row 4 |   4   |   1   |   3   |
            ------|-------|-------|-------|

If you had typed M-C-c B2 RET B3.B4, then B2 is unchanged, B3 contains 8, B4 contains 8, and the display shows

                  | Col B | Col C | Col D |
            ------|-------|-------|-------|
            Row 2 |   8   |   3   |   5   |
            ------|-------|-------|-------|
            Row 3 |   8   |   4   |   2   |
            ------|-------|-------|-------|
            Row 4 |   8   |   1   |   3   |
            ------|-------|-------|-------|

Moving Cells and Regions
========================

M-m
     This is similar to copy-region, except that the source region is erased after the copy.  The two ranges must be the same size.  Relative addresses and variables whose ranges are inside the source region are adjusted, as with copy-region.  (This can be subtle - some good examples are needed) (move-region)

Consider the previous spreadsheet, where B2 contains @sum(C2.D2).

                  | Col B | Col C | Col D |
            ------|-------|-------|-------|
            Row 2 |   8   |   3   |   5   |
            ------|-------|-------|-------|
            Row 3 |       |   4   |   2   |
            ------|-------|-------|-------|
            Row 4 |       |   1   |   3   |
            ------|-------|-------|-------|

If we type M-m  B2  RET  B3, then B2 is empty, B3 contains @sum(C3.D3), and the display shows

                  | Col B | Col C | Col D |
            ------|-------|-------|-------|
            Row 2 |       |   3   |   5   |
            ------|-------|-------|-------|
            Row 3 |   6   |   4   |   2   |
            ------|-------|-------|-------|
            Row 4 |       |   1   |   3   |
            ------|-------|-------|-------|

Deleting
========

C-k
     Delete the current row.  With an argument count it deletes several rows. (delete-row) For instance, to delete the row containing the cell cursor, and the next 4 rows, type C-u 5 C-k.

M-k
     Delete the current column.  With an argument count it deletes several columns. (delete-col) For instance, to delete the column that the cell cursor is in, and the 3 columns to the right, type C-u 4 M-k.

M-C-?
     Delete the contents (value, formula, format, etc) of a region.  This DOES NOT ask for confirmation. (delete-region)

M-x clear-spreadsheet
     This is an extreme action!  Erase all the values in the cells, and reset all the heights and widths.

Inserting Rows and Columns
==========================

These commands insert blank rows and columns.

C-o
     Insert a row above the cell cursor.  With an argument count it adds several rows. (insert-row) For instance, to add 5 rows above the cell cursor, type C-u 5 C-o.

M-o
     Insert a column to the left of the cell cursor.  With an argument count it adds several columns. (insert-col) For instance, to add 4 rows to the left of  the cell cursor, type C-u 4 M-o.