OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 329)

Table 16. Advanced filter properties.

Property Comment

ContainsHeader Boolean (true or false) that specifies if the first row (or

column) contains headers which should not be filtered.

CopyOutputData Boolean that specifies if the filtered data should be copied

to another position in the document.

IsCaseSensitive Boolean that specifies if the case of letters is important

when comparing entries.

Orientation Specifies if columns

(com.sun.star.table.TableOrientation.COLUMNS) or rows

(com.sun.star.table.TableOrientation.ROWS) are filtered.

OutputPosition If if CopyOutputData is True , specifies the position where

filtered data are to be copied.

SaveOutputPosition Boolean that specifies if the OutputPosition position is

saved for future calls.

SkipDuplicates Boolean that specifies if duplicate entries are left out of the

result.

UseRegularExpression

Boolean that specifies if the filter strings are interpreted as

regular expressions.

Listing 18. Copy filtered results to a different location.

REM Copy the output data rather than filter in place.

oFiltDesc.CopyOutputData = True

REM Create a CellAddress and set it for Sheet3,

REM Column B, Row 4 (remember, start counting with 0)

Dim x As New com.sun.star.table.CellAddress

x.Sheet = 2

x.Column = 1

x.Row = 3

oFiltDesc.OutputPosition = x

(Advanced material.) The OutputPosition property returns a copy of a struct. Because

a copy is returned, it is not possible to set the individual values directly. For example,

oFiltDesc.OutputPosition.Row = 2 does not work (because you set the Row on the

copy to 2, but do not change the original).

Manipulating filtered data

Filtered data copied to a new location may be selected, modified, and deleted at will.

Data that is not copied, however, requires special attention because rows that do not

match the filter criteria are simply hidden. OpenOffice.org behaves differently

depending on how the cells became hidden and what operation is done.

Cells may be hidden using an outline, data filter, or the hide command. When data is

moved by dragging or using cut and paste, all of the cells are moved—including the

hidden cells. When copying data, however, filtered data includes only the visible cells

and data hidden using an outline or the hide command copies all of the data.

Chapter 13 Calc as a Simple Database 329

1 2 ... 324 325 326 327 328 329 330 331 332 333 334 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 329

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3