begginers question

**high_flyer** · 13th February 2010, 22:19

Can you run this in debug mode and post the call stack after the crash?

**hollowhead** · 23rd February 2010, 11:15

Thankyou for your kind reply high_flyer, sorry about the delay I have been on holiday. Here is the debug info generated by gdb.

[Thread debugging using libthread_db enabled]
/home/nrh1/.themes/Clearlooks-Clarity/gtk-2.0/gtkrc:49: Clearlooks configuration option "menuitemstyle" is not supported and will be ignored.
/home/nrh1/.themes/Clearlooks-Clarity/gtk-2.0/gtkrc:50: Clearlooks configuration option "listviewitemstyle" is not supported and will be ignored.
/home/nrh1/.themes/Clearlooks-Clarity/gtk-2.0/gtkrc:51: Clearlooks configuration option "progressbarstyle" is not supported and will be ignored.

Program received signal SIGSEGV, Segmentation fault.
0x00e7ac9a in QAbstractScrollArea::viewport() const ()
from /usr/lib/libQtGui.so.4

backtrace
#0 0x00e7ac9a in QAbstractScrollArea::viewport() const ()
from /usr/lib/libQtGui.so.4
#1 0x08051098 in MainWindowImpl::addSpreadsheet (this=0xbffff330,
spreadsheet=0x8184c48) at src/mainwindowimpl.cpp:111
#2 0x08050fff in MainWindowImpl::newFile (this=0xbffff330)
at src/mainwindowimpl.cpp:93
#3 0x08050f75 in MainWindowImpl::loadFiles (this=0xbffff330)
at src/mainwindowimpl.cpp:84
#4 0x0805e36d in MainWindowImpl::qt_metacall (this=0xbffff330,
_c=QMetaObject::InvokeMetaMethod, _id=4, _a=0xbfffebcc)
at build/moc_mainwindowimpl.cpp:89
#5 0x00321263 in QMetaObject::activate(QObject*, int, int, void**) ()
from /usr/lib/libQtCore.so.4
#6 0x00321ec2 in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) () from /usr/lib/libQtCore.so.4
#7 0x00326387 in ?? () from /usr/lib/libQtCore.so.4
#8 0x0032649c in ?? () from /usr/lib/libQtCore.so.4
#9 0x0031b3bf in QObject::event(QEvent*) () from /usr/lib/libQtCore.so.4
#10 0x009d7f54 in QApplicationPrivate::notify_helper(QObject*, QEvent*) ()
from /usr/lib/libQtGui.so.4
#11 0x009df67c in QApplication::notify(QObject*, QEvent*) ()
from /usr/lib/libQtGui.so.4
#12 0x0030b6cb in QCoreApplication::notifyInternal(QObject*, QEvent*) ()
from /usr/lib/libQtCore.so.4
#13 0x003387ce in ?? () from /usr/lib/libQtCore.so.4
#14 0x003360e0 in ?? () from /usr/lib/libQtCore.so.4
#15 0x007aee88 in g_main_context_dispatch () from /lib/libglib-2.0.so.0
#16 0x007b2730 in ?? () from /lib/libglib-2.0.so.0
#17 0x007b2863 in g_main_context_iteration () from /lib/libglib-2.0.so.0
#18 0x0033602c in QEventDispatcherGlib:

rocessEvents(QFlags<QEventLoop::ProcessEventsFlag> ) () from /usr/lib/libQtCore.so.4
#19 0x00a78be5 in ?? () from /usr/lib/libQtGui.so.4
#20 0x00309c79 in QEventLoop:

rocessEvents(QFlags<QEventLoop::ProcessEventsFlag> ) () from /usr/lib/libQtCore.so.4
#21 0x0030a0ca in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsF lag>) ()
from /usr/lib/libQtCore.so.4
#22 0x0030c53f in QCoreApplication::exec() () from /usr/lib/libQtCore.so.4
#23 0x009d7dd7 in QApplication::exec() () from /usr/lib/libQtGui.so.4
#24 0x080570b2 in main (argc=1, argv=0xbffff514) at src/main.cpp:10

**high_flyer** · 23rd February 2010, 12:00

can you post MainWindowImpl::addSpreadsheet()?

**hollowhead** · 23rd February 2010, 16:49

Thanks for your reply cetainly can

Qt Code:

Switch view

void MainWindowImpl::addSpreadsheet(Spreadsheet *spreadsheet) // added 11/2/09 for MDI
{
    /*connect(editor, SIGNAL(copyAvailable(bool)),
            cutAction, SLOT(setEnabled(bool)));
    connect(editor, SIGNAL(copyAvailable(bool)),
            copyAction, SLOT(setEnabled(bool))); */
 
    QMdiSubWindow *subWindow = mdiArea->addSubWindow(spreadsheet);
    windowMenu->addAction(spreadsheet->windowMenuAction());
    windowActionGroup->addAction(spreadsheet->windowMenuAction());
    subWindow->show();
   // spreadsheet->show();
}

void MainWindowImpl::addSpreadsheet(Spreadsheet *spreadsheet) // added 11/2/09 for MDI
{
    /*connect(editor, SIGNAL(copyAvailable(bool)),
            cutAction, SLOT(setEnabled(bool)));
    connect(editor, SIGNAL(copyAvailable(bool)),
            copyAction, SLOT(setEnabled(bool))); */

    QMdiSubWindow *subWindow = mdiArea->addSubWindow(spreadsheet);
    windowMenu->addAction(spreadsheet->windowMenuAction());
    windowActionGroup->addAction(spreadsheet->windowMenuAction());
    subWindow->show();
   // spreadsheet->show();
}

To copy to clipboard, switch view to plain text mode

**high_flyer** · 23rd February 2010, 16:59

What happesn when you try:

Qt Code:

Switch view

void MainWindowImpl::addSpreadsheet(Spreadsheet *spreadsheet) // added 11/2/09 for MDI
{
    /*connect(editor, SIGNAL(copyAvailable(bool)),
            cutAction, SLOT(setEnabled(bool)));
    connect(editor, SIGNAL(copyAvailable(bool)),
            copyAction, SLOT(setEnabled(bool))); */
 
    QMdiSubWindow *subWindow = mdiArea->addSubWindow(spreadsheet);
    windowMenu->addAction(spreadsheet->windowMenuAction());
    windowActionGroup->addAction(spreadsheet->windowMenuAction());
    spreadsheet->show();
    subWindow->show();
 
}

void MainWindowImpl::addSpreadsheet(Spreadsheet *spreadsheet) // added 11/2/09 for MDI
{
    /*connect(editor, SIGNAL(copyAvailable(bool)),
            cutAction, SLOT(setEnabled(bool)));
    connect(editor, SIGNAL(copyAvailable(bool)),
            copyAction, SLOT(setEnabled(bool))); */
   
    QMdiSubWindow *subWindow = mdiArea->addSubWindow(spreadsheet);
    windowMenu->addAction(spreadsheet->windowMenuAction());
    windowActionGroup->addAction(spreadsheet->windowMenuAction());
    spreadsheet->show();
    subWindow->show();

}

To copy to clipboard, switch view to plain text mode

**JD2000** · 23rd February 2010, 20:06

Isn't your spreadsheet pointer being deleted when newFile exits?

**hollowhead** · 23rd February 2010, 21:57

Sadly no change....

Program received signal SIGSEGV, Segmentation fault.
0x00816c9a in QAbstractScrollArea::viewport() const () from /usr/lib/libQtGui.so.4
(gdb)

**JD2000** · 24th February 2010, 12:37

Apologies, I misread your code and thought that maybe mdiArea->addSubwindow was being left hanging.

try

QMdiSubWindow *subWindow = mdiArea->addSubWindow(&spreadsheet);

**high_flyer** · 24th February 2010, 14:29

Ok, I think that your spreadsheet parameter has an invalid pointer.
Can you show the code for MainWindowImpl::newFile ()?

**hollowhead** · 24th February 2010, 15:48

Thanks for your reply....The code was above but here it is

Qt Code:

Switch view

void MainWindowImpl::newFile()
{
    Spreadsheet *spreadsheet = new Spreadsheet;
    spreadsheet->newFile();
    addSpreadsheet(spreadsheet);
    spreadsheet->show(); // possibly required?
}

void MainWindowImpl::newFile()
{
    Spreadsheet *spreadsheet = new Spreadsheet;
    spreadsheet->newFile();
    addSpreadsheet(spreadsheet);
    spreadsheet->show(); // possibly required?
}

To copy to clipboard, switch view to plain text mode

This calls this function in spreadsheet.cpp

Qt Code:

Switch view

