OpenOffice.org OpenOffice - 3.2 Guia Básico descarregar pdf (Página 364)

100

101

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 306).

When you first define a range, the Modify button shown in the example

is labeled New.

Figure 306. 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.

364 OpenOffice.org 3.x Calc Guide

1 2 ... 359 360 361 362 363 364 365 366 367 368 369 ... 496 497

Comentários a estes Manuais

Sem comentários

OpenOffice.org OpenOffice - 3.2 Guia Básico Página 364

Comentários a estes Manuais

Manuais e produtos relacionados com Software OpenOffice.org OpenOffice - 3.2