OpenOffice.org OpenOffice - 3.3 Podstawowy Przewodnik Pobierz pdf (Strona 319)

100

101

Caution

It is possible to create multiple named ranges with the same name.

Creating multiple ranges with a single command increases the

likelihood that multiple ranges will be created with the same name—

avoid this if possible.

Database range

Although a database range can be used as a regular named range, a database range

also defines a range of cells in a spreadsheet to be used as a database. Each row in a

range corresponds to a record and each cell corresponds to a field. You can sort,

group, search, and perform calculations on the range as if it were a database.

A database range provides behavior that is useful when performing database related

activities. For example, you can mark the first row as headings. To create, modify, or

delete a database range, use Data > Define Range to open the Define Data Range

dialog (see Figure 323). When you first define a range, the Modify button shown in

the example is labeled New.

Figure 323. Define a database range.

In a macro, a database range is accessed, created, and deleted from the

DatabaseRanges property. The macro in Listing 13 creates a database range named

MyName and sets the range to be used as an auto filter.

Chapter 13 Calc as a Simple Database 319

1 2 ... 314 315 316 317 318 319 320 321 322 323 324 ... 433 434

Komentarze do niniejszej Instrukcji

Brak uwag

OpenOffice.org OpenOffice - 3.3 Podstawowy Przewodnik Strona 319

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie OpenOffice.org OpenOffice - 3.3