clickerconvert/clickerconvert: src/xlsx/xlsxstyles.cpp annotate

author	Andre Heinecke <andre.heinecke@intevation.de>
date	Tue, 22 Mar 2016 10:38:08 +0100
parents
children

rev	line source
1 93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	1 /****************************************************************************
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	2 ** Copyright (c) 2013-2014 Debao Zhang <hello@debao.me>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	3 ** All right reserved.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	4 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	5 ** Permission is hereby granted, free of charge, to any person obtaining
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	6 ** a copy of this software and associated documentation files (the
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	7 ** "Software"), to deal in the Software without restriction, including
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	8 ** without limitation the rights to use, copy, modify, merge, publish,
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	9 ** distribute, sublicense, and/or sell copies of the Software, and to
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	10 ** permit persons to whom the Software is furnished to do so, subject to
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	11 ** the following conditions:
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	12 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	13 ** The above copyright notice and this permission notice shall be
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	14 ** included in all copies or substantial portions of the Software.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	15 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	16 ** THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	17 ** EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	18 ** MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	19 ** NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	20 ** LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	21 ** OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	22 ** WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	23 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	24 ****************************************************************************/
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	25 #include "xlsxstyles_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	26 #include "xlsxformat_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	27 #include "xlsxutility_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	28 #include "xlsxcolor_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	29 #include <QXmlStreamWriter>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	30 #include <QXmlStreamReader>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	31 #include <QFile>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	32 #include <QMap>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	33 #include <QDataStream>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	34 #include <QDebug>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	35 #include <QBuffer>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	36
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	37 namespace QXlsx {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	38
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	39 /*
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	40 When loading from existing .xlsx file. we should create a clean styles object.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	41 otherwise, default formats should be added.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	42
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	43 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	44 Styles::Styles(CreateFlag flag)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	45 : AbstractOOXmlFile(flag), m_nextCustomNumFmtId(176), m_isIndexedColorsDefault(true)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	46 , m_emptyFormatAdded(false)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	47 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	48 //!Fix me. Should the custom num fmt Id starts with 164 or 176 or others??
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	49
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	50 //!Fix me! Where should we put these register code?
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	51 if (QMetaType::type("XlsxColor") == QMetaType::UnknownType) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	52 qRegisterMetaType<XlsxColor>("XlsxColor");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	53 qRegisterMetaTypeStreamOperators<XlsxColor>("XlsxColor");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	54 #if QT_VERSION >= 0x050200
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	55 QMetaType::registerDebugStreamOperator<XlsxColor>();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	56 #endif
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	57 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	58
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	59 if (flag == F_NewFromScratch) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	60 //Add default Format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	61 Format defaultFmt;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	62 addXfFormat(defaultFmt);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	63
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	64 //Add another fill format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	65 Format fillFmt;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	66 fillFmt.setFillPattern(Format::PatternGray125);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	67 m_fillsList.append(fillFmt);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	68 m_fillsHash.insert(fillFmt.fillKey(), fillFmt);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	69 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	70 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	71
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	72 Styles::~Styles()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	73 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	74 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	75
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	76 Format Styles::xfFormat(int idx) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	77 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	78 if (idx <0 \|\| idx >= m_xf_formatsList.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	79 return Format();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	80
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	81 return m_xf_formatsList[idx];
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	82 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	83
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	84 Format Styles::dxfFormat(int idx) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	85 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	86 if (idx <0 \|\| idx >= m_dxf_formatsList.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	87 return Format();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	88
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	89 return m_dxf_formatsList[idx];
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	90 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	91
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	92 void Styles::fixNumFmt(const Format &format)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	93 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	94 if (!format.hasNumFmtData())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	95 return;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	96
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	97 if (format.hasProperty(FormatPrivate::P_NumFmt_Id)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	98 && !format.stringProperty(FormatPrivate::P_NumFmt_FormatCode).isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	99 return;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	100 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	101
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	102 if (m_builtinNumFmtsHash.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	103 m_builtinNumFmtsHash.insert(QStringLiteral("General"), 0);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	104 m_builtinNumFmtsHash.insert(QStringLiteral("0"), 1);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	105 m_builtinNumFmtsHash.insert(QStringLiteral("0.00"), 2);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	106 m_builtinNumFmtsHash.insert(QStringLiteral("#,##0"), 3);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	107 m_builtinNumFmtsHash.insert(QStringLiteral("#,##0.00"), 4);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	108 // m_builtinNumFmtsHash.insert(QStringLiteral("($#,##0_);($#,##0)"), 5);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	109 // m_builtinNumFmtsHash.insert(QStringLiteral("($#,##0_);[Red]($#,##0)"), 6);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	110 // m_builtinNumFmtsHash.insert(QStringLiteral("($#,##0.00_);($#,##0.00)"), 7);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	111 // m_builtinNumFmtsHash.insert(QStringLiteral("($#,##0.00_);[Red]($#,##0.00)"), 8);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	112 m_builtinNumFmtsHash.insert(QStringLiteral("0%"), 9);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	113 m_builtinNumFmtsHash.insert(QStringLiteral("0.00%"), 10);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	114 m_builtinNumFmtsHash.insert(QStringLiteral("0.00E+00"), 11);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	115 m_builtinNumFmtsHash.insert(QStringLiteral("# ?/?"), 12);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	116 m_builtinNumFmtsHash.insert(QStringLiteral("# ?\?/??"), 13);// Note: "??/" is a c++ trigraph, so escape one "?"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	117 m_builtinNumFmtsHash.insert(QStringLiteral("m/d/yy"), 14);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	118 m_builtinNumFmtsHash.insert(QStringLiteral("d-mmm-yy"), 15);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	119 m_builtinNumFmtsHash.insert(QStringLiteral("d-mmm"), 16);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	120 m_builtinNumFmtsHash.insert(QStringLiteral("mmm-yy"), 17);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	121 m_builtinNumFmtsHash.insert(QStringLiteral("h:mm AM/PM"), 18);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	122 m_builtinNumFmtsHash.insert(QStringLiteral("h:mm:ss AM/PM"), 19);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	123 m_builtinNumFmtsHash.insert(QStringLiteral("h:mm"), 20);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	124 m_builtinNumFmtsHash.insert(QStringLiteral("h:mm:ss"), 21);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	125 m_builtinNumFmtsHash.insert(QStringLiteral("m/d/yy h:mm"), 22);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	126
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	127 m_builtinNumFmtsHash.insert(QStringLiteral("(#,##0_);(#,##0)"), 37);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	128 m_builtinNumFmtsHash.insert(QStringLiteral("(#,##0_);[Red](#,##0)"), 38);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	129 m_builtinNumFmtsHash.insert(QStringLiteral("(#,##0.00_);(#,##0.00)"), 39);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	130 m_builtinNumFmtsHash.insert(QStringLiteral("(#,##0.00_);[Red](#,##0.00)"), 40);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	131 // m_builtinNumFmtsHash.insert(QStringLiteral("_(* #,##0_);_(* (#,##0);_(* \"-\"_);_(_)"), 41);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	132 // m_builtinNumFmtsHash.insert(QStringLiteral("_($* #,##0_);_($* (#,##0);_($* \"-\"_);_(_)"), 42);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	133 // m_builtinNumFmtsHash.insert(QStringLiteral("_(* #,##0.00_);_(* (#,##0.00);_(* \"-\"??_);_(_)"), 43);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	134 // m_builtinNumFmtsHash.insert(QStringLiteral("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(_)"), 44);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	135 m_builtinNumFmtsHash.insert(QStringLiteral("mm:ss"), 45);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	136 m_builtinNumFmtsHash.insert(QStringLiteral("[h]:mm:ss"), 46);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	137 m_builtinNumFmtsHash.insert(QStringLiteral("mm:ss.0"), 47);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	138 m_builtinNumFmtsHash.insert(QStringLiteral("##0.0E+0"), 48);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	139 m_builtinNumFmtsHash.insert(QStringLiteral("@"), 49);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	140 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	141
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	142 const QString str = format.numberFormat();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	143 if (!str.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	144 //Assign proper number format index
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	145 if (m_builtinNumFmtsHash.contains(str)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	146 const_cast<Format *>(&format)->fixNumberFormat(m_builtinNumFmtsHash[str], str);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	147 } else if (m_customNumFmtsHash.contains(str)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	148 const_cast<Format *>(&format)->fixNumberFormat(m_customNumFmtsHash[str]->formatIndex, str);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	149 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	150 //Assign a new fmt Id.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	151 const_cast<Format *>(&format)->fixNumberFormat(m_nextCustomNumFmtId, str);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	152
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	153 QSharedPointer<XlsxFormatNumberData> fmt(new XlsxFormatNumberData);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	154 fmt->formatIndex = m_nextCustomNumFmtId;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	155 fmt->formatString = str;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	156 m_customNumFmtIdMap.insert(m_nextCustomNumFmtId, fmt);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	157 m_customNumFmtsHash.insert(str, fmt);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	158
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	159 m_nextCustomNumFmtId += 1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	160 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	161 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	162 int id = format.numberFormatIndex();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	163 //Assign proper format code, this is needed by dxf format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	164 if (m_customNumFmtIdMap.contains(id)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	165 const_cast<Format *>(&format)->fixNumberFormat(id, m_customNumFmtIdMap[id]->formatString);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	166 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	167 QHashIterator<QString, int> it(m_builtinNumFmtsHash);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	168 bool find=false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	169 while (it.hasNext()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	170 it.next();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	171 if (it.value() == id) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	172 const_cast<Format *>(&format)->fixNumberFormat(id, it.key());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	173 find = true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	174 break;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	175 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	176 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	177
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	178 if (!find) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	179 //Wrong numFmt
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	180 const_cast<Format *>(&format)->fixNumberFormat(id, QStringLiteral("General"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	181 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	182 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	183 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	184 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	185
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	186 /*
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	187 Assign index to Font/Fill/Border and Format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	188
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	189 When \a force is true, add the format to the format list, even other format has
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	190 the same key have been in.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	191 This is useful when reading existing .xlsx files which may contains duplicated formats.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	192 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	193 void Styles::addXfFormat(const Format &format, bool force)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	194 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	195 if (format.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	196 //Try do something for empty Format.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	197 if (m_emptyFormatAdded && !force)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	198 return;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	199 m_emptyFormatAdded = true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	200 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	201
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	202 //numFmt
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	203 if (format.hasNumFmtData() && !format.hasProperty(FormatPrivate::P_NumFmt_Id))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	204 fixNumFmt(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	205
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	206 //Font
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	207 if (format.hasFontData() && !format.fontIndexValid()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	208 //Assign proper font index, if has font data.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	209 if (!m_fontsHash.contains(format.fontKey()))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	210 const_cast<Format *>(&format)->setFontIndex(m_fontsList.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	211 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	212 const_cast<Format *>(&format)->setFontIndex(m_fontsHash[format.fontKey()].fontIndex());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	213 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	214 if (!m_fontsHash.contains(format.fontKey())) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	215 //Still a valid font if the format has no fontData. (All font properties are default)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	216 m_fontsList.append(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	217 m_fontsHash[format.fontKey()] = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	218 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	219
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	220 //Fill
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	221 if (format.hasFillData() && !format.fillIndexValid()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	222 //Assign proper fill index, if has fill data.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	223 if (!m_fillsHash.contains(format.fillKey()))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	224 const_cast<Format *>(&format)->setFillIndex(m_fillsList.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	225 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	226 const_cast<Format *>(&format)->setFillIndex(m_fillsHash[format.fillKey()].fillIndex());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	227 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	228 if (!m_fillsHash.contains(format.fillKey())) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	229 //Still a valid fill if the format has no fillData. (All fill properties are default)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	230 m_fillsList.append(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	231 m_fillsHash[format.fillKey()] = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	232 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	233
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	234 //Border
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	235 if (format.hasBorderData() && !format.borderIndexValid()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	236 //Assign proper border index, if has border data.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	237 if (!m_bordersHash.contains(format.borderKey()))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	238 const_cast<Format *>(&format)->setBorderIndex(m_bordersList.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	239 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	240 const_cast<Format *>(&format)->setBorderIndex(m_bordersHash[format.borderKey()].borderIndex());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	241 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	242 if (!m_bordersHash.contains(format.borderKey())) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	243 //Still a valid border if the format has no borderData. (All border properties are default)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	244 m_bordersList.append(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	245 m_bordersHash[format.borderKey()] = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	246 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	247
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	248 //Format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	249 if (!format.isEmpty() && !format.xfIndexValid()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	250 if (m_xf_formatsHash.contains(format.formatKey()))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	251 const_cast<Format *>(&format)->setXfIndex(m_xf_formatsHash[format.formatKey()].xfIndex());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	252 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	253 const_cast<Format *>(&format)->setXfIndex(m_xf_formatsList.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	254 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	255 if (!m_xf_formatsHash.contains(format.formatKey()) \|\| force) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	256 m_xf_formatsList.append(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	257 m_xf_formatsHash[format.formatKey()] = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	258 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	259 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	260
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	261 void Styles::addDxfFormat(const Format &format, bool force)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	262 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	263 //numFmt
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	264 if (format.hasNumFmtData())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	265 fixNumFmt(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	266
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	267 if (!format.isEmpty() && !format.dxfIndexValid()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	268 if (m_dxf_formatsHash.contains(format.formatKey()))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	269 const_cast<Format *>(&format)->setDxfIndex(m_dxf_formatsHash[format.formatKey()].dxfIndex());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	270 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	271 const_cast<Format *>(&format)->setDxfIndex(m_dxf_formatsList.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	272 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	273 if (!m_dxf_formatsHash.contains(format.formatKey()) \|\| force) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	274 m_dxf_formatsList.append(format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	275 m_dxf_formatsHash[format.formatKey()] = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	276 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	277 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	278
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	279 void Styles::saveToXmlFile(QIODevice *device) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	280 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	281 QXmlStreamWriter writer(device);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	282
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	283 writer.writeStartDocument(QStringLiteral("1.0"), true);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	284 writer.writeStartElement(QStringLiteral("styleSheet"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	285 writer.writeAttribute(QStringLiteral("xmlns"), QStringLiteral("http://schemas.openxmlformats.org/spreadsheetml/2006/main"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	286
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	287 writeNumFmts(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	288 writeFonts(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	289 writeFills(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	290 writeBorders(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	291
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	292 writer.writeStartElement(QStringLiteral("cellStyleXfs"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	293 writer.writeAttribute(QStringLiteral("count"), QStringLiteral("1"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	294 writer.writeStartElement(QStringLiteral("xf"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	295 writer.writeAttribute(QStringLiteral("numFmtId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	296 writer.writeAttribute(QStringLiteral("fontId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	297 writer.writeAttribute(QStringLiteral("fillId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	298 writer.writeAttribute(QStringLiteral("borderId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	299 writer.writeEndElement();//xf
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	300 writer.writeEndElement();//cellStyleXfs
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	301
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	302 writeCellXfs(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	303
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	304 writer.writeStartElement(QStringLiteral("cellStyles"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	305 writer.writeAttribute(QStringLiteral("count"), QStringLiteral("1"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	306 writer.writeStartElement(QStringLiteral("cellStyle"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	307 writer.writeAttribute(QStringLiteral("name"), QStringLiteral("Normal"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	308 writer.writeAttribute(QStringLiteral("xfId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	309 writer.writeAttribute(QStringLiteral("builtinId"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	310 writer.writeEndElement();//cellStyle
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	311 writer.writeEndElement();//cellStyles
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	312
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	313 writeDxfs(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	314
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	315 writer.writeStartElement(QStringLiteral("tableStyles"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	316 writer.writeAttribute(QStringLiteral("count"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	317 writer.writeAttribute(QStringLiteral("defaultTableStyle"), QStringLiteral("TableStyleMedium9"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	318 writer.writeAttribute(QStringLiteral("defaultPivotStyle"), QStringLiteral("PivotStyleLight16"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	319 writer.writeEndElement();//tableStyles
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	320
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	321 writeColors(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	322
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	323 writer.writeEndElement();//styleSheet
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	324 writer.writeEndDocument();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	325 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	326
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	327 void Styles::writeNumFmts(QXmlStreamWriter &writer) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	328 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	329 if (m_customNumFmtIdMap.size() == 0)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	330 return;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	331
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	332 writer.writeStartElement(QStringLiteral("numFmts"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	333 writer.writeAttribute(QStringLiteral("count"), QString::number(m_customNumFmtIdMap.count()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	334
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	335 QMapIterator<int, QSharedPointer<XlsxFormatNumberData> > it(m_customNumFmtIdMap);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	336 while (it.hasNext()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	337 it.next();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	338 writer.writeEmptyElement(QStringLiteral("numFmt"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	339 writer.writeAttribute(QStringLiteral("numFmtId"), QString::number(it.value()->formatIndex));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	340 writer.writeAttribute(QStringLiteral("formatCode"), it.value()->formatString);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	341 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	342 writer.writeEndElement();//numFmts
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	343 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	344
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	345 /*
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	346 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	347 void Styles::writeFonts(QXmlStreamWriter &writer) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	348 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	349 writer.writeStartElement(QStringLiteral("fonts"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	350 writer.writeAttribute(QStringLiteral("count"), QString::number(m_fontsList.count()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	351 for (int i=0; i<m_fontsList.size(); ++i)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	352 writeFont(writer, m_fontsList[i], false);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	353 writer.writeEndElement();//fonts
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	354 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	355
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	356 void Styles::writeFont(QXmlStreamWriter &writer, const Format &format, bool isDxf) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	357 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	358 writer.writeStartElement(QStringLiteral("font"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	359
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	360 //The condense and extend elements are mainly used in dxf format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	361 if (format.hasProperty(FormatPrivate::P_Font_Condense)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	362 && !format.boolProperty(FormatPrivate::P_Font_Condense)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	363 writer.writeEmptyElement(QStringLiteral("condense"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	364 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	365 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	366 if (format.hasProperty(FormatPrivate::P_Font_Extend)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	367 && !format.boolProperty(FormatPrivate::P_Font_Extend)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	368 writer.writeEmptyElement(QStringLiteral("extend"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	369 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("0"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	370 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	371
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	372 if (format.fontBold())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	373 writer.writeEmptyElement(QStringLiteral("b"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	374 if (format.fontItalic())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	375 writer.writeEmptyElement(QStringLiteral("i"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	376 if (format.fontStrikeOut())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	377 writer.writeEmptyElement(QStringLiteral("strike"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	378 if (format.fontOutline())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	379 writer.writeEmptyElement(QStringLiteral("outline"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	380 if (format.boolProperty(FormatPrivate::P_Font_Shadow))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	381 writer.writeEmptyElement(QStringLiteral("shadow"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	382 if (format.hasProperty(FormatPrivate::P_Font_Underline)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	383 Format::FontUnderline u = format.fontUnderline();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	384 if (u != Format::FontUnderlineNone) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	385 writer.writeEmptyElement(QStringLiteral("u"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	386 if (u== Format::FontUnderlineDouble)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	387 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("double"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	388 else if (u == Format::FontUnderlineSingleAccounting)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	389 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("singleAccounting"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	390 else if (u == Format::FontUnderlineDoubleAccounting)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	391 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("doubleAccounting"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	392 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	393 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	394 if (format.hasProperty(FormatPrivate::P_Font_Script)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	395 Format::FontScript s = format.fontScript();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	396 if (s != Format::FontScriptNormal) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	397 writer.writeEmptyElement(QStringLiteral("vertAlign"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	398 if (s == Format::FontScriptSuper)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	399 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("superscript"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	400 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	401 writer.writeAttribute(QStringLiteral("val"), QStringLiteral("subscript"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	402 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	403 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	404
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	405 if (!isDxf && format.hasProperty(FormatPrivate::P_Font_Size)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	406 writer.writeEmptyElement(QStringLiteral("sz"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	407 writer.writeAttribute(QStringLiteral("val"), QString::number(format.fontSize()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	408 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	409
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	410 if (format.hasProperty(FormatPrivate::P_Font_Color)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	411 XlsxColor color = format.property(FormatPrivate::P_Font_Color).value<XlsxColor>();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	412 color.saveToXml(writer);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	413 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	414
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	415 if (!isDxf) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	416 if (!format.fontName().isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	417 writer.writeEmptyElement(QStringLiteral("name"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	418 writer.writeAttribute(QStringLiteral("val"), format.fontName());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	419 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	420 if (format.hasProperty(FormatPrivate::P_Font_Charset)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	421 writer.writeEmptyElement(QStringLiteral("charset"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	422 writer.writeAttribute(QStringLiteral("val"), QString::number(format.intProperty(FormatPrivate::P_Font_Charset)));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	423 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	424 if (format.hasProperty(FormatPrivate::P_Font_Family)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	425 writer.writeEmptyElement(QStringLiteral("family"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	426 writer.writeAttribute(QStringLiteral("val"), QString::number(format.intProperty(FormatPrivate::P_Font_Family)));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	427 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	428
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	429 if (format.hasProperty(FormatPrivate::P_Font_Scheme)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	430 writer.writeEmptyElement(QStringLiteral("scheme"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	431 writer.writeAttribute(QStringLiteral("val"), format.stringProperty(FormatPrivate::P_Font_Scheme));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	432 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	433 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	434 writer.writeEndElement(); //font
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	435 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	436
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	437 void Styles::writeFills(QXmlStreamWriter &writer) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	438 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	439 writer.writeStartElement(QStringLiteral("fills"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	440 writer.writeAttribute(QStringLiteral("count"), QString::number(m_fillsList.size()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	441
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	442 for (int i=0; i<m_fillsList.size(); ++i)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	443 writeFill(writer, m_fillsList[i]);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	444
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	445 writer.writeEndElement(); //fills
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	446 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	447
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	448 void Styles::writeFill(QXmlStreamWriter &writer, const Format &fill, bool isDxf) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	449 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	450 static QMap<int, QString> patternStrings;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	451 if (patternStrings.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	452 patternStrings[Format::PatternNone] = QStringLiteral("none");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	453 patternStrings[Format::PatternSolid] = QStringLiteral("solid");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	454 patternStrings[Format::PatternMediumGray] = QStringLiteral("mediumGray");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	455 patternStrings[Format::PatternDarkGray] = QStringLiteral("darkGray");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	456 patternStrings[Format::PatternLightGray] = QStringLiteral("lightGray");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	457 patternStrings[Format::PatternDarkHorizontal] = QStringLiteral("darkHorizontal");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	458 patternStrings[Format::PatternDarkVertical] = QStringLiteral("darkVertical");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	459 patternStrings[Format::PatternDarkDown] = QStringLiteral("darkDown");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	460 patternStrings[Format::PatternDarkUp] = QStringLiteral("darkUp");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	461 patternStrings[Format::PatternDarkGrid] = QStringLiteral("darkGrid");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	462 patternStrings[Format::PatternDarkTrellis] = QStringLiteral("darkTrellis");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	463 patternStrings[Format::PatternLightHorizontal] = QStringLiteral("lightHorizontal");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	464 patternStrings[Format::PatternLightVertical] = QStringLiteral("lightVertical");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	465 patternStrings[Format::PatternLightDown] = QStringLiteral("lightDown");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	466 patternStrings[Format::PatternLightUp] = QStringLiteral("lightUp");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	467 patternStrings[Format::PatternLightTrellis] = QStringLiteral("lightTrellis");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	468 patternStrings[Format::PatternGray125] = QStringLiteral("gray125");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	469 patternStrings[Format::PatternGray0625] = QStringLiteral("gray0625");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	470 patternStrings[Format::PatternLightGrid] = QStringLiteral("lightGrid");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	471 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	472
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	473 writer.writeStartElement(QStringLiteral("fill"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	474 writer.writeStartElement(QStringLiteral("patternFill"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	475 Format::FillPattern pattern = fill.fillPattern();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	476 // For normal fill formats, Excel prefer to outputing the default "none" attribute
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	477 // But for dxf, Excel prefer to omiting the default "none"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	478 // Though not make any difference, but it make easier to compare origin files with generate files during debug
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	479 if (!(pattern == Format::PatternNone && isDxf))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	480 writer.writeAttribute(QStringLiteral("patternType"), patternStrings[pattern]);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	481 // For a solid fill, Excel reverses the role of foreground and background colours
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	482 if (fill.fillPattern() == Format::PatternSolid) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	483 if (fill.hasProperty(FormatPrivate::P_Fill_BgColor))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	484 fill.property(FormatPrivate::P_Fill_BgColor).value<XlsxColor>().saveToXml(writer, QStringLiteral("fgColor"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	485 if (fill.hasProperty(FormatPrivate::P_Fill_FgColor))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	486 fill.property(FormatPrivate::P_Fill_FgColor).value<XlsxColor>().saveToXml(writer, QStringLiteral("bgColor"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	487 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	488 if (fill.hasProperty(FormatPrivate::P_Fill_FgColor))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	489 fill.property(FormatPrivate::P_Fill_FgColor).value<XlsxColor>().saveToXml(writer, QStringLiteral("fgColor"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	490 if (fill.hasProperty(FormatPrivate::P_Fill_BgColor))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	491 fill.property(FormatPrivate::P_Fill_BgColor).value<XlsxColor>().saveToXml(writer, QStringLiteral("bgColor"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	492 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	493 writer.writeEndElement();//patternFill
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	494 writer.writeEndElement();//fill
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	495 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	496
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	497 void Styles::writeBorders(QXmlStreamWriter &writer) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	498 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	499 writer.writeStartElement(QStringLiteral("borders"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	500 writer.writeAttribute(QStringLiteral("count"), QString::number(m_bordersList.count()));

1

93d3106bb9a4 Add qt xlsx library