void Spreadsheet::newFile()
{
    static int documentNumber = 1;
 
    curFile = tr("document%1.txt").arg(documentNumber);
    setWindowTitle(curFile + "[*]");
    action->setText(curFile);
    isUntitled = true;
    ++documentNumber;
}

void Spreadsheet::newFile()
{
    static int documentNumber = 1;

    curFile = tr("document%1.txt").arg(documentNumber);
    setWindowTitle(curFile + "[*]");
    action->setText(curFile);
    isUntitled = true;
    ++documentNumber;
}

To copy to clipboard, switch view to plain text mode

QMdiSubWindow *subWindow = mdiArea->addSubWindow(&spreadsheet); won't compile

**high_flyer** · 24th February 2010, 16:18

Thanks for your reply....The code was above but here it is

Sorry, I missed it.

What does the Spreadsheet() constructor do?

Also you can try:

Qt Code:

Switch view

void MainWindowImpl::newFile()
{
    Spreadsheet *spreadsheet = new Spreadsheet;
    spreadsheet->newFile();
    spreadsheet->show();//to see if it gets displayed or also crashes.
   //addSpreadsheet(spreadsheet);
    //spreadsheet->show(); // possibly required? not needed here if its called in addSpreadsheet()
}

void MainWindowImpl::newFile()
{
    Spreadsheet *spreadsheet = new Spreadsheet;
    spreadsheet->newFile();
    spreadsheet->show();//to see if it gets displayed or also crashes.
   //addSpreadsheet(spreadsheet);
    //spreadsheet->show(); // possibly required? not needed here if its called in addSpreadsheet()
}

To copy to clipboard, switch view to plain text mode

What I also noticed in spreadsheet:

Qt Code:

Switch view

QAction *windowMenuAction() const { return action; } //added for MDI

QAction *windowMenuAction() const { return action; } //added for MDI

To copy to clipboard, switch view to plain text mode

When does 'action' gets initialized?

**hollowhead** · 24th February 2010, 21:22

Thanks for your reply. I'm afraid your questions are starting to loose me....

I've pasted the last section of remaining code spreadsheet.cpp in the hope this will throw some light on the situation. The windowMenuAction is used in the addSpreadsheet function posted previously.
spreadsheet.cpp

Qt Code:

Switch view

#include <QtGui>
#include "spreadsheet.h"
#include "cell.h"
#include <QTextDocument>
Spreadsheet::Spreadsheet(QWidget *parent)
 : QTableWidget(parent)
{
 
	action = new QAction(this);
    action->setCheckable(true);
    connect(action, SIGNAL(triggered()), this, SLOT(show()));
    connect(action, SIGNAL(triggered()), this, SLOT(setFocus()));
 
    isUntitled = true;
 
	 autoRecalc = true;
 
    setItemPrototype(new Cell);
    setSelectionMode(ContiguousSelection);
 
    connect(this, SIGNAL(itemChanged(QTableWidgetItem *)),
            this, SLOT(somethingChanged()));
	   clear();
	   setAttribute(Qt::WA_DeleteOnClose);
}
void Spreadsheet::newFile()
{
    static int documentNumber = 1;
curFile = tr("document%1.txt").arg(documentNumber);
    setWindowTitle(curFile + "[*]");
    action->setText(curFile);
    isUntitled = true;
    ++documentNumber;
}
QString Spreadsheet::currentLocation() const
{
    return QChar('A' + currentColumn())
           + QString::number(currentRow() + 1);
}
QString Spreadsheet::currentFormula() const
{
    return formula(currentRow(), currentColumn());
}
QTableWidgetSelectionRange Spreadsheet::selectedRange() const
{
    QList<QTableWidgetSelectionRange> ranges = selectedRanges();
    if (ranges.isEmpty())
        return QTableWidgetSelectionRange();
    return ranges.first();
}
void Spreadsheet::clear()
{
    setRowCount(0);
    setColumnCount(0);
    setRowCount(RowCount);
    setColumnCount(ColumnCount);
 for (int i = 0; i < ColumnCount; ++i) {
        QTableWidgetItem *item = new QTableWidgetItem;
        item->setText(QString(QChar('A' + i)));
        setHorizontalHeaderItem(i, item);
    }
setCurrentCell(0, 0);
}
bool Spreadsheet::readFile(const QString &fileName)
{
    QFile file(fileName);
    if (!file.open(QIODevice::ReadOnly)) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("Cannot read file %1:\n%2.")
                             .arg(file.fileName())
                             .arg(file.errorString()));
        return false;
    }
 
    QDataStream in(&file);
    in.setVersion(QDataStream::Qt_4_3);
 
    quint32 magic;
    in >> magic;
    if (magic != MagicNumber) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("The file is not a Spreadsheet file."));
        return false;
    }
 
    clear();
 
    quint16 row;
    quint16 column;
    QString str;
 
    QApplication::setOverrideCursor(Qt::WaitCursor);
    while (!in.atEnd()) {
        in >> row >> column >> str;
        setFormula(row, column, str);
    }
    QApplication::restoreOverrideCursor();
    return true;
}
 
