diff options
Diffstat (limited to '')
| -rw-r--r-- | sc/source/ui/inc/datatransformation.hxx | 229 |
1 files changed, 229 insertions, 0 deletions
diff --git a/sc/source/ui/inc/datatransformation.hxx b/sc/source/ui/inc/datatransformation.hxx new file mode 100644 index 000000000..e69b21f42 --- /dev/null +++ b/sc/source/ui/inc/datatransformation.hxx @@ -0,0 +1,229 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + */ + +#pragma once + +#include <types.hxx> +#include <scdllapi.h> + +#include <sortparam.hxx> + +#include <set> + +class ScDocument; + +namespace sc { + +enum class TransformationType +{ + MERGE_TRANSFORMATION, + SPLIT_TRANSFORMATION, + DELETE_TRANSFORMATION, + SORT_TRANSFORMATION, + TEXT_TRANSFORMATION, + AGGREGATE_FUNCTION, + NUMBER_TRANSFORMATION, + REMOVE_NULL_TRANSFORMATION, + DATETIME_TRANSFORMATION, + FINDREPLACE_TRANSFORMATION, + DELETEROW_TRANSFORMATION, + SWAPROWS_TRANSFORMATION +}; + +enum class TEXT_TRANSFORM_TYPE { TO_LOWER, TO_UPPER, CAPITALIZE, TRIM }; + +enum class AGGREGATE_FUNCTION { SUM, AVERAGE, MIN, MAX }; + +enum class NUMBER_TRANSFORM_TYPE { ROUND, ROUND_UP, ROUND_DOWN, ABSOLUTE, LOG_E, LOG_10, CUBE, + SQUARE, SQUARE_ROOT, EXPONENT, IS_EVEN, IS_ODD, SIGN }; + +enum class DATETIME_TRANSFORMATION_TYPE { DATE_STRING, YEAR, START_OF_YEAR, END_OF_YEAR, MONTH, + MONTH_NAME, START_OF_MONTH, END_OF_MONTH, DAY, DAY_OF_WEEK, DAY_OF_YEAR, QUARTER, START_OF_QUARTER, + END_OF_QUARTER, TIME, HOUR, MINUTE, SECOND }; + +class SC_DLLPUBLIC DataTransformation +{ +protected: + + static SCROW getLastRow(const ScDocument& rDoc, SCCOL nCol); + +public: + virtual ~DataTransformation(); + + virtual void Transform(ScDocument& rDoc) const = 0; + + virtual TransformationType getTransformationType() const = 0; + +}; + +class SC_DLLPUBLIC ColumnRemoveTransformation : public DataTransformation +{ + std::set<SCCOL> maColumns; + +public: + + ColumnRemoveTransformation(std::set<SCCOL>&& rColumns); + virtual ~ColumnRemoveTransformation() override; + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + const std::set<SCCOL> & getColumns() const; +}; + +class SC_DLLPUBLIC SplitColumnTransformation : public DataTransformation +{ + SCCOL mnCol; + sal_Unicode mcSeparator; + +public: + + SplitColumnTransformation(SCCOL nCol, sal_Unicode cSeparator); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + SCCOL getColumn() const; + sal_Unicode getSeparator() const; +}; + +class SC_DLLPUBLIC MergeColumnTransformation : public DataTransformation +{ + std::set<SCCOL> maColumns; + OUString maMergeString; + +public: + + MergeColumnTransformation(std::set<SCCOL>&& rColumns, const OUString& rMergeString); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + const OUString & getMergeString() const; + const std::set<SCCOL> & getColumns() const; +}; + +class SortTransformation : public DataTransformation +{ + ScSortParam maSortParam; +public: + + SortTransformation(const ScSortParam& rParam); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + const ScSortParam & getSortParam() const; +}; + +class SC_DLLPUBLIC TextTransformation : public DataTransformation +{ + std::set<SCCOL> mnCol; + TEXT_TRANSFORM_TYPE maType; + + public: + TextTransformation(std::set<SCCOL>&& nCol, const TEXT_TRANSFORM_TYPE rType); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + TEXT_TRANSFORM_TYPE getTextTransformationType() const; + const std::set<SCCOL>& getColumns() const; +}; + +class SC_DLLPUBLIC AggregateFunction : public DataTransformation +{ + std::set<SCCOL> maColumns; + AGGREGATE_FUNCTION maType; + + public: + AggregateFunction(std::set<SCCOL>&& rColumns, const AGGREGATE_FUNCTION rType); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + AGGREGATE_FUNCTION getAggregateType() const; + const std::set<SCCOL>& getColumns() const; +}; + +class SC_DLLPUBLIC NumberTransformation : public DataTransformation +{ + std::set<SCCOL> mnCol; + NUMBER_TRANSFORM_TYPE maType; + int maPrecision; + + public: + NumberTransformation(std::set<SCCOL>&& nCol, const NUMBER_TRANSFORM_TYPE rType); + NumberTransformation(std::set<SCCOL>&& nCol, const NUMBER_TRANSFORM_TYPE rType, + int nPrecision); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + NUMBER_TRANSFORM_TYPE getNumberTransformationType() const; + int getPrecision() const; + const std::set<SCCOL>& getColumn() const; +}; + +class SC_DLLPUBLIC ReplaceNullTransformation : public DataTransformation +{ + std::set<SCCOL> mnCol; + OUString msReplaceWith; + + public: + ReplaceNullTransformation(std::set<SCCOL>&& nCol, const OUString& sReplaceWith); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + const std::set<SCCOL>& getColumn() const; + const OUString& getReplaceString() const; +}; + +class SC_DLLPUBLIC DateTimeTransformation : public DataTransformation +{ + std::set<SCCOL> mnCol; + DATETIME_TRANSFORMATION_TYPE maType; + + public: + DateTimeTransformation(std::set<SCCOL>&& nCol, + const DATETIME_TRANSFORMATION_TYPE rType); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + DATETIME_TRANSFORMATION_TYPE getDateTimeTransformationType() const; + const std::set<SCCOL>& getColumn() const; +}; + +class FindReplaceTransformation : public DataTransformation +{ + SCCOL mnCol; + OUString maFindString; + OUString maReplaceString; + + public: + FindReplaceTransformation(SCCOL nCol, const OUString& aFindString, const OUString& aReplaceString); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + SCCOL getColumn() const; + const OUString & getFindString() const; + const OUString & getReplaceString() const; +}; + +class DeleteRowTransformation : public DataTransformation +{ + SCCOL mnCol; + OUString maFindString; + + public: + DeleteRowTransformation(SCCOL nCol, const OUString& aFindString); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + SCCOL getColumn() const; + const OUString & getFindString() const; +}; + +class SwapRowsTransformation : public DataTransformation +{ + SCROW mxRow, nxRow; + + public: + SwapRowsTransformation(SCROW mRow, SCROW nRow); + virtual void Transform(ScDocument& rDoc) const override; + virtual TransformationType getTransformationType() const override; + SCROW getFirstRow() const; + SCROW getSecondRow() const; +}; + +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |