| 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
 
 
  |