bool Spreadsheet::writeFile(const QString &fileName)
{
    QFile file(fileName);
    if (!file.open(QIODevice::WriteOnly)) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("Cannot write file %1:\n%2.")
                             .arg(file.fileName())
                             .arg(file.errorString()));
        return false;
    }
 
    QDataStream out(&file);
    out.setVersion(QDataStream::Qt_4_3);
 
    out << quint32(MagicNumber);
 
    QApplication::setOverrideCursor(Qt::WaitCursor);
    for (int row = 0; row < RowCount; ++row) {
        for (int column = 0; column < ColumnCount; ++column) {
            QString str = formula(row, column);
            if (!str.isEmpty())
                out << quint16(row) << quint16(column) << str;
        }
    }
    QApplication::restoreOverrideCursor();
    return true;
}
void Spreadsheet::sort(const SpreadsheetCompare &compare)
{
    QList<QStringList> rows;
    QTableWidgetSelectionRange range = selectedRange();
    int i;
 
    for (i = 0; i < range.rowCount(); ++i) {
        QStringList row;
        for (int j = 0; j < range.columnCount(); ++j)
            row.append(formula(range.topRow() + i,
                               range.leftColumn() + j));
        rows.append(row);
    }
 
    qStableSort(rows.begin(), rows.end(), compare);
 
    for (i = 0; i < range.rowCount(); ++i) {
        for (int j = 0; j < range.columnCount(); ++j)
            setFormula(range.topRow() + i, range.leftColumn() + j,
                       rows[i][j]);
    }
 
    clearSelection();
    somethingChanged();
}
void Spreadsheet::cut()
{
    copy();
    del();
}
void Spreadsheet::copy()
{
    QTableWidgetSelectionRange range = selectedRange();
    QString str;
 
    for (int i = 0; i < range.rowCount(); ++i) {
        if (i > 0)
            str += "\n";
        for (int j = 0; j < range.columnCount(); ++j) {
            if (j > 0)
                str += "\t";
            str += formula(range.topRow() + i, range.leftColumn() + j);
        }
    }
    QApplication::clipboard()->setText(str);
}
void Spreadsheet::paste()
{
    QTableWidgetSelectionRange range = selectedRange();
    QString str = QApplication::clipboard()->text();
    QStringList rows = str.split('\n');
    int numRows = rows.count();
    int numColumns = rows.first().count('\t') + 1;
 
    if (range.rowCount() * range.columnCount() != 1
            && (range.rowCount() != numRows
                || range.columnCount() != numColumns)) {
        QMessageBox::information(this, tr("Spreadsheet"),
                tr("The information cannot be pasted because the copy "
                   "and paste areas aren't the same size."));
        return;
    }
 
    for (int i = 0; i < numRows; ++i) {
        QStringList columns = rows[i].split('\t');
        for (int j = 0; j < numColumns; ++j) {
            int row = range.topRow() + i;
            int column = range.leftColumn() + j;
            if (row < RowCount && column < ColumnCount)
                setFormula(row, column, columns[j]);
        }
    }
    somethingChanged();
}
void Spreadsheet::del()
{
    QList<QTableWidgetItem *> items = selectedItems();
    if (!items.isEmpty()) {
        foreach (QTableWidgetItem *item, items)
            delete item;
        somethingChanged();
    }
}
void Spreadsheet::selectCurrentRow()
{
    selectRow(currentRow());
}
 
void Spreadsheet::selectCurrentColumn()
{
    selectColumn(currentColumn());
}
 
