Calc Guide

The filter created in Listing 17 filters the data in place. Modify the
OutputPosition property to specify a different output position (see
Listing 18). The filter descriptor must be modified before the filter is
applied.
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.
UseRegularExpressi
ons
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
374 OpenOffice.org 3.x Calc Guide