// xlsxcellreference.cpp
|
|
#include "xlsxcellreference.h"
|
#include <QStringList>
|
#include <QMap>
|
|
#include <QRegularExpression>
|
|
QT_BEGIN_NAMESPACE_XLSX
|
|
namespace {
|
|
int intPow(int x, int p)
|
{
|
if (p == 0) return 1;
|
if (p == 1) return x;
|
|
int tmp = intPow(x, p/2);
|
if (p%2 == 0) return tmp * tmp;
|
else return x * tmp * tmp;
|
}
|
|
QString col_to_name(int col_num)
|
{
|
static thread_local QMap<int, QString> col_cache;
|
|
auto it = col_cache.find(col_num);
|
if (it == col_cache.end()) {
|
QString col_str;
|
int remainder;
|
while (col_num) {
|
remainder = col_num % 26;
|
if (remainder == 0)
|
remainder = 26;
|
col_str.prepend(QChar('A'+remainder-1));
|
col_num = (col_num - 1) / 26;
|
}
|
it = col_cache.insert(col_num, col_str);
|
}
|
|
return it.value();
|
}
|
|
int col_from_name(const QString &col_str)
|
{
|
int col = 0;
|
int expn = 0;
|
for (int i=col_str.size()-1; i>-1; --i) {
|
col += (col_str[i].unicode() - 'A' + 1) * intPow(26, expn);
|
expn++;
|
}
|
|
return col;
|
}
|
} //namespace
|
|
/*!
|
\class CellReference
|
\brief For one single cell such as "A1"
|
\inmodule QtXlsx
|
|
The CellReference class stores the cell location in a worksheet.
|
*/
|
|
/*!
|
Constructs an invalid Cell Reference
|
*/
|
CellReference::CellReference()
|
: _row(-1), _column(-1)
|
{
|
}
|
|
/*!
|
Constructs the Reference from the given \a row, and \a column.
|
*/
|
CellReference::CellReference(int row, int column)
|
: _row(row), _column(column)
|
{
|
}
|
|
/*!
|
\overload
|
Constructs the Reference form the given \a cell string.
|
*/
|
CellReference::CellReference(const QString &cell)
|
{
|
init(cell);
|
}
|
|
/*!
|
\overload
|
Constructs the Reference form the given \a cell string.
|
*/
|
CellReference::CellReference(const char *cell)
|
{
|
init(QString::fromLatin1(cell));
|
}
|
|
void CellReference::init(const QString &cell_str)
|
{
|
static thread_local QRegularExpression re(QStringLiteral("^\\$?([A-Z]{1,3})\\$?(\\d+)$"));
|
QRegularExpressionMatch match = re.match(cell_str);
|
if (match.hasMatch()) {
|
const QString col_str = match.captured(1);
|
const QString row_str = match.captured(2);
|
_row = row_str.toInt();
|
_column = col_from_name(col_str);
|
}
|
}
|
|
/*!
|
Constructs a Reference by copying the given \a
|
other Reference.
|
*/
|
CellReference::CellReference(const CellReference &other)
|
: _row(other._row), _column(other._column)
|
{
|
}
|
|
/*!
|
Destroys the Reference.
|
*/
|
CellReference::~CellReference()
|
{
|
}
|
|
/*!
|
Convert the Reference to string notation, such as "A1" or "$A$1".
|
If current object is invalid, an empty string will be returned.
|
*/
|
QString CellReference::toString(bool row_abs, bool col_abs) const
|
{
|
if (!isValid())
|
return QString();
|
|
QString cell_str;
|
if (col_abs)
|
cell_str.append(QLatin1Char('$'));
|
cell_str.append(col_to_name(_column));
|
if (row_abs)
|
cell_str.append(QLatin1Char('$'));
|
cell_str.append(QString::number(_row));
|
return cell_str;
|
}
|
|
/*!
|
* Returns true if the Reference is valid.
|
*/
|
bool CellReference::isValid() const
|
{
|
return _row > 0 && _column > 0;
|
}
|
|
QT_END_NAMESPACE_XLSX
|