void Spreadsheet::recalculate()
{
    for (int row = 0; row < RowCount; ++row) {
        for (int column = 0; column < ColumnCount; ++column) {
            if (cell(row, column))
                cell(row, column)->setDirty();
        }
    }
    viewport()->update();
}
void Spreadsheet::setAutoRecalculate(bool recalc)
{
    autoRecalc = recalc;
    if (autoRecalc)
        recalculate();
}
 
 
void Spreadsheet::somethingChanged()
{
    if (autoRecalc)
        recalculate();
    emit modified();
}
 
Cell *Spreadsheet::cell(int row, int column) const
{
    return static_cast<Cell *>(item(row, column));
}
 
void Spreadsheet::setFormula(int row, int column,
                             const QString &formula)
{
    Cell *c = cell(row, column);
    if (!c) {
        c = new Cell;
        setItem(row, column, c);
    }
    c->setFormula(formula);
}
 
QString Spreadsheet::formula(int row, int column) const
{
    Cell *c = cell(row, column);
    if (c) {
        return c->formula();
    } else {
        return "";
    }
}
 
QString Spreadsheet::text(int row, int column) const
{
    Cell *c = cell(row, column);
    if (c) {
        return c->text();
    } else {
        return "";
    }
}
 
bool SpreadsheetCompare::operator()(const QStringList &row1,
                                    const QStringList &row2) const
{
    for (int i = 0; i < KeyCount; ++i) {
        int column = keys[i];
        if (column != -1) {
            if (row1[column] != row2[column]) {
                if (ascending[i]) {
                    return row1[column] < row2[column];
                } else {
                    return row1[column] > row2[column];
                }
            }
        }
    }
    return false;
}
 
 
void Spreadsheet::selectFont()
{
    QList<QTableWidgetItem *> items = selectedItems();
    if (items.isEmpty()) 
return;    	
 
 
        bool ok = false;
    	QFont fnt = QFontDialog::getFont(&ok, font(), this);
 
    if (!ok)
        return;
    foreach (QTableWidgetItem *item, items)
        if(item)
            item->setFont(fnt);
        somethingChanged();
 
}
 
void::Spreadsheet::toHtml(const QString &plainText)
{
    QTableWidgetSelectionRange range = selectedRange();
    QString html= Qt::escape(plainText);
 
    for (int i = 0; i < range.rowCount(); ++i) {
        if (i > 0)
            html.replace("\n", "\n<tr><td>");
        for (int j = 0; j < range.columnCount(); ++j) {
            if (j > 0)
                html.replace("\t", "\t<tr><td>");
 
html.prepend("<table>\n<tr><td>");
html.append("\n</table>");
        }
    }
    printHtml(html);
 
}
}
Spreadsheet *Spreadsheet::openFile(const QString &fileName, QWidget *parent)
{
    Spreadsheet *spreadsheet = new Spreadsheet(parent);
    if (spreadsheet->readFile(fileName)) 
    	{
        spreadsheet->setCurrentFile(fileName);
        return spreadsheet;
        } else 
        {
        delete spreadsheet;
        return 0;
    }
}
void Spreadsheet::setCurrentFile(const QString &fileName)
{
    curFile = fileName;
    isUntitled = false;
    action->setText(strippedName(curFile));
    //document()->setModified(false);
    setWindowTitle(strippedName(curFile) + "[*]");
    setWindowModified(false);
}

