clickerconvert: src/xlsx/xlsxworksheet.cpp annotate

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

rev	line source
1 93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	1 /****************************************************************************
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	2 ** Copyright (c) 2013-2014 Debao Zhang <hello@debao.me>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	3 ** All right reserved.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	4 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	5 ** Permission is hereby granted, free of charge, to any person obtaining
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	6 ** a copy of this software and associated documentation files (the
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	7 ** "Software"), to deal in the Software without restriction, including
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	8 ** without limitation the rights to use, copy, modify, merge, publish,
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	9 ** distribute, sublicense, and/or sell copies of the Software, and to
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	10 ** permit persons to whom the Software is furnished to do so, subject to
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	11 ** the following conditions:
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	12 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	13 ** The above copyright notice and this permission notice shall be
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	14 ** included in all copies or substantial portions of the Software.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	15 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	16 ** THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	17 ** EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	18 ** MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	19 ** NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	20 ** LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	21 ** OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	22 ** WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	23 **
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	24 ****************************************************************************/
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	25 #include "xlsxrichstring.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	26 #include "xlsxcellreference.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	27 #include "xlsxworksheet.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	28 #include "xlsxworksheet_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	29 #include "xlsxworkbook.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	30 #include "xlsxformat.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	31 #include "xlsxformat_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	32 #include "xlsxutility_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	33 #include "xlsxsharedstrings_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	34 #include "xlsxdrawing_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	35 #include "xlsxstyles_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	36 #include "xlsxcell.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	37 #include "xlsxcell_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	38 #include "xlsxcellrange.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	39 #include "xlsxconditionalformatting_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	40 #include "xlsxdrawinganchor_p.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	41 #include "xlsxchart.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	42 #include "xlsxcellformula.h"
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	43 #include "xlsxcellformula_p.h"
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 #include <QVariant>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	46 #include <QDateTime>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	47 #include <QPoint>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	48 #include <QFile>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	49 #include <QUrl>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	50 #include <QRegularExpression>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	51 #include <QDebug>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	52 #include <QBuffer>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	53 #include <QXmlStreamWriter>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	54 #include <QXmlStreamReader>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	55 #include <QTextDocument>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	56 #include <QDir>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	57
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	58 #include <math.h>
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	59
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	60 QT_BEGIN_NAMESPACE_XLSX
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	61
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	62 WorksheetPrivate::WorksheetPrivate(Worksheet *p, Worksheet::CreateFlag flag)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	63 : AbstractSheetPrivate(p, flag)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	64 , windowProtection(false), showFormulas(false), showGridLines(true), showRowColHeaders(true)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	65 , showZeros(true), rightToLeft(false), tabSelected(false), showRuler(false)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	66 , showOutlineSymbols(true), showWhiteSpace(true), urlPattern(QStringLiteral("^([fh]tt?ps?://)\|(mailto:)\|(file://)"))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	67 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	68 previous_row = 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 outline_row_level = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	71 outline_col_level = 0;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	72
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	73 default_row_height = 15;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	74 default_row_zeroed = false;
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 WorksheetPrivate::~WorksheetPrivate()
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 /*
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	82 Calculate the "spans" attribute of the <row> tag. This is an
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	83 XLSX optimisation and isn't strictly required. However, it
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	84 makes comparing files easier. The span is the same for each
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	85 block of 16 rows.
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 void WorksheetPrivate::calculateSpans() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	88 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	89 row_spans.clear();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	90 int span_min = XLSX_COLUMN_MAX+1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	91 int span_max = -1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	92
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	93 for (int row_num = dimension.firstRow(); row_num <= dimension.lastRow(); row_num++) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	94 if (cellTable.contains(row_num)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	95 for (int col_num = dimension.firstColumn(); col_num <= dimension.lastColumn(); col_num++) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	96 if (cellTable[row_num].contains(col_num)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	97 if (span_max == -1) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	98 span_min = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	99 span_max = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	100 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	101 if (col_num < span_min)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	102 span_min = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	103 else if (col_num > span_max)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	104 span_max = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	105 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	106 }
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 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	109 if (comments.contains(row_num)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	110 for (int col_num = dimension.firstColumn(); col_num <= dimension.lastColumn(); col_num++) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	111 if (comments[row_num].contains(col_num)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	112 if (span_max == -1) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	113 span_min = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	114 span_max = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	115 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	116 if (col_num < span_min)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	117 span_min = col_num;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	118 else if (col_num > span_max)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	119 span_max = col_num;
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 }
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	125 if (row_num%16 == 0 \|\| row_num == dimension.lastRow()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	126 if (span_max != -1) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	127 row_spans[row_num / 16] = QStringLiteral("%1:%2").arg(span_min).arg(span_max);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	128 span_min = XLSX_COLUMN_MAX+1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	129 span_max = -1;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	130 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	131 }
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
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 QString WorksheetPrivate::generateDimensionString() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	137 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	138 if (!dimension.isValid())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	139 return QStringLiteral("A1");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	140 else
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	141 return dimension.toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	142 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	143
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 Check that row and col are valid and store the max and min
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	146 values for use in other methods/elements. The ignore_row /
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	147 ignore_col flags is used to indicate that we wish to perform
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	148 the dimension check without storing the value. The ignore
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	149 flags are use by setRow() and dataValidate.
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 int WorksheetPrivate::checkDimensions(int row, int col, bool ignore_row, bool ignore_col)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	152 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	153 Q_ASSERT_X(row!=0, "checkDimensions", "row should start from 1 instead of 0");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	154 Q_ASSERT_X(col!=0, "checkDimensions", "column should start from 1 instead of 0");
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	155
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	156 if (row > XLSX_ROW_MAX \|\| row < 1 \|\| col > XLSX_COLUMN_MAX \|\| col < 1)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	157 return -1;
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 if (!ignore_row) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	160 if (row < dimension.firstRow() \|\| dimension.firstRow() == -1) dimension.setFirstRow(row);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	161 if (row > dimension.lastRow()) dimension.setLastRow(row);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	162 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	163 if (!ignore_col) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	164 if (col < dimension.firstColumn() \|\| dimension.firstColumn() == -1) dimension.setFirstColumn(col);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	165 if (col > dimension.lastColumn()) dimension.setLastColumn(col);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	166 }
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 return 0;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	171 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	172 \class Worksheet
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	173 \inmodule QtXlsx
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	174 \brief Represent one worksheet in the workbook.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	175 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	176
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	177 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	178 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	179 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	180 Worksheet::Worksheet(const QString &name, int id, Workbook *workbook, CreateFlag flag)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	181 :AbstractSheet(name, id, workbook, new WorksheetPrivate(this, flag))
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 if (!workbook) //For unit test propose only. Ignore the memery leak.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	184 d_func()->workbook = new Workbook(flag);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	185 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	186
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	187 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	188 * \internal
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	189 *
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	190 * Make a copy of this sheet.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	191 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	192
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	193 Worksheet *Worksheet::copy(const QString &distName, int distId) const
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 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	196 Worksheet *sheet = new Worksheet(distName, distId, d->workbook, F_NewFromScratch);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	197 WorksheetPrivate *sheet_d = sheet->d_func();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	198
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	199 sheet_d->dimension = d->dimension;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	200
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	201 QMapIterator<int, QMap<int, QSharedPointer<Cell> > > it(d->cellTable);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	202 while (it.hasNext()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	203 it.next();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	204 int row = it.key();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	205 QMapIterator<int, QSharedPointer<Cell> > it2(it.value());
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	206 while (it2.hasNext()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	207 it2.next();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	208 int col = it2.key();
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 QSharedPointer<Cell> cell(new Cell(it2.value().data()));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	211 cell->d_ptr->parent = sheet;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	212
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	213 if (cell->cellType() == Cell::SharedStringType)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	214 d->workbook->sharedStrings()->addSharedString(cell->d_ptr->richString);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	215
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	216 sheet_d->cellTable[row][col] = cell;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	217 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	218 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	219
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	220 sheet_d->merges = d->merges;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	221 // sheet_d->rowsInfo = d->rowsInfo;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	222 // sheet_d->colsInfo = d->colsInfo;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	223 // sheet_d->colsInfoHelper = d->colsInfoHelper;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	224 // sheet_d->dataValidationsList = d->dataValidationsList;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	225 // sheet_d->conditionalFormattingList = d->conditionalFormattingList;
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 return sheet;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	230 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	231 * Destroys this workssheet.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	232 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	233 Worksheet::~Worksheet()
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	234 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	235 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	236
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	237 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	238 * Returns whether sheet is protected.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	239 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	240 bool Worksheet::isWindowProtected() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	241 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	242 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	243 return d->windowProtection;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	244 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	245
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	246 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	247 * Protects/unprotects the sheet based on \a protect.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	248 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	249 void Worksheet::setWindowProtected(bool protect)
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 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	252 d->windowProtection = protect;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	253 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	254
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	255 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	256 * Return whether formulas instead of their calculated results shown in cells
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	257 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	258 bool Worksheet::isFormulasVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	259 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	260 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	261 return d->showFormulas;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	262 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	263
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 * Show formulas in cells instead of their calculated results when \a visible is true.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	266 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	267 void Worksheet::setFormulasVisible(bool visible)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	268 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	269 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	270 d->showFormulas = visible;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	271 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	272
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	273 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	274 * Return whether gridlines is shown or not.
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 Worksheet::isGridLinesVisible() const
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(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	279 return d->showGridLines;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	280 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	281
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 * Show or hide the gridline based on \a visible
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	284 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	285 void Worksheet::setGridLinesVisible(bool visible)
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 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	288 d->showGridLines = visible;
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
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 * Return whether is row and column headers is vislbe.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	293 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	294 bool Worksheet::isRowColumnHeadersVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	295 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	296 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	297 return d->showRowColHeaders;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	298 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	299
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	300 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	301 * Show or hide the row column headers based on \a visible
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 void Worksheet::setRowColumnHeadersVisible(bool visible)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	304 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	305 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	306 d->showRowColHeaders = visible;
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
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 * Return whether the sheet is shown right-to-left or not.
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 bool Worksheet::isRightToLeft() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	314 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	315 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	316 return d->rightToLeft;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	317 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	318
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	319 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	320 * Enable or disable the right-to-left based on \a enable.
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 void Worksheet::setRightToLeft(bool enable)
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 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	325 d->rightToLeft = enable;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	326 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	327
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	328 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	329 * Return whether is cells that have zero value show a zero.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	330 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	331 bool Worksheet::isZerosVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	332 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	333 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	334 return d->showZeros;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	335 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	336
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	337 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	338 * Show a zero in cells that have zero value if \a visible is true.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	339 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	340 void Worksheet::setZerosVisible(bool visible)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	341 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	342 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	343 d->showZeros = visible;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	344 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	345
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	346 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	347 * Return whether this tab is selected.
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 bool Worksheet::isSelected() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	350 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	351 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	352 return d->tabSelected;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	353 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	354
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	355 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	356 * Select this sheet if \a select is true.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	357 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	358 void Worksheet::setSelected(bool select)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	359 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	360 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	361 d->tabSelected = select;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	362 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	363
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 * Return whether is ruler is shown.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	366 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	367 bool Worksheet::isRulerVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	368 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	369 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	370 return d->showRuler;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	371
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	372 }
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 * Show or hide the ruler based on \a visible.
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 void Worksheet::setRulerVisible(bool visible)
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(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	380 d->showRuler = visible;
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 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	385 * Return whether is outline symbols is shown.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	386 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	387 bool Worksheet::isOutlineSymbolsVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	388 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	389 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	390 return d->showOutlineSymbols;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	391 }
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 * Show or hide the outline symbols based ib \a visible.
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 void Worksheet::setOutlineSymbolsVisible(bool visible)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	397 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	398 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	399 d->showOutlineSymbols = visible;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	400 }
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 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	403 * Return whether is white space is shown.
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 bool Worksheet::isWhiteSpaceVisible() const
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	406 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	407 Q_D(const Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	408 return d->showWhiteSpace;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	409 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	410
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 * Show or hide the white space based on \a visible.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	413 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	414 void Worksheet::setWhiteSpaceVisible(bool visible)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	415 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	416 Q_D(Worksheet);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	417 d->showWhiteSpace = visible;
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
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	420 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	421 * Write \a value to cell (\a row, \a column) with the \a format.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	422 * Both \a row and \a column are all 1-indexed value.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	423 *
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	424 * Returns true on success.
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 bool Worksheet::write(int row, int column, const QVariant &value, const Format &format)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	427 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	428 Q_D(Worksheet);
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 if (d->checkDimensions(row, column))
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	431 return false;
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 bool ret = true;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	434 if (value.isNull()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	435 //Blank
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	436 ret = writeBlank(row, column, format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	437 } else if (value.userType() == QMetaType::QString) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	438 //String
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	439 QString token = value.toString();
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	440 bool ok;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	441
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	442 if (token.startsWith(QLatin1String("="))) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	443 //convert to formula
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	444 ret = writeFormula(row, column, CellFormula(token), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	445 } else if (d->workbook->isStringsToHyperlinksEnabled() && token.contains(d->urlPattern)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	446 //convert to url
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	447 ret = writeHyperlink(row, column, QUrl(token));
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	448 } else if (d->workbook->isStringsToNumbersEnabled() && (value.toDouble(&ok), ok)) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	449 //Try convert string to number if the flag enabled.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	450 ret = writeString(row, column, value.toString(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	451 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	452 //normal string now
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	453 ret = writeString(row, column, token, format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	454 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	455 } else if (value.userType() == qMetaTypeId<RichString>()) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	456 ret = writeString(row, column, value.value<RichString>(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	457 } else if (value.userType() == QMetaType::Int \|\| value.userType() == QMetaType::UInt
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	458 \|\| value.userType() == QMetaType::LongLong \|\| value.userType() == QMetaType::ULongLong
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	459 \|\| value.userType() == QMetaType::Double \|\| value.userType() == QMetaType::Float) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	460 //Number
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	461
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	462 ret = writeNumeric(row, column, value.toDouble(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	463 } else if (value.userType() == QMetaType::Bool) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	464 //Bool
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	465 ret = writeBool(row,column, value.toBool(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	466 } else if (value.userType() == QMetaType::QDateTime \|\| value.userType() == QMetaType::QDate) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	467 //DateTime, Date
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	468 // note that, QTime cann't convert to QDateTime
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	469 ret = writeDateTime(row, column, value.toDateTime(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	470 } else if (value.userType() == QMetaType::QTime) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	471 //Time
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	472 ret = writeTime(row, column, value.toTime(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	473 } else if (value.userType() == QMetaType::QUrl) {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	474 //Url
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	475 ret = writeHyperlink(row, column, value.toUrl(), format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	476 } else {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	477 //Wrong type
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	478 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	479 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	480
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	481 return ret;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	482 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	483
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 * \overload
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	486 * Write \a value to cell \a row_column with the \a format.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	487 * Both row and column are all 1-indexed value.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	488 * Returns true on success.
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	489 */
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	490 bool Worksheet::write(const CellReference &row_column, const QVariant &value, const Format &format)
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	491 {
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	492 if (!row_column.isValid())
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	493 return false;
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	494
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	495 return write(row_column.row(), row_column.column(), value, format);
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	496 }
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	497
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	498 /*!
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	499 \overload
93d3106bb9a4 Add qt xlsx library Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	500 Return the contents of the cell \a row_column.

1

93d3106bb9a4 Add qt xlsx library