// xlsxworksheet_p.h
|
|
#ifndef XLSXWORKSHEET_P_H
|
#define XLSXWORKSHEET_P_H
|
|
#include <QtGlobal>
|
#include <QObject>
|
#include <QString>
|
#include <QVector>
|
#include <QImage>
|
#include <QSharedPointer>
|
|
#include <QRegularExpression>
|
|
#include "xlsxworksheet.h"
|
#include "xlsxabstractsheet_p.h"
|
#include "xlsxcell.h"
|
#include "xlsxdatavalidation.h"
|
#include "xlsxconditionalformatting.h"
|
#include "xlsxcellformula.h"
|
|
class QXmlStreamWriter;
|
class QXmlStreamReader;
|
|
QT_BEGIN_NAMESPACE_XLSX
|
|
const int XLSX_ROW_MAX = 1048576;
|
const int XLSX_COLUMN_MAX = 16384;
|
const int XLSX_STRING_MAX = 32767;
|
|
class SharedStrings;
|
|
struct XlsxHyperlinkData
|
{
|
enum LinkType
|
{
|
External,
|
Internal
|
};
|
|
XlsxHyperlinkData(LinkType linkType=External, const QString &target=QString(), const QString &location=QString()
|
, const QString &display=QString(), const QString &tip=QString())
|
:linkType(linkType), target(target), location(location), display(display), tooltip(tip)
|
{
|
|
}
|
|
LinkType linkType;
|
QString target; //For External link
|
QString location;
|
QString display;
|
QString tooltip;
|
};
|
|
// ECMA-376 Part1 18.3.1.81
|
struct XlsxSheetFormatProps
|
{
|
XlsxSheetFormatProps(int baseColWidth = 8,
|
bool customHeight = false,
|
double defaultColWidth = 8.430f, // https://learn.microsoft.com/en-us/office/troubleshoot/excel/determine-column-widths
|
double defaultRowHeight = 15,
|
quint8 outlineLevelCol = 0,
|
quint8 outlineLevelRow = 0,
|
bool thickBottom = false,
|
bool thickTop = false,
|
bool zeroHeight = false) :
|
baseColWidth(baseColWidth),
|
customHeight(customHeight),
|
defaultColWidth(defaultColWidth),
|
defaultRowHeight(defaultRowHeight),
|
outlineLevelCol(outlineLevelCol),
|
outlineLevelRow(outlineLevelRow),
|
thickBottom(thickBottom),
|
thickTop(thickTop),
|
zeroHeight(zeroHeight) {
|
}
|
|
int baseColWidth;
|
bool customHeight;
|
double defaultColWidth;
|
double defaultRowHeight;
|
quint8 outlineLevelCol;
|
quint8 outlineLevelRow;
|
bool thickBottom;
|
bool thickTop;
|
bool zeroHeight;
|
};
|
|
struct XlsxRowInfo
|
{
|
XlsxRowInfo(double height=0, const Format &format=Format(), bool hidden=false) :
|
customHeight(false), height(height), format(format), hidden(hidden), outlineLevel(0)
|
, collapsed(false)
|
{
|
|
}
|
|
bool customHeight;
|
double height;
|
Format format;
|
bool hidden;
|
int outlineLevel;
|
bool collapsed;
|
};
|
|
struct XlsxColumnInfo
|
{
|
XlsxColumnInfo( int firstColumn, // = 0,
|
int lastColumn, // = 1,
|
bool isSetWidth,
|
double width = 0,
|
const Format &format = Format(),
|
bool hidden = false)
|
: width(width),
|
format(format),
|
firstColumn(firstColumn),
|
lastColumn(lastColumn),
|
outlineLevel(0),
|
isSetWidth(isSetWidth),
|
customWidth(false),
|
hidden(hidden),
|
collapsed(false)
|
{
|
|
}
|
|
double width;
|
Format format;
|
int firstColumn;
|
int lastColumn;
|
int outlineLevel;
|
bool isSetWidth;
|
bool customWidth;
|
bool hidden;
|
bool collapsed;
|
};
|
|
class WorksheetPrivate : public AbstractSheetPrivate
|
{
|
Q_DECLARE_PUBLIC(Worksheet)
|
|
public:
|
WorksheetPrivate(Worksheet *p, Worksheet::CreateFlag flag);
|
~WorksheetPrivate();
|
|
public:
|
int checkDimensions(int row, int col, bool ignore_row=false, bool ignore_col=false);
|
Format cellFormat(int row, int col) const;
|
QString generateDimensionString() const;
|
void calculateSpans() const;
|
void splitColsInfo(int colFirst, int colLast);
|
void validateDimension();
|
|
void saveXmlSheetData(QXmlStreamWriter &writer) const;
|
void saveXmlCellData(QXmlStreamWriter &writer, int row, int col, std::shared_ptr<Cell> cell) const;
|
void saveXmlMergeCells(QXmlStreamWriter &writer) const;
|
void saveXmlHyperlinks(QXmlStreamWriter &writer) const;
|
void saveXmlDrawings(QXmlStreamWriter &writer) const;
|
void saveXmlDataValidations(QXmlStreamWriter &writer) const;
|
|
int rowPixelsSize(int row) const;
|
int colPixelsSize(int col) const;
|
|
void loadXmlSheetData(QXmlStreamReader &reader);
|
void loadXmlColumnsInfo(QXmlStreamReader &reader);
|
void loadXmlMergeCells(QXmlStreamReader &reader);
|
void loadXmlDataValidations(QXmlStreamReader &reader);
|
void loadXmlSheetFormatProps(QXmlStreamReader &reader);
|
void loadXmlSheetViews(QXmlStreamReader &reader);
|
void loadXmlHyperlinks(QXmlStreamReader &reader);
|
|
QList<QSharedPointer<XlsxRowInfo> > getRowInfoList(int rowFirst, int rowLast);
|
QList<QSharedPointer<XlsxColumnInfo> > getColumnInfoList(int colFirst, int colLast);
|
QList<int> getColumnIndexes(int colFirst, int colLast);
|
bool isColumnRangeValid(int colFirst, int colLast);
|
|
SharedStrings *sharedStrings() const;
|
|
public:
|
QMap<int, QMap<int, std::shared_ptr<Cell> > > cellTable;
|
|
QMap<int, QMap<int, QString> > comments;
|
QMap<int, QMap<int, QSharedPointer<XlsxHyperlinkData> > > urlTable;
|
QList<CellRange> merges;
|
QMap<int, QSharedPointer<XlsxRowInfo> > rowsInfo;
|
QMap<int, QSharedPointer<XlsxColumnInfo> > colsInfo;
|
QMap<int, QSharedPointer<XlsxColumnInfo> > colsInfoHelper;
|
|
QList<DataValidation> dataValidationsList;
|
QList<ConditionalFormatting> conditionalFormattingList;
|
|
QMap<int, CellFormula> sharedFormulaMap; // shared formula map
|
|
CellRange dimension;
|
int previous_row;
|
|
mutable QMap<int, QString> row_spans;
|
QMap<int, double> row_sizes;
|
QMap<int, double> col_sizes;
|
|
int outline_row_level;
|
int outline_col_level;
|
|
int default_row_height;
|
bool default_row_zeroed;
|
|
// pagesetup and print settings add by liufeijin 20181028, liufeijin
|
QString PpaperSize;
|
QString Pscale;
|
QString PfirstPageNumber;
|
QString Porientation;
|
QString PuseFirstPageNumber;
|
QString PhorizontalDpi;
|
QString PverticalDpi;
|
QString Prid;
|
QString Pcopies;
|
|
// pageMargins, liufeijin
|
QString PMheader;
|
QString PMfooter;
|
QString PMtop;
|
QString PMbotton;
|
QString PMleft;
|
QString PMright;
|
|
// header footer, liufeijin
|
QString MoodFooter;
|
QString ModdHeader;
|
QString MoodalignWithMargins; // add align 20190619
|
|
XlsxSheetFormatProps sheetFormatProps;
|
|
bool windowProtection;
|
bool showFormulas;
|
bool showGridLines;
|
bool showRowColHeaders;
|
bool showZeros;
|
bool rightToLeft;
|
bool tabSelected;
|
bool showRuler;
|
bool showOutlineSymbols;
|
bool showWhiteSpace;
|
|
QRegularExpression urlPattern;
|
|
private:
|
|
static double calculateColWidth(int characters);
|
};
|
|
QT_END_NAMESPACE_XLSX
|
#endif // XLSXWORKSHEET_P_H
|
