25 #include <com/sun/star/sheet/TableFilterField3.hpp>
26 #include <com/sun/star/util/Color.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, css::util::Color aColor,
bool bIsBackgroundColor );
52 void appendField(
bool bAnd,
const std::vector<std::pair<OUString, bool>>& rValues );
90 std::vector<std::pair<OUString, bool>>
maValues;
193 template<
typename FilterSettingsType >
202 std::shared_ptr< FilterSettingsBase >
243 void finalizeImport(
const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
271 bool finalizeImport(
const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
Helper class to provide access to global workbook data.
virtual ApiFilterSettings finalizeImport() override
Returns converted UNO API filter settings representing all filter settings.
void importSortState(const AttributeList &rAttribs, sal_Int16 nSheet)
::std::vector< css::sheet::TableFilterField3 > FilterFieldVector
OUString maSortCustomList
virtual void importRecord(sal_Int32 nRecId, SequenceInputStream &rStrm) override
Imports filter settings from the FILTERS and FILTER records.
virtual ApiFilterSettings finalizeImport() override
Returns converted UNO API filter settings representing all filter settings.
void appendCriterion(const FilterCriterionModel &rCriterion)
Appends the passed filter criterion, if it contains valid settings.
sal_Int32 mnOperator
Comparison operand.
Settings for a color filter.
bool mbTop
Number of items or percentage.
SortConditionVector maSortConditions
ColorFilter(const WorkbookHelper &rHelper)
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.
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
virtual ApiFilterSettings finalizeImport()
Derived classes return converted UNO API filter settings representing all filter settings.
FilterColumn(const WorkbookHelper &rHelper)
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs) override
Imports filter settings from the filters and filter elements.
AutoFilter * getActiveAutoFilter()
Returns the auto filter object used to perform auto filtering.
ApiFilterSettings finalizeImport()
Returns converted UNO API filter settings representing all filter settings of this column...
bool mbIsBackgroundColor
Whether we are dealing with the background color (vs. text color)
virtual void importAttribs(sal_Int32 nElement, const AttributeList &rAttribs) override
Imports filter settings from the filters and filter elements.
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.
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
virtual ApiFilterSettings finalizeImport() override
Returns converted UNO API filter settings representing all filter settings.
::std::vector< FilterCriterionModel > FilterCriterionVector
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 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() override
Returns converted UNO API filter settings representing all filter settings.
OUString msStyleName
Style name to retrieve the color from.
std::vector< std::pair< OUString, bool > > maValues