20 #ifndef INCLUDED_SC_SOURCE_FILTER_INC_AUTOFILTERBUFFER_HXX
21 #define INCLUDED_SC_SOURCE_FILTER_INC_AUTOFILTERBUFFER_HXX
26 #include <com/sun/star/sheet/TableFilterField3.hpp>
29 namespace sheet {
class XDatabaseRange; }
30 namespace sheet {
class XSheetFilterDescriptor3; }
33 namespace oox {
class AttributeList; }
34 namespace oox {
class SequenceInputStream; }
49 void appendField(
bool bAnd, sal_Int32 nOperator,
double fValue );
50 void appendField(
bool bAnd, sal_Int32 nOperator,
const OUString& rValue );
51 void appendField(
bool bAnd,
const std::vector<OUString>& rValues );
171 template<
typename FilterSettingsType >
180 std::shared_ptr< FilterSettingsBase >
221 void finalizeImport(
const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
249 bool finalizeImport(
const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
Helper class to provide access to global workbook data.
void importSortState(const AttributeList &rAttribs, sal_Int16 nSheet)
::std::vector< css::sheet::TableFilterField3 > FilterFieldVector
OUString maSortCustomList
void appendCriterion(const FilterCriterionModel &rCriterion)
Appends the passed filter criterion, if it contains valid settings.
sal_Int32 mnOperator
Comparison operand.
bool mbTop
Number of items or percentage.
SortConditionVector maSortConditions
FilterColumnVector maFilterColumns
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs)
Derived classes import filter settings from the passed attribute list.
OptValue< bool > mobNeedsRegExp
List of UNO API filter settings.
Contains UNO API filter settings for a column in a filtered range.
exports com.sun.star. sheet
void importAutoFilter(const AttributeList &rAttribs, sal_Int16 nSheet)
Imports auto filter settings from the autoFilter element.
virtual ApiFilterSettings finalizeImport(sal_Int32 nMaxCount) override
Returns converted UNO API filter settings representing all filter settings.
AutoFilter & createAutoFilter()
Creates a new auto filter and stores it internally.
A filter criterion for a custom filter.
SortCondition & createSortCondition()
void importFilterColumn(const AttributeList &rAttribs)
Imports auto filter column settings from the filterColumn element.
FilterCriterionModel()
Operand data type (BIFF only).
RefVector< AutoFilter > AutoFilterVector
void importSortCondition(const AttributeList &rAttribs, sal_Int16 nSheet)
Settings for a custom filter, specifying one or two comparison operators associated with some values...
AutoFilter(const WorkbookHelper &rHelper)
FilterCriterionVector maCriteria
DiscreteFilter(const WorkbookHelper &rHelper)
CustomFilter(const WorkbookHelper &rHelper)
AutoFilterVector maAutoFilters
RefVector< SortCondition > SortConditionVector
FilterColumn(const WorkbookHelper &rHelper)
AutoFilter * getActiveAutoFilter()
Returns the auto filter object used to perform auto filtering.
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs) override
Imports filter settings from the filters and filter elements.
std::vector< OUString > maValues
ApiFilterSettings()
If set, requires regular expressions to be enabled/disabled.
FilterSettingsBase & createFilterSettings()
Creates and returns the specified filter settings object.
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs) override
Imports filter settings from the filters and filter elements.
sal_uInt8 mnDataType
Comparison operator.
void finalizeImport(sal_Int16 nSheet)
Applies filter settings to a new database range object (used for sheet autofilter or advanced filter ...
void appendField(bool bAnd, sal_Int32 nOperator, double fValue)
void readBiffData(SequenceInputStream &rStrm)
Imports the criterion model from the passed BIFF12 stream.
RefVector< FilterColumn > FilterColumnVector
FilterColumn & createFilterColumn()
Creates a new auto filter column and stores it internally.
virtual void importRecord(sal_Int32 nRecId, SequenceInputStream &rStrm) override
Imports filter settings from the FILTERS and FILTER records.
virtual void importRecord(sal_Int32 nRecId, SequenceInputStream &rStrm) override
Imports filter settings from the FILTERS and FILTER records.
ApiFilterSettings finalizeImport(sal_Int32 nMaxCount)
Returns converted UNO API filter settings representing all filter settings of this column...
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs) override
Imports filter settings from the filters and filter elements.
virtual void importRecord(sal_Int32 nRecId, SequenceInputStream &rStrm)
Derived classes import filter settings from the passed record.
SortCondition(const WorkbookHelper &rHelper)
bool mbPercent
True = show top (greatest) items/percentage.
A column in a filtered range.
FilterSettingsBase(const WorkbookHelper &rHelper)
std::shared_ptr< FilterSettingsBase > mxSettings
::std::vector< FilterCriterionModel > FilterCriterionVector
virtual ApiFilterSettings finalizeImport(sal_Int32 nMaxCount) override
Returns converted UNO API filter settings representing all filter settings.
void finalizeImport(const css::uno::Reference< css::sheet::XDatabaseRange > &rxDatabaseRange, sal_Int16 nSheet)
Applies the filter to the passed filter descriptor.
Settings for a discrete filter, specifying a list of values to be shown in the filtered range...
Top10Filter(const WorkbookHelper &rHelper)
Base class for specific filter settings for a column in a filtered range.
Settings for a top-10 filter.
virtual ApiFilterSettings finalizeImport(sal_Int32 nMaxCount) override
Returns converted UNO API filter settings representing all filter settings.
virtual void importRecord(sal_Int32 nRecId, SequenceInputStream &rStrm) override
Imports filter settings from the FILTERS and FILTER records.
void setBiffOperator(sal_uInt8 nOperator)
Sets the passed BIFF operator constant.
AutoFilterBuffer(const WorkbookHelper &rHelper)
FilterFieldVector maFilterFields
virtual ApiFilterSettings finalizeImport(sal_Int32 nMaxCount)
Derived classes return converted UNO API filter settings representing all filter settings.