// xlsxvalidation.h #ifndef QXLSX_XLSXDATAVALIDATION_H #define QXLSX_XLSXDATAVALIDATION_H #include #include #include #include #include #include #include "xlsxglobal.h" class QXmlStreamReader; class QXmlStreamWriter; QT_BEGIN_NAMESPACE_XLSX class Worksheet; class CellRange; class CellReference; class DataValidationPrivate; class 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 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 d; }; QT_END_NAMESPACE_XLSX #endif // QXLSX_XLSXDATAVALIDATION_H