clickerconvert: src/xlsx/xlsxworkbook.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 "xlsxworkbook.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	26 #include "xlsxworkbook_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	27 #include "xlsxsharedstrings_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	28 #include "xlsxworksheet.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	29 #include "xlsxchartsheet.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	30 #include "xlsxstyles_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	31 #include "xlsxformat.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	32 #include "xlsxworksheet_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	33 #include "xlsxformat_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	34 #include "xlsxmediafile_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	35 #include "xlsxutility_p.h"
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 #include <QXmlStreamWriter>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	38 #include <QXmlStreamReader>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	39 #include <QFile>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	40 #include <QBuffer>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	41 #include <QDir>
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 QT_BEGIN_NAMESPACE_XLSX
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	44
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	45 WorkbookPrivate::WorkbookPrivate(Workbook *q, Workbook::CreateFlag flag) :
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	46 AbstractOOXmlFilePrivate(q, flag)
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 sharedStrings = QSharedPointer<SharedStrings> (new SharedStrings(flag));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	49 styles = QSharedPointer<Styles>(new Styles(flag));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	50 theme = QSharedPointer<Theme>(new Theme(flag));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	51
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	52 x_window = 240;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	53 y_window = 15;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	54 window_width = 16095;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	55 window_height = 9660;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	56
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	57 strings_to_numbers_enabled = false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	58 strings_to_hyperlinks_enabled = true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	59 html_to_richstring_enabled = false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	60 date1904 = false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	61 defaultDateFormat = QStringLiteral("yyyy-mm-dd");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	62 activesheetIndex = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	63 firstsheet = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	64 table_count = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	65
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	66 last_worksheet_index = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	67 last_chartsheet_index = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	68 last_sheet_id = 0;
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 Workbook::Workbook(CreateFlag flag)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	72 : AbstractOOXmlFile(new WorkbookPrivate(this, flag))
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	77 Workbook::~Workbook()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	78 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	79 }
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 bool Workbook::isDate1904() const
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 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	84 return d->date1904;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	87 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	88 Excel for Windows uses a default epoch of 1900 and Excel
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	89 for Mac uses an epoch of 1904. However, Excel on either
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	90 platform will convert automatically between one system
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	91 and the other. Qt Xlsx stores dates in the 1900 format
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	92 by default.
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 \note This function should be called before any date/time
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	95 has been written.
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 void Workbook::setDate1904(bool date1904)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	98 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	99 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	100 d->date1904 = date1904;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	103 /*
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	104 Enable the worksheet.write() method to convert strings
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	105 to numbers, where possible, using float() in order to avoid
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	106 an Excel warning about "Numbers Stored as Text".
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	107
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	108 The default is false
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	109 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	110 void Workbook::setStringsToNumbersEnabled(bool enable)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	111 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	112 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	113 d->strings_to_numbers_enabled = enable;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	114 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	115
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	116 bool Workbook::isStringsToNumbersEnabled() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	117 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	118 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	119 return d->strings_to_numbers_enabled;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	120 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	121
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	122 void Workbook::setStringsToHyperlinksEnabled(bool enable)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	123 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	124 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	125 d->strings_to_hyperlinks_enabled = enable;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	128 bool Workbook::isStringsToHyperlinksEnabled() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	129 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	130 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	131 return d->strings_to_hyperlinks_enabled;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	132 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	133
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	134 void Workbook::setHtmlToRichStringEnabled(bool enable)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	135 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	136 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	137 d->html_to_richstring_enabled = enable;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	138 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	139
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	140 bool Workbook::isHtmlToRichStringEnabled() const
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 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	143 return d->html_to_richstring_enabled;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	144 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	145
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	146 QString Workbook::defaultDateFormat() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	147 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	148 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	149 return d->defaultDateFormat;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	150 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	151
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	152 void Workbook::setDefaultDateFormat(const QString &format)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	153 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	154 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	155 d->defaultDateFormat = format;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	156 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	157
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 * \brief Create a defined name in the workbook.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	160 * \param name The defined name
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	161 * \param formula The cell or range that the defined name refers to.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	162 * \param comment
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	163 * \param scope The name of one worksheet, or empty which means golbal scope.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	164 * \return Return false if the name invalid.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	165 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	166 bool Workbook::defineName(const QString &name, const QString &formula, const QString &comment, const QString &scope)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	167 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	168 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	169
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	170 //Remove the = sign from the formula if it exists.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	171 QString formulaString = formula;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	172 if (formulaString.startsWith(QLatin1Char('=')))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	173 formulaString = formula.mid(1);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	174
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	175 int id=-1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	176 if (!scope.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	177 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	178 if (d->sheets[i]->sheetName() == scope) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	179 id = d->sheets[i]->sheetId();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	180 break;
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 d->definedNamesList.append(XlsxDefineNameData(name, formulaString, comment, id));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	186 return true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	187 }
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 AbstractSheet *Workbook::addSheet(const QString &name, AbstractSheet::SheetType type)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	190 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	191 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	192 return insertSheet(d->sheets.size(), name, type);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	193 }
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 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	196 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	197 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	198 QStringList Workbook::worksheetNames() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	199 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	200 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	201 return d->sheetNames;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	202 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	203
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	204 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	205 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	206 * Used only when load the xlsx file!!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	207 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	208 AbstractSheet *Workbook::addSheet(const QString &name, int sheetId, AbstractSheet::SheetType type)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	209 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	210 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	211 if (sheetId > d->last_sheet_id)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	212 d->last_sheet_id = sheetId;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	213 AbstractSheet *sheet=0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	214 if (type == AbstractSheet::ST_WorkSheet) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	215 sheet = new Worksheet(name, sheetId, this, F_LoadFromExists);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	216 } else if (type == AbstractSheet::ST_ChartSheet) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	217 sheet = new Chartsheet(name, sheetId, this, F_LoadFromExists);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	218 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	219 qWarning("unsupported sheet type.");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	220 Q_ASSERT(false);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	221 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	222 d->sheets.append(QSharedPointer<AbstractSheet>(sheet));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	223 d->sheetNames.append(name);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	224 return sheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	225 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	226
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	227 AbstractSheet *Workbook::insertSheet(int index, const QString &name, AbstractSheet::SheetType type)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	228 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	229 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	230 QString sheetName = createSafeSheetName(name);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	231 if (!sheetName.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	232 //If user given an already in-used name, we should not continue any more!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	233 if (d->sheetNames.contains(sheetName))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	234 return 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	235 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	236 if (type == AbstractSheet::ST_WorkSheet) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	237 do {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	238 ++d->last_worksheet_index;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	239 sheetName = QStringLiteral("Sheet%1").arg(d->last_worksheet_index);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	240 } while (d->sheetNames.contains(sheetName));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	241 } else if (type == AbstractSheet::ST_ChartSheet) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	242 do {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	243 ++d->last_chartsheet_index;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	244 sheetName = QStringLiteral("Chart%1").arg(d->last_chartsheet_index);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	245 } while (d->sheetNames.contains(sheetName));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	246 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	247 qWarning("unsupported sheet type.");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	248 return 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	249 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	250 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	251
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	252 ++d->last_sheet_id;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	253 AbstractSheet *sheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	254 if (type == AbstractSheet::ST_WorkSheet)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	255 sheet = new Worksheet(sheetName, d->last_sheet_id, this, F_NewFromScratch);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	256 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	257 sheet = new Chartsheet(sheetName, d->last_sheet_id, this, F_NewFromScratch);
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 d->sheets.insert(index, QSharedPointer<AbstractSheet>(sheet));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	260 d->sheetNames.insert(index, sheetName);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	261 d->activesheetIndex = index;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	262 return sheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	263 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	264
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	265 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	266 * Returns current active worksheet.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	267 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	268 AbstractSheet *Workbook::activeSheet() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	269 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	270 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	271 if (d->sheets.isEmpty())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	272 const_cast<Workbook*>(this)->addSheet();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	273 return d->sheets[d->activesheetIndex].data();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	274 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	275
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	276 bool Workbook::setActiveSheet(int index)
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 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	279 if (index < 0 \|\| index >= d->sheets.size()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	280 //warning
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	281 return false;
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 d->activesheetIndex = index;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	284 return true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	285 }
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 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	288 * Rename the worksheet at the \a index to \a newName.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	289 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	290 bool Workbook::renameSheet(int index, const QString &newName)
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 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	293 QString name = createSafeSheetName(newName);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	294 if (index < 0 \|\| index >= d->sheets.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	295 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	296
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	297 //If user given an already in-used name, return false
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	298 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	299 if (d->sheets[i]->sheetName() == name)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	300 return false;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	303 d->sheets[index]->setSheetName(name);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	304 d->sheetNames[index] = name;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	305 return true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	306 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	307
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	308 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	309 * Remove the worksheet at pos \a index.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	310 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	311 bool Workbook::deleteSheet(int index)
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 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	314 if (d->sheets.size() <= 1)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	315 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	316 if (index < 0 \|\| index >= d->sheets.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	317 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	318 d->sheets.removeAt(index);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	319 d->sheetNames.removeAt(index);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	320 return true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	321 }
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 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	324 * Moves the worksheet form \a srcIndex to \a distIndex.
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 bool Workbook::moveSheet(int srcIndex, int distIndex)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	327 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	328 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	329 if (srcIndex == distIndex)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	330 return false;
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 if (srcIndex < 0 \|\| srcIndex >= d->sheets.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	333 return false;
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 QSharedPointer<AbstractSheet> sheet = d->sheets.takeAt(srcIndex);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	336 d->sheetNames.takeAt(srcIndex);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	337 if (distIndex >= 0 \|\| distIndex <= d->sheets.size()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	338 d->sheets.insert(distIndex, sheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	339 d->sheetNames.insert(distIndex, sheet->sheetName());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	340 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	341 d->sheets.append(sheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	342 d->sheetNames.append(sheet->sheetName());
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 return true;
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 bool Workbook::copySheet(int index, const QString &newName)
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 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	350 if (index < 0 \|\| index >= d->sheets.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	351 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	352
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	353 QString worksheetName = createSafeSheetName(newName);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	354 if (!newName.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	355 //If user given an already in-used name, we should not continue any more!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	356 if (d->sheetNames.contains(newName))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	357 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	358 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	359 int copy_index = 1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	360 do {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	361 ++copy_index;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	362 worksheetName = QStringLiteral("%1(%2)").arg(d->sheets[index]->sheetName()).arg(copy_index);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	363 } while (d->sheetNames.contains(worksheetName));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	364 }
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 ++d->last_sheet_id;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	367 AbstractSheet *sheet = d->sheets[index]->copy(worksheetName, d->last_sheet_id);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	368 d->sheets.append(QSharedPointer<AbstractSheet> (sheet));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	369 d->sheetNames.append(sheet->sheetName());
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 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	372 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	373
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	374 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	375 * Returns count of worksheets.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	376 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	377 int Workbook::sheetCount() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	378 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	379 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	380 return d->sheets.count();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	381 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	382
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	383 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	384 * Returns the sheet object at index \a sheetIndex.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	385 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	386 AbstractSheet *Workbook::sheet(int index) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	387 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	388 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	389 if (index < 0 \|\| index >= d->sheets.size())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	390 return 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	391 return d->sheets.at(index).data();
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 SharedStrings *Workbook::sharedStrings() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	395 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	396 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	397 return d->sharedStrings.data();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	398 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	399
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	400 Styles *Workbook::styles()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	401 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	402 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	403 return d->styles.data();
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	406 Theme *Workbook::theme()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	407 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	408 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	409 return d->theme.data();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	410 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	411
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	412 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	413 * \internal
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 * Unlike media files, drawing file is a property of the sheet.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	416 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	417 QList<Drawing *> Workbook::drawings()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	418 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	419 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	420 QList<Drawing *> ds;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	421 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	422 QSharedPointer<AbstractSheet> sheet = d->sheets[i];
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	423 if (sheet->drawing())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	424 ds.append(sheet->drawing());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	425 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	426
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	427 return ds;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	430 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	431 * \internal
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 QList<QSharedPointer<AbstractSheet> > Workbook::getSheetsByTypes(AbstractSheet::SheetType type) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	434 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	435 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	436 QList<QSharedPointer<AbstractSheet> > list;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	437 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	438 if (d->sheets[i]->sheetType() == type)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	439 list.append(d->sheets[i]);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	440 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	441 return list;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	442 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	443
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	444 void Workbook::saveToXmlFile(QIODevice *device) const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	445 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	446 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	447 d->relationships->clear();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	448 if (d->sheets.isEmpty())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	449 const_cast<Workbook *>(this)->addSheet();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	450
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	451 QXmlStreamWriter writer(device);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	452
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	453 writer.writeStartDocument(QStringLiteral("1.0"), true);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	454 writer.writeStartElement(QStringLiteral("workbook"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	455 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	456 writer.writeAttribute(QStringLiteral("xmlns:r"), QStringLiteral("http://schemas.openxmlformats.org/officeDocument/2006/relationships"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	457
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	458 writer.writeEmptyElement(QStringLiteral("fileVersion"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	459 writer.writeAttribute(QStringLiteral("appName"), QStringLiteral("xl"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	460 writer.writeAttribute(QStringLiteral("lastEdited"), QStringLiteral("4"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	461 writer.writeAttribute(QStringLiteral("lowestEdited"), QStringLiteral("4"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	462 writer.writeAttribute(QStringLiteral("rupBuild"), QStringLiteral("4505"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	463 // writer.writeAttribute(QStringLiteral("codeName"), QStringLiteral("{37E998C4-C9E5-D4B9-71C8-EB1FF731991C}"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	464
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	465 writer.writeEmptyElement(QStringLiteral("workbookPr"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	466 if (d->date1904)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	467 writer.writeAttribute(QStringLiteral("date1904"), QStringLiteral("1"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	468 writer.writeAttribute(QStringLiteral("defaultThemeVersion"), QStringLiteral("124226"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	469
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	470 writer.writeStartElement(QStringLiteral("bookViews"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	471 writer.writeEmptyElement(QStringLiteral("workbookView"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	472 writer.writeAttribute(QStringLiteral("xWindow"), QString::number(d->x_window));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	473 writer.writeAttribute(QStringLiteral("yWindow"), QString::number(d->y_window));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	474 writer.writeAttribute(QStringLiteral("windowWidth"), QString::number(d->window_width));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	475 writer.writeAttribute(QStringLiteral("windowHeight"), QString::number(d->window_height));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	476 //Store the firstSheet when it isn't the default
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	477 //For example, when "the first sheet 0 is hidden", the first sheet will be 1
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	478 if (d->firstsheet > 0)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	479 writer.writeAttribute(QStringLiteral("firstSheet"), QString::number(d->firstsheet + 1));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	480 //Store the activeTab when it isn't the first sheet
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	481 if (d->activesheetIndex > 0)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	482 writer.writeAttribute(QStringLiteral("activeTab"), QString::number(d->activesheetIndex));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	483 writer.writeEndElement();//bookViews
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	484
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	485 writer.writeStartElement(QStringLiteral("sheets"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	486 int worksheetIndex = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	487 int chartsheetIndex = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	488 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	489 QSharedPointer<AbstractSheet> sheet = d->sheets[i];
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	490 writer.writeEmptyElement(QStringLiteral("sheet"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	491 writer.writeAttribute(QStringLiteral("name"), sheet->sheetName());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	492 writer.writeAttribute(QStringLiteral("sheetId"), QString::number(sheet->sheetId()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	493 if (sheet->sheetState() == AbstractSheet::SS_Hidden)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	494 writer.writeAttribute(QStringLiteral("state"), QStringLiteral("hidden"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	495 else if (sheet->sheetState() == AbstractSheet::SS_VeryHidden)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	496 writer.writeAttribute(QStringLiteral("state"), QStringLiteral("veryHidden"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	497
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	498 if (sheet->sheetType() == AbstractSheet::ST_WorkSheet)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	499 d->relationships->addDocumentRelationship(QStringLiteral("/worksheet"), QStringLiteral("worksheets/sheet%1.xml").arg(++worksheetIndex));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	500 else

1

93d3106bb9a4 Add qt xlsx library