OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung PDF herunterladen (Seite 315)

100

101

Tip

Although the choice to associate a row to a record rather than a column is

arbitrary, it is almost universal. In other words, you are not likely to hear

someone refer to a column of data as a single database record.

Associating a range with a name

In a Calc document, a range refers to a contiguous group of cells containing at least

one cell. You can associate a meaningful name to a range, which allows you to refer

to the range using the meaningful name. You can create either a database range,

which has some database-like functionality, or a named range, which does not. A

name is usually associated with a range for one of three reasons:

1) Associating a range with a name enhances readability by using a meaningful

name.

2) If a range is referenced by name in multiple locations, you can point the name

to another location and all references point to the new location.

3) Ranges associated to a name are shown in the Navigator, which is available by

pressing the F5 key or clicking on the icon. The Navigator allows for quick

navigation to the associated ranges.

Named range

The most common usage of a named range is, as its name implies, to associate a

range of cells to a meaningful name. For example, create a range named Scores, and

then use the following equation: =SUM(Scores). To create a named range, select the

range to define. Use Insert > Names > Define to open the Define Names dialog.

Use the Define Names dialog to add and modify one named range at a time.

Figure 321. Define a named range.

Chapter 13 Calc as a Simple Database 315

1 2 ... 310 311 312 313 314 315 316 317 318 319 320 ... 433 434

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org OpenOffice - 3.3 Grundlegende Anleitung Seite 315

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software OpenOffice.org OpenOffice - 3.3