clickerconvert: src/xlsx/xlsxworkbook.cpp annotate

annotate src/xlsx/xlsxworkbook.cpp @ 18:4f679f613e91

Added tag 0.7 for changeset 44975d4eaed5

author	Andre Heinecke <andre.heinecke@intevation.de>
date	Tue, 22 Mar 2016 17:53:56 +0100
parents	93d3106bb9a4
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	501 d->relationships->addDocumentRelationship(QStringLiteral("/chartsheet"), QStringLiteral("chartsheets/sheet%1.xml").arg(++chartsheetIndex));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	502
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	503 writer.writeAttribute(QStringLiteral("r:id"), QStringLiteral("rId%1").arg(d->relationships->count()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	504 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	505 writer.writeEndElement();//sheets
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	506
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	507 if (d->externalLinks.size() > 0) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	508 writer.writeStartElement(QStringLiteral("externalReferences"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	509 for (int i=0; i<d->externalLinks.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	510 writer.writeEmptyElement(QStringLiteral("externalReference"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	511 d->relationships->addDocumentRelationship(QStringLiteral("/externalLink"), QStringLiteral("externalLinks/externalLink%1.xml").arg(i+1));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	512 writer.writeAttribute(QStringLiteral("r:id"), QStringLiteral("rId%1").arg(d->relationships->count()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	513 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	514 writer.writeEndElement();//externalReferences
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	515 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	516
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	517 if (!d->definedNamesList.isEmpty()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	518 writer.writeStartElement(QStringLiteral("definedNames"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	519 foreach (XlsxDefineNameData data, d->definedNamesList) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	520 writer.writeStartElement(QStringLiteral("definedName"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	521 writer.writeAttribute(QStringLiteral("name"), data.name);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	522 if (!data.comment.isEmpty())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	523 writer.writeAttribute(QStringLiteral("comment"), data.comment);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	524 if (data.sheetId != -1) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	525 //find the local index of the sheet.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	526 for (int i=0; i<d->sheets.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	527 if (d->sheets[i]->sheetId() == data.sheetId) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	528 writer.writeAttribute(QStringLiteral("localSheetId"), QString::number(i));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	529 break;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	530 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	531 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	532 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	533 writer.writeCharacters(data.formula);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	534 writer.writeEndElement();//definedName
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	535 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	536 writer.writeEndElement();//definedNames
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	537 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	538
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	539 writer.writeStartElement(QStringLiteral("calcPr"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	540 writer.writeAttribute(QStringLiteral("calcId"), QStringLiteral("124519"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	541 writer.writeEndElement(); //calcPr
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	542
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	543 writer.writeEndElement();//workbook
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	544 writer.writeEndDocument();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	545
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	546 d->relationships->addDocumentRelationship(QStringLiteral("/theme"), QStringLiteral("theme/theme1.xml"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	547 d->relationships->addDocumentRelationship(QStringLiteral("/styles"), QStringLiteral("styles.xml"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	548 if (!sharedStrings()->isEmpty())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	549 d->relationships->addDocumentRelationship(QStringLiteral("/sharedStrings"), QStringLiteral("sharedStrings.xml"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	550 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	551
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	552 bool Workbook::loadFromXmlFile(QIODevice *device)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	553 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	554 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	555
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	556 QXmlStreamReader reader(device);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	557 while (!reader.atEnd()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	558 QXmlStreamReader::TokenType token = reader.readNext();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	559 if (token == QXmlStreamReader::StartElement) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	560 if (reader.name() == QLatin1String("sheet")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	561 QXmlStreamAttributes attributes = reader.attributes();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	562 const QString name = attributes.value(QLatin1String("name")).toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	563 int sheetId = attributes.value(QLatin1String("sheetId")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	564 const QString rId = attributes.value(QLatin1String("r:id")).toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	565 const QStringRef &stateString = attributes.value(QLatin1String("state"));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	566 AbstractSheet::SheetState state = AbstractSheet::SS_Visible;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	567 if (stateString == QLatin1String("hidden"))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	568 state = AbstractSheet::SS_Hidden;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	569 else if (stateString == QLatin1String("veryHidden"))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	570 state = AbstractSheet::SS_VeryHidden;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	571
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	572 XlsxRelationship relationship = d->relationships->getRelationshipById(rId);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	573
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	574 AbstractSheet::SheetType type = AbstractSheet::ST_WorkSheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	575 if (relationship.type.endsWith(QLatin1String("/worksheet")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	576 type = AbstractSheet::ST_WorkSheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	577 else if (relationship.type.endsWith(QLatin1String("/chartsheet")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	578 type = AbstractSheet::ST_ChartSheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	579 else if (relationship.type.endsWith(QLatin1String("/dialogsheet")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	580 type = AbstractSheet::ST_DialogSheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	581 else if (relationship.type.endsWith(QLatin1String("/xlMacrosheet")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	582 type = AbstractSheet::ST_MacroSheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	583 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	584 qWarning("unknown sheet type");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	585
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	586 AbstractSheet *sheet = addSheet(name, sheetId, type);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	587 sheet->setSheetState(state);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	588 const QString fullPath = QDir::cleanPath(splitPath(filePath())[0] +QLatin1String("/")+ relationship.target);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	589 sheet->setFilePath(fullPath);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	590 } else if (reader.name() == QLatin1String("workbookPr")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	591 QXmlStreamAttributes attrs = reader.attributes();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	592 if (attrs.hasAttribute(QLatin1String("date1904")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	593 d->date1904 = true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	594 } else if (reader.name() == QLatin1String("bookviews")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	595 while (!(reader.name() == QLatin1String("bookviews") && reader.tokenType() == QXmlStreamReader::EndElement)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	596 reader.readNextStartElement();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	597 if (reader.tokenType() == QXmlStreamReader::StartElement) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	598 if (reader.name() == QLatin1String("workbookView")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	599 QXmlStreamAttributes attrs = reader.attributes();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	600 if (attrs.hasAttribute(QLatin1String("xWindow")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	601 d->x_window = attrs.value(QLatin1String("xWindow")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	602 if (attrs.hasAttribute(QLatin1String("yWindow")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	603 d->y_window = attrs.value(QLatin1String("yWindow")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	604 if (attrs.hasAttribute(QLatin1String("windowWidth")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	605 d->window_width = attrs.value(QLatin1String("windowWidth")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	606 if (attrs.hasAttribute(QLatin1String("windowHeight")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	607 d->window_height = attrs.value(QLatin1String("windowHeight")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	608 if (attrs.hasAttribute(QLatin1String("firstSheet")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	609 d->firstsheet = attrs.value(QLatin1String("firstSheet")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	610 if (attrs.hasAttribute(QLatin1String("activeTab")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	611 d->activesheetIndex = attrs.value(QLatin1String("activeTab")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	612 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	613 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	614 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	615 } else if (reader.name() == QLatin1String("externalReference")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	616 QXmlStreamAttributes attributes = reader.attributes();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	617 const QString rId = attributes.value(QLatin1String("r:id")).toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	618 XlsxRelationship relationship = d->relationships->getRelationshipById(rId);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	619
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	620 QSharedPointer<SimpleOOXmlFile> link(new SimpleOOXmlFile(F_LoadFromExists));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	621 const QString fullPath = QDir::cleanPath(splitPath(filePath())[0] +QLatin1String("/")+ relationship.target);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	622 link->setFilePath(fullPath);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	623 d->externalLinks.append(link);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	624 } else if (reader.name() == QLatin1String("definedName")) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	625 QXmlStreamAttributes attrs = reader.attributes();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	626 XlsxDefineNameData data;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	627
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	628 data.name = attrs.value(QLatin1String("name")).toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	629 if (attrs.hasAttribute(QLatin1String("comment")))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	630 data.comment = attrs.value(QLatin1String("comment")).toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	631 if (attrs.hasAttribute(QLatin1String("localSheetId"))) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	632 int localId = attrs.value(QLatin1String("localSheetId")).toString().toInt();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	633 int sheetId = d->sheets.at(localId)->sheetId();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	634 data.sheetId = sheetId;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	635 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	636 data.formula = reader.readElementText();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	637 d->definedNamesList.append(data);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	638 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	639 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	640 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	641 return true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	642 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	643
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	644 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	645 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	646 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	647 QList<QSharedPointer<MediaFile> > Workbook::mediaFiles() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	648 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	649 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	650
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	651 return d->mediaFiles;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	652 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	653
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	654 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	655 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	656 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	657 void Workbook::addMediaFile(QSharedPointer<MediaFile> media, bool force)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	658 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	659 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	660 if (!force) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	661 for (int i=0; i<d->mediaFiles.size(); ++i) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	662 if (d->mediaFiles[i]->hashKey() == media->hashKey()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	663 media->setIndex(i);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	664 return;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	665 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	666 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	667 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	668 media->setIndex(d->mediaFiles.size());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	669 d->mediaFiles.append(media);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	670 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	671
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	672 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	673 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	674 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	675 QList<QSharedPointer<Chart> > Workbook::chartFiles() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	676 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	677 Q_D(const Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	678
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	679 return d->chartFiles;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	680 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	681
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	682 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	683 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	684 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	685 void Workbook::addChartFile(QSharedPointer<Chart> chart)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	686 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	687 Q_D(Workbook);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	688
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	689 if (!d->chartFiles.contains(chart))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	690 d->chartFiles.append(chart);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	691 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	692
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	693 QT_END_NAMESPACE_XLSX

Mercurial > clickerconvert

annotate src/xlsx/xlsxworkbook.cpp @ 18:4f679f613e91