1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192 |
- // xlsxvalidation.h
- #ifndef QXLSX_XLSXDATAVALIDATION_H
- #define QXLSX_XLSXDATAVALIDATION_H
- #include "xlsxglobal.h"
- #include <QList>
- #include <QSharedDataPointer>
- #include <QString>
- #include <QXmlStreamReader>
- #include <QXmlStreamWriter>
- class QXmlStreamReader;
- class QXmlStreamWriter;
- QT_BEGIN_NAMESPACE_XLSX
- class Worksheet;
- class CellRange;
- class CellReference;
- class DataValidationPrivate;
- class QXLSX_EXPORT DataValidation
- {
- public:
- enum ValidationType { None, Whole, Decimal, List, Date, Time, TextLength, Custom };
- enum ValidationOperator {
- Between,
- NotBetween,
- Equal,
- NotEqual,
- LessThan,
- LessThanOrEqual,
- GreaterThan,
- GreaterThanOrEqual
- };
- enum ErrorStyle { Stop, Warning, Information };
- DataValidation();
- DataValidation(ValidationType type,
- ValidationOperator op = Between,
- const QString &formula1 = QString(),
- const QString &formula2 = QString(),
- bool allowBlank = false);
- DataValidation(const DataValidation &other);
- ~DataValidation();
- ValidationType validationType() const;
- ValidationOperator validationOperator() const;
- ErrorStyle errorStyle() const;
- QString formula1() const;
- QString formula2() const;
- bool allowBlank() const;
- QString errorMessage() const;
- QString errorMessageTitle() const;
- QString promptMessage() const;
- QString promptMessageTitle() const;
- bool isPromptMessageVisible() const;
- bool isErrorMessageVisible() const;
- QList<CellRange> ranges() const;
- void setValidationType(ValidationType type);
- void setValidationOperator(ValidationOperator op);
- void setErrorStyle(ErrorStyle es);
- void setFormula1(const QString &formula);
- void setFormula2(const QString &formula);
- void setErrorMessage(const QString &error, const QString &title = QString());
- void setPromptMessage(const QString &prompt, const QString &title = QString());
- void setAllowBlank(bool enable);
- void setPromptMessageVisible(bool visible);
- void setErrorMessageVisible(bool visible);
- void addCell(const CellReference &cell);
- void addCell(int row, int col);
- void addRange(int firstRow, int firstCol, int lastRow, int lastCol);
- void addRange(const CellRange &range);
- DataValidation &operator=(const DataValidation &other);
- bool saveToXml(QXmlStreamWriter &writer) const;
- static DataValidation loadFromXml(QXmlStreamReader &reader);
- private:
- QSharedDataPointer<DataValidationPrivate> d;
- };
- QT_END_NAMESPACE_XLSX
- #endif // QXLSX_XLSXDATAVALIDATION_H
|