www.delorie.com/gnu/docs/oleo/oleo_3.html

search

	Buy GNU books!

Oleo

1.2 Cell Referencing

Many commands and functions operate on a given cell or group of cells, and therefore take a cell or range reference (address) as an argument. An individual cell is specified by its row/column coordinates, which start with row 1, column 1 in the upper left of the spreadsheet. A range is a rectangular group of cells, specified by giving its left and rightmost columns and top and bottom rows.

A reference may be absolute or relative. An absolute reference is measured from the upper left of the spreadsheet, and does not change when the cell containing it is moved or copied. A relative reference, however, is measured as an offset from the cell it is in, and when moved points to the cell at the same offset relative to the new location.

There are two ways of addressing cells in Oleo, called a0 and noa0. To switch between the modes, use the set-option command:

M-x set-option a0

Sets a0 mode.

M-x set-option no a0

Sets noa0 mode.

In both modes the case of cell and range letters is ignored.

1.2.1 noa0 Mode		Using noa0 Mode
1.2.2 a0 Mode		Using a0 Mode
1.2.3 Comparison		Comparing a0 and noa0 modes