xlsxformat.h 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. // xlsxformat.h
  2. #ifndef QXLSX_FORMAT_H
  3. #define QXLSX_FORMAT_H
  4. #include "xlsxglobal.h"
  5. #include <QByteArray>
  6. #include <QColor>
  7. #include <QExplicitlySharedDataPointer>
  8. #include <QFont>
  9. #include <QList>
  10. #include <QVariant>
  11. class FormatTest;
  12. QT_BEGIN_NAMESPACE_XLSX
  13. class Styles;
  14. class Worksheet;
  15. class WorksheetPrivate;
  16. class RichStringPrivate;
  17. class SharedStrings;
  18. class FormatPrivate;
  19. class QXLSX_EXPORT Format
  20. {
  21. public:
  22. enum FontScript { FontScriptNormal, FontScriptSuper, FontScriptSub };
  23. enum FontUnderline {
  24. FontUnderlineNone,
  25. FontUnderlineSingle,
  26. FontUnderlineDouble,
  27. FontUnderlineSingleAccounting,
  28. FontUnderlineDoubleAccounting
  29. };
  30. enum HorizontalAlignment {
  31. AlignHGeneral,
  32. AlignLeft,
  33. AlignHCenter,
  34. AlignRight,
  35. AlignHFill,
  36. AlignHJustify,
  37. AlignHMerge,
  38. AlignHDistributed
  39. };
  40. enum VerticalAlignment {
  41. AlignTop,
  42. AlignVCenter,
  43. AlignBottom,
  44. AlignVJustify,
  45. AlignVDistributed
  46. };
  47. enum BorderStyle {
  48. BorderNone,
  49. BorderThin,
  50. BorderMedium,
  51. BorderDashed,
  52. BorderDotted,
  53. BorderThick,
  54. BorderDouble,
  55. BorderHair,
  56. BorderMediumDashed,
  57. BorderDashDot,
  58. BorderMediumDashDot,
  59. BorderDashDotDot,
  60. BorderMediumDashDotDot,
  61. BorderSlantDashDot
  62. };
  63. enum DiagonalBorderType {
  64. DiagonalBorderNone,
  65. DiagonalBorderDown,
  66. DiagonalBorderUp,
  67. DiagnoalBorderBoth
  68. };
  69. enum FillPattern {
  70. PatternNone,
  71. PatternSolid,
  72. PatternMediumGray,
  73. PatternDarkGray,
  74. PatternLightGray,
  75. PatternDarkHorizontal,
  76. PatternDarkVertical,
  77. PatternDarkDown,
  78. PatternDarkUp,
  79. PatternDarkGrid,
  80. PatternDarkTrellis,
  81. PatternLightHorizontal,
  82. PatternLightVertical,
  83. PatternLightDown,
  84. PatternLightUp,
  85. PatternLightTrellis,
  86. PatternGray125,
  87. PatternGray0625,
  88. PatternLightGrid
  89. };
  90. Format();
  91. Format(const Format &other);
  92. Format &operator=(const Format &rhs);
  93. ~Format();
  94. int numberFormatIndex() const;
  95. void setNumberFormatIndex(int format);
  96. QString numberFormat() const;
  97. void setNumberFormat(const QString &format);
  98. void setNumberFormat(int id, const QString &format);
  99. bool isDateTimeFormat() const;
  100. int fontSize() const;
  101. void setFontSize(int size);
  102. bool fontItalic() const;
  103. void setFontItalic(bool italic);
  104. bool fontStrikeOut() const;
  105. void setFontStrikeOut(bool);
  106. QColor fontColor() const;
  107. void setFontColor(const QColor &);
  108. bool fontBold() const;
  109. void setFontBold(bool bold);
  110. FontScript fontScript() const;
  111. void setFontScript(FontScript);
  112. FontUnderline fontUnderline() const;
  113. void setFontUnderline(FontUnderline);
  114. bool fontOutline() const;
  115. void setFontOutline(bool outline);
  116. QString fontName() const;
  117. void setFontName(const QString &);
  118. QFont font() const;
  119. void setFont(const QFont &font);
  120. HorizontalAlignment horizontalAlignment() const;
  121. void setHorizontalAlignment(HorizontalAlignment align);
  122. VerticalAlignment verticalAlignment() const;
  123. void setVerticalAlignment(VerticalAlignment align);
  124. bool textWrap() const;
  125. void setTextWrap(bool textWrap);
  126. int rotation() const;
  127. void setRotation(int rotation);
  128. int indent() const;
  129. void setIndent(int indent);
  130. bool shrinkToFit() const;
  131. void setShrinkToFit(bool shink);
  132. void setBorderStyle(BorderStyle style);
  133. void setBorderColor(const QColor &color);
  134. BorderStyle leftBorderStyle() const;
  135. void setLeftBorderStyle(BorderStyle style);
  136. QColor leftBorderColor() const;
  137. void setLeftBorderColor(const QColor &color);
  138. BorderStyle rightBorderStyle() const;
  139. void setRightBorderStyle(BorderStyle style);
  140. QColor rightBorderColor() const;
  141. void setRightBorderColor(const QColor &color);
  142. BorderStyle topBorderStyle() const;
  143. void setTopBorderStyle(BorderStyle style);
  144. QColor topBorderColor() const;
  145. void setTopBorderColor(const QColor &color);
  146. BorderStyle bottomBorderStyle() const;
  147. void setBottomBorderStyle(BorderStyle style);
  148. QColor bottomBorderColor() const;
  149. void setBottomBorderColor(const QColor &color);
  150. BorderStyle diagonalBorderStyle() const;
  151. void setDiagonalBorderStyle(BorderStyle style);
  152. DiagonalBorderType diagonalBorderType() const;
  153. void setDiagonalBorderType(DiagonalBorderType style);
  154. QColor diagonalBorderColor() const;
  155. void setDiagonalBorderColor(const QColor &color);
  156. FillPattern fillPattern() const;
  157. void setFillPattern(FillPattern pattern);
  158. QColor patternForegroundColor() const;
  159. void setPatternForegroundColor(const QColor &color);
  160. QColor patternBackgroundColor() const;
  161. void setPatternBackgroundColor(const QColor &color);
  162. bool locked() const;
  163. void setLocked(bool locked);
  164. bool hidden() const;
  165. void setHidden(bool hidden);
  166. void mergeFormat(const Format &modifier);
  167. bool isValid() const;
  168. bool isEmpty() const;
  169. bool operator==(const Format &format) const;
  170. bool operator!=(const Format &format) const;
  171. QVariant property(int propertyId, const QVariant &defaultValue = QVariant()) const;
  172. void setProperty(int propertyId,
  173. const QVariant &value,
  174. const QVariant &clearValue = QVariant(),
  175. bool detach = true);
  176. void clearProperty(int propertyId);
  177. bool hasProperty(int propertyId) const;
  178. bool boolProperty(int propertyId, bool defaultValue = false) const;
  179. int intProperty(int propertyId, int defaultValue = 0) const;
  180. double doubleProperty(int propertyId, double defaultValue = 0.0) const;
  181. QString stringProperty(int propertyId, const QString &defaultValue = QString()) const;
  182. QColor colorProperty(int propertyId, const QColor &defaultValue = QColor()) const;
  183. bool hasNumFmtData() const;
  184. bool hasFontData() const;
  185. bool hasFillData() const;
  186. bool hasBorderData() const;
  187. bool hasAlignmentData() const;
  188. bool hasProtectionData() const;
  189. bool fontIndexValid() const;
  190. int fontIndex() const;
  191. QByteArray fontKey() const;
  192. bool borderIndexValid() const;
  193. QByteArray borderKey() const;
  194. int borderIndex() const;
  195. bool fillIndexValid() const;
  196. QByteArray fillKey() const;
  197. int fillIndex() const;
  198. QByteArray formatKey() const;
  199. bool xfIndexValid() const;
  200. int xfIndex() const;
  201. bool dxfIndexValid() const;
  202. int dxfIndex() const;
  203. void fixNumberFormat(int id, const QString &format);
  204. void setFontIndex(int index);
  205. void setBorderIndex(int index);
  206. void setFillIndex(int index);
  207. void setXfIndex(int index);
  208. void setDxfIndex(int index);
  209. private:
  210. friend class Styles;
  211. friend class ::FormatTest;
  212. friend QDebug operator<<(QDebug, const Format &f);
  213. int theme() const;
  214. QExplicitlySharedDataPointer<FormatPrivate> d;
  215. };
  216. #ifndef QT_NO_DEBUG_STREAM
  217. QDebug operator<<(QDebug dbg, const Format &f);
  218. #endif
  219. QT_END_NAMESPACE_XLSX
  220. #endif // QXLSX_FORMAT_H