#include <QtGui>
#include "spreadsheet.h"
#include "cell.h"
#include <QTextDocument>
Spreadsheet::Spreadsheet(QWidget *parent)
 : QTableWidget(parent)
{
	
	action = new QAction(this);
    action->setCheckable(true);
    connect(action, SIGNAL(triggered()), this, SLOT(show()));
    connect(action, SIGNAL(triggered()), this, SLOT(setFocus()));

    isUntitled = true;
	
	 autoRecalc = true;

    setItemPrototype(new Cell);
    setSelectionMode(ContiguousSelection);

    connect(this, SIGNAL(itemChanged(QTableWidgetItem *)),
            this, SLOT(somethingChanged()));
	   clear();
	   setAttribute(Qt::WA_DeleteOnClose);
}
void Spreadsheet::newFile()
{
    static int documentNumber = 1;
curFile = tr("document%1.txt").arg(documentNumber);
    setWindowTitle(curFile + "[*]");
    action->setText(curFile);
    isUntitled = true;
    ++documentNumber;
}
QString Spreadsheet::currentLocation() const
{
    return QChar('A' + currentColumn())
           + QString::number(currentRow() + 1);
}
QString Spreadsheet::currentFormula() const
{
    return formula(currentRow(), currentColumn());
}
QTableWidgetSelectionRange Spreadsheet::selectedRange() const
{
    QList<QTableWidgetSelectionRange> ranges = selectedRanges();
    if (ranges.isEmpty())
        return QTableWidgetSelectionRange();
    return ranges.first();
}
void Spreadsheet::clear()
{
    setRowCount(0);
    setColumnCount(0);
    setRowCount(RowCount);
    setColumnCount(ColumnCount);
 for (int i = 0; i < ColumnCount; ++i) {
        QTableWidgetItem *item = new QTableWidgetItem;
        item->setText(QString(QChar('A' + i)));
        setHorizontalHeaderItem(i, item);
    }
setCurrentCell(0, 0);
}
bool Spreadsheet::readFile(const QString &fileName)
{
    QFile file(fileName);
    if (!file.open(QIODevice::ReadOnly)) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("Cannot read file %1:\n%2.")
                             .arg(file.fileName())
                             .arg(file.errorString()));
        return false;
    }

    QDataStream in(&file);
    in.setVersion(QDataStream::Qt_4_3);

    quint32 magic;
    in >> magic;
    if (magic != MagicNumber) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("The file is not a Spreadsheet file."));
        return false;
    }

    clear();

    quint16 row;
    quint16 column;
    QString str;

    QApplication::setOverrideCursor(Qt::WaitCursor);
    while (!in.atEnd()) {
        in >> row >> column >> str;
        setFormula(row, column, str);
    }
    QApplication::restoreOverrideCursor();
    return true;
}

bool Spreadsheet::writeFile(const QString &fileName)
{
    QFile file(fileName);
    if (!file.open(QIODevice::WriteOnly)) {
        QMessageBox::warning(this, tr("Spreadsheet"),
                             tr("Cannot write file %1:\n%2.")
                             .arg(file.fileName())
                             .arg(file.errorString()));
        return false;
    }

    QDataStream out(&file);
    out.setVersion(QDataStream::Qt_4_3);

    out << quint32(MagicNumber);

    QApplication::setOverrideCursor(Qt::WaitCursor);
    for (int row = 0; row < RowCount; ++row) {
        for (int column = 0; column < ColumnCount; ++column) {
            QString str = formula(row, column);
            if (!str.isEmpty())
                out << quint16(row) << quint16(column) << str;
        }
    }
    QApplication::restoreOverrideCursor();
    return true;
}
void Spreadsheet::sort(const SpreadsheetCompare &compare)
{
    QList<QStringList> rows;
    QTableWidgetSelectionRange range = selectedRange();
    int i;

    for (i = 0; i < range.rowCount(); ++i) {
        QStringList row;
        for (int j = 0; j < range.columnCount(); ++j)
            row.append(formula(range.topRow() + i,
                               range.leftColumn() + j));
        rows.append(row);
    }

    qStableSort(rows.begin(), rows.end(), compare);

    for (i = 0; i < range.rowCount(); ++i) {
        for (int j = 0; j < range.columnCount(); ++j)
            setFormula(range.topRow() + i, range.leftColumn() + j,
                       rows[i][j]);
    }

    clearSelection();
    somethingChanged();
}
void Spreadsheet::cut()
{
    copy();
    del();
}
void Spreadsheet::copy()
{
    QTableWidgetSelectionRange range = selectedRange();
    QString str;

    for (int i = 0; i < range.rowCount(); ++i) {
        if (i > 0)
            str += "\n";
        for (int j = 0; j < range.columnCount(); ++j) {
            if (j > 0)
                str += "\t";
            str += formula(range.topRow() + i, range.leftColumn() + j);
        }
    }
    QApplication::clipboard()->setText(str);
}
void Spreadsheet::paste()
{
    QTableWidgetSelectionRange range = selectedRange();
    QString str = QApplication::clipboard()->text();
    QStringList rows = str.split('\n');
    int numRows = rows.count();
    int numColumns = rows.first().count('\t') + 1;

    if (range.rowCount() * range.columnCount() != 1
            && (range.rowCount() != numRows
                || range.columnCount() != numColumns)) {
        QMessageBox::information(this, tr("Spreadsheet"),
                tr("The information cannot be pasted because the copy "
                   "and paste areas aren't the same size."));
        return;
    }

    for (int i = 0; i < numRows; ++i) {
        QStringList columns = rows[i].split('\t');
        for (int j = 0; j < numColumns; ++j) {
            int row = range.topRow() + i;
            int column = range.leftColumn() + j;
            if (row < RowCount && column < ColumnCount)
                setFormula(row, column, columns[j]);
        }
    }
    somethingChanged();
}
void Spreadsheet::del()
{
    QList<QTableWidgetItem *> items = selectedItems();
    if (!items.isEmpty()) {
        foreach (QTableWidgetItem *item, items)
            delete item;
        somethingChanged();
    }
}
void Spreadsheet::selectCurrentRow()
{
    selectRow(currentRow());
}

void Spreadsheet::selectCurrentColumn()
{
    selectColumn(currentColumn());
}

void Spreadsheet::recalculate()
{
    for (int row = 0; row < RowCount; ++row) {
        for (int column = 0; column < ColumnCount; ++column) {
            if (cell(row, column))
                cell(row, column)->setDirty();
        }
    }
    viewport()->update();
}
void Spreadsheet::setAutoRecalculate(bool recalc)
{
    autoRecalc = recalc;
    if (autoRecalc)
        recalculate();
}


void Spreadsheet::somethingChanged()
{
    if (autoRecalc)
        recalculate();
    emit modified();
}

Cell *Spreadsheet::cell(int row, int column) const
{
    return static_cast<Cell *>(item(row, column));
}

void Spreadsheet::setFormula(int row, int column,
                             const QString &formula)
{
    Cell *c = cell(row, column);
    if (!c) {
        c = new Cell;
        setItem(row, column, c);
    }
    c->setFormula(formula);
}

QString Spreadsheet::formula(int row, int column) const
{
    Cell *c = cell(row, column);
    if (c) {
        return c->formula();
    } else {
        return "";
    }
}

QString Spreadsheet::text(int row, int column) const
{
    Cell *c = cell(row, column);
    if (c) {
        return c->text();
    } else {
        return "";
    }
}

bool SpreadsheetCompare::operator()(const QStringList &row1,
                                    const QStringList &row2) const
{
    for (int i = 0; i < KeyCount; ++i) {
        int column = keys[i];
        if (column != -1) {
            if (row1[column] != row2[column]) {
                if (ascending[i]) {
                    return row1[column] < row2[column];
                } else {
                    return row1[column] > row2[column];
                }
            }
        }
    }
    return false;
}


void Spreadsheet::selectFont()
{
    QList<QTableWidgetItem *> items = selectedItems();
    if (items.isEmpty()) 
return;    	
    	
    	
        bool ok = false;
    	QFont fnt = QFontDialog::getFont(&ok, font(), this);

    if (!ok)
        return;
    foreach (QTableWidgetItem *item, items)
        if(item)
            item->setFont(fnt);
        somethingChanged();
    
}

void::Spreadsheet::toHtml(const QString &plainText)
{
    QTableWidgetSelectionRange range = selectedRange();
    QString html= Qt::escape(plainText);

    for (int i = 0; i < range.rowCount(); ++i) {
        if (i > 0)
            html.replace("\n", "\n<tr><td>");
        for (int j = 0; j < range.columnCount(); ++j) {
            if (j > 0)
                html.replace("\t", "\t<tr><td>");
          
html.prepend("<table>\n<tr><td>");
html.append("\n</table>");
        }
    }
    printHtml(html);
    
}
}
Spreadsheet *Spreadsheet::openFile(const QString &fileName, QWidget *parent)
{
    Spreadsheet *spreadsheet = new Spreadsheet(parent);
    if (spreadsheet->readFile(fileName)) 
    	{
        spreadsheet->setCurrentFile(fileName);
        return spreadsheet;
        } else 
        {
        delete spreadsheet;
        return 0;
    }
}
void Spreadsheet::setCurrentFile(const QString &fileName)
{
    curFile = fileName;
    isUntitled = false;
    action->setText(strippedName(curFile));
    //document()->setModified(false);
    setWindowTitle(strippedName(curFile) + "[*]");
    setWindowModified(false);
}

To copy to clipboard, switch view to plain text mode

Thread: begginers question

Thread Tools

Search Thread

Display

Hybrid View

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Re: begginers question

Bookmarks

Bookmarks

Posting Permissions