Figure 129: Defining Names on a worksheet
Reference operators
In its simplest form a reference refers to a single cell, but references
can also refer to a rectangle or cuboid range or a reference in a list of
references. To build such references you need reference operators.
An individual cell is identified by the column identifier (letter) located
along the top of the columns and a row identifier (number) found along
the left-hand side of the spreadsheet. On spreadsheets read from left to
right, the upper left cell is A1.
Range operator
The range operator is written as colon. An expression using the range
operator has the following syntax:
reference left : reference right
The range operator builds a reference to the smallest range including
both the cells referenced with the left reference and the cells
referenced with the right reference.
186 OpenOffice.org 3.x Calc Guide
Commentaires sur ces manuels