QString CopyCommand::saveAsPlainText(const Region ®ion)
{
// Only one cell selected? => copy active cell
if (region.isSingular()) {
const Cell cell(region.firstSheet(), region.firstRange().topLeft());
return cell.displayText();
}
QString result;
Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it(region.constBegin()); it != end; ++it) {
if (result.length()) result += QLatin1Char('\n');
Region::Element *el = *it;
QRect used = el->sheet()->usedArea (true);
QRect rect = el->rect().intersected (used);
for (int row = rect.top(); row <= rect.bottom(); ++row) {
for (int col = rect.left(); col <= rect.right(); ++col) {
Cell cell (el->sheet(), col, row);
result += cellAsText (cell, col != rect.right());
}
result += QLatin1Char('\n');
}
}
return result;
}
void RecalcManager::Private::cellsToCalculate(const Region& region, QSet<Cell>& cells) const
{
Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it(region.constBegin()); it != end; ++it) {
const QRect range = (*it)->rect();
const Sheet* sheet = (*it)->sheet();
for (int col = range.left(); col <= range.right(); ++col) {
for (int row = range.top(); row <= range.bottom(); ++row) {
Cell cell(sheet, col, row);
// Even empty cells may act as value
// providers and need to be processed.
// check for already processed cells
if (cells.contains(cell))
continue;
// add it to the list
if (cell.isFormula())
cells.insert(cell);
// add its consumers to the list
cellsToCalculate(map->dependencyManager()->consumingRegion(cell), cells);
}
}
}
}
void BindingManager::regionChanged(const Region& region)
{
Sheet* sheet;
QList< QPair<QRectF, Binding> > bindings;
Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it = region.constBegin(); it != end; ++it) {
sheet = (*it)->sheet();
const Region changedRegion((*it)->rect(), sheet);
bindings = sheet->cellStorage()->bindingStorage()->intersectingPairs(changedRegion);
for (int j = 0; j < bindings.count(); ++j)
bindings[j].second.update(changedRegion);
}
}
void ScriptingCellListener::slotChanged(const Region& region)
{
Region::ConstIterator end(region.constEnd());
QVariantList ranges;
for (Region::ConstIterator it = region.constBegin(); it != end; ++it)
ranges << (*it)->rect();
emit regionChanged(ranges);
for (Region::ConstIterator it = region.constBegin(); it != end; ++it) {
const QRect r((*it)->rect());
for (int row = r.top(); row <= r.bottom(); ++row)
for (int col = r.left(); col <= r.right(); ++col)
emit cellChanged(col, row);
}
}
void Binding::update(const Region& region)
{
QRect rect;
Region changedRegion;
const QPoint offset = d->model->region().firstRange().topLeft();
const QRect range = d->model->region().firstRange();
const Sheet* sheet = d->model->region().firstSheet();
Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it = region.constBegin(); it != end; ++it) {
if (sheet != (*it)->sheet())
continue;
rect = range & (*it)->rect();
rect.translate(-offset.x(), -offset.y());
if (rect.isValid()) {
d->model->emitDataChanged(rect);
changedRegion.add(rect, (*it)->sheet());
}
}
d->model->emitChanged(changedRegion);
}
QDomDocument CopyCommand::saveAsHtml(const Region ®ion)
{
QDomDocument doc("spreadsheet-html");
QDomElement html = doc.createElement("html");
doc.appendChild(html);
QDomElement body = doc.createElement("body");
html.appendChild(body);
QDomElement table = doc.createElement("table");
body.appendChild(table);
const Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it(region.constBegin()); it != end; ++it) {
Sheet *const sheet = (*it)->sheet();
const QRect range = (*it)->rect();
// TODO
Q_UNUSED(sheet);
Q_UNUSED(range);
}
return doc;
}
void Selection::extend(const Region& region)
{
if (!region.isValid())
return;
uint count = cells().count();
ConstIterator end(region.constEnd());
for (ConstIterator it = region.constBegin(); it != end; ++it) {
Element *element = *it;
if (!element) continue;
if (element->type() == Element::Point) {
Point* point = static_cast<Point*>(element);
extend(point->pos(), element->sheet());
} else {
extend(element->rect(), element->sheet());
}
}
d->activeSubRegionLength += cells().count() - count;
emitChanged(*this);
}
// era: encode references absolutely
QDomDocument CopyCommand::saveAsXml(const Region& region, bool era)
{
QDomDocument xmlDoc("spreadsheet-snippet");
xmlDoc.appendChild(xmlDoc.createProcessingInstruction("xml", "version=\"1.0\" encoding=\"UTF-8\""));
QDomElement root = xmlDoc.createElement("spreadsheet-snippet");
xmlDoc.appendChild(root);
// find the upper left corner of the selection
const QRect boundingRect = region.boundingRect();
int left = boundingRect.left();
int top = boundingRect.top();
// for tiling the clipboard content in the selection
root.setAttribute("rows", QString::number(boundingRect.height()));
root.setAttribute("columns", QString::number(boundingRect.width()));
const Region::ConstIterator end(region.constEnd());
for (Region::ConstIterator it = region.constBegin(); it != end; ++it) {
Sheet *const sheet = (*it)->sheet();
const QRect range = (*it)->rect();
CellStorage *const storage = sheet->cellStorage();
//
// Entire rows selected?
//
if ((*it)->isRow()) {
QDomElement rows = xmlDoc.createElement("rows");
rows.setAttribute("count", QString::number(range.height()));
rows.setAttribute("row", QString::number(range.top() - top + 1));
root.appendChild(rows);
// Save all cells.
for (int row = range.top(); row <= range.bottom(); ++row) {
Cell cell = storage->firstInRow(row);
for (; !cell.isNull(); cell = storage->nextInRow(cell.column(), cell.row())) {
if (!cell.isPartOfMerged()) {
root.appendChild(cell.save(xmlDoc, 0, top - 1, era));
}
}
}
// TODO Stefan: Inefficient, use cluster functionality
// Save the row formats if there are any
//const RowFormat* format;
for (int row = range.top(); row <= range.bottom(); ++row) {
if (!sheet->rowFormats()->isDefaultRow(row)) {
QDomElement e = RowFormat(sheet->rowFormats(), row).save(xmlDoc, top - 1);
if (!e.isNull()) {
rows.appendChild(e);
}
}
}
continue;
}
//
// Entire columns selected?
//
if ((*it)->isColumn()) {
QDomElement columns = xmlDoc.createElement("columns");
columns.setAttribute("count", QString::number(range.width()));
columns.setAttribute("column", QString::number(range.left() - left + 1));
root.appendChild(columns);
// Save all cells.
for (int col = range.left(); col <= range.right(); ++col) {
Cell cell = storage->firstInColumn(col);
for (; !cell.isNull(); cell = storage->nextInColumn(cell.column(), cell.row())) {
if (!cell.isPartOfMerged()) {
root.appendChild(cell.save(xmlDoc, left - 1, 0, era));
}
}
}
// TODO Stefan: Inefficient, use the cluster functionality
// Save the column formats if there are any
const ColumnFormat* format;
for (int col = range.left(); col <= range.right(); ++col) {
format = sheet->columnFormat(col);
if (format && !format->isDefault()) {
QDomElement e = format->save(xmlDoc, left - 1);
if (!e.isNull()) {
columns.appendChild(e);
}
}
}
continue;
}
// Save all cells.
Cell cell;
for (int row = range.top(); row <= range.bottom(); ++row) {
if (range.left() == 1) {
cell = storage->firstInRow(row);
} else {
cell = storage->nextInRow(range.left() - 1, row);
}
while (!cell.isNull() && cell.column() >= range.left() && cell.column() <= range.right()) {
if (!cell.isPartOfMerged()) {
root.appendChild(cell.save(xmlDoc, left - 1, top - 1, era));
}
cell = storage->nextInRow(cell.column(), cell.row());
}
}
}
return xmlDoc;
}
void Selection::emitChanged(const Region& region)
{
Sheet * const sheet = d->activeSheet;
if(!sheet) // no sheet no update needed
return;
Region extendedRegion;
ConstIterator end(region.constEnd());
for (ConstIterator it = region.constBegin(); it != end; ++it) {
Element* element = *it;
QRect area = element->rect();
const ColumnFormat *col;
//look at if column is hiding.
//if it's hiding refreshing column+1 (or column -1 )
int left = area.left();
int right = area.right();
int top = area.top();
int bottom = area.bottom();
// a merged cells is selected
if (element->type() == Region::Element::Point) {
Cell cell(sheet, left, top);
if (cell.doesMergeCells()) {
// extend to the merged region
// prevents artefacts of the selection rectangle
right += cell.mergedXCells();
bottom += cell.mergedYCells();
}
}
if (right < KS_colMax) {
do {
right++;
col = sheet->columnFormat(right);
} while (col->isHiddenOrFiltered() && right != KS_colMax);
}
if (left > 1) {
do {
left--;
col = sheet->columnFormat(left);
} while (col->isHiddenOrFiltered() && left != 1);
}
if (bottom < KS_rowMax) {
do {
bottom++;
int lastHidden;
if (sheet->rowFormats()->isHiddenOrFiltered(bottom, &lastHidden)) {
bottom = lastHidden;
} else {
break;
}
} while (bottom != KS_rowMax);
}
if (top > 1) {
do {
top--;
int firstHidden;
if (sheet->rowFormats()->isHiddenOrFiltered(top, 0, &firstHidden)) {
top = firstHidden;
} else {
break;
}
} while (top != 1);
}
area.setLeft(left);
area.setRight(right);
area.setTop(top);
area.setBottom(bottom);
extendedRegion.add(area, element->sheet());
}
const QList<Cell> masterCells = sheet->cellStorage()->masterCells(extendedRegion);
for (int i = 0; i < masterCells.count(); ++i)
extendedRegion.add(masterCells[i].cellPosition(), sheet);
emit changed(extendedRegion);
}
