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: 
  1. #include <QtGui>
  2. #include "spreadsheet.h"
  3. #include "cell.h"
  4. #include <QTextDocument>
  5. Spreadsheet::Spreadsheet(QWidget *parent)
  6.  : QTableWidget(parent)
  7. {
  8.  
  9. 	action = new QAction(this);
  10.     action->setCheckable(true);
  11.     connect(action, SIGNAL(triggered()), this, SLOT(show()));
  12.     connect(action, SIGNAL(triggered()), this, SLOT(setFocus()));
  13.  
  14.     isUntitled = true;
  15.  
  16. 	 autoRecalc = true;
  17.  
  18.     setItemPrototype(new Cell);
  19.     setSelectionMode(ContiguousSelection);
  20.  
  21.     connect(this, SIGNAL(itemChanged(QTableWidgetItem *)),
  22.             this, SLOT(somethingChanged()));
  23. 	   clear();
  24. 	   setAttribute(Qt::WA_DeleteOnClose);
  25. }
  26. void Spreadsheet::newFile()
  27. {
  28.     static int documentNumber = 1;
  29. curFile = tr("document%1.txt").arg(documentNumber);
  30.     setWindowTitle(curFile + "[*]");
  31.     action->setText(curFile);
  32.     isUntitled = true;
  33.     ++documentNumber;
  34. }
  35. QString Spreadsheet::currentLocation() const
  36. {
  37.     return QChar('A' + currentColumn())
  38.            + QString::number(currentRow() + 1);
  39. }
  40. QString Spreadsheet::currentFormula() const
  41. {
  42.     return formula(currentRow(), currentColumn());
  43. }
  44. QTableWidgetSelectionRange Spreadsheet::selectedRange() const
  45. {
  46.     QList<QTableWidgetSelectionRange> ranges = selectedRanges();
  47.     if (ranges.isEmpty())
  49.     return ranges.first();
  50. }
  51. void Spreadsheet::clear()
  52. {
  53.     setRowCount(0);
  54.     setColumnCount(0);
  55.     setRowCount(RowCount);
  56.     setColumnCount(ColumnCount);
  57.  for (int i = 0; i < ColumnCount; ++i) {
  59.         item->setText(QString(QChar('A' + i)));
  60.         setHorizontalHeaderItem(i, item);
  61.     }
  62. setCurrentCell(0, 0);
  63. }
  64. bool Spreadsheet::readFile(const QString &fileName)
  65. {
  66.     QFile file(fileName);
  67.     if (!file.open(QIODevice::ReadOnly)) {
  68.         QMessageBox::warning(this, tr("Spreadsheet"),
  69.                              tr("Cannot read file %1:\n%2.")
  70.                              .arg(file.fileName())
  71.                              .arg(file.errorString()));
  72.         return false;
  73.     }
  74.  
  75.     QDataStream in(&file);
  76.     in.setVersion(QDataStream::Qt_4_3);
  77.  
  78.     quint32 magic;
  79.     in >> magic;
  80.     if (magic != MagicNumber) {
  81.         QMessageBox::warning(this, tr("Spreadsheet"),
  82.                              tr("The file is not a Spreadsheet file."));
  83.         return false;
  84.     }
  85.  
  86.     clear();
  87.  
  88.     quint16 row;
  89.     quint16 column;
  90.     QString str;
  91.  
  92.     QApplication::setOverrideCursor(Qt::WaitCursor);
  93.     while (!in.atEnd()) {
  94.         in >> row >> column >> str;
  95.         setFormula(row, column, str);
  96.     }
  97.     QApplication::restoreOverrideCursor();
  98.     return true;
  99. }
  100.  
  101. bool Spreadsheet::writeFile(const QString &fileName)
  102. {
  103.     QFile file(fileName);
  104.     if (!file.open(QIODevice::WriteOnly)) {
  105.         QMessageBox::warning(this, tr("Spreadsheet"),
  106.                              tr("Cannot write file %1:\n%2.")
  107.                              .arg(file.fileName())
  108.                              .arg(file.errorString()));
  109.         return false;
  110.     }
  111.  
  112.     QDataStream out(&file);
  113.     out.setVersion(QDataStream::Qt_4_3);
  114.  
  115.     out << quint32(MagicNumber);
  116.  
  117.     QApplication::setOverrideCursor(Qt::WaitCursor);
  118.     for (int row = 0; row < RowCount; ++row) {
  119.         for (int column = 0; column < ColumnCount; ++column) {
  120.             QString str = formula(row, column);
  121.             if (!str.isEmpty())
  122.                 out << quint16(row) << quint16(column) << str;
  123.         }
  124.     }
  125.     QApplication::restoreOverrideCursor();
  126.     return true;
  127. }
  128. void Spreadsheet::sort(const SpreadsheetCompare &compare)
  129. {
  130.     QList<QStringList> rows;
  131.     QTableWidgetSelectionRange range = selectedRange();
  132.     int i;
  133.  
  134.     for (i = 0; i < range.rowCount(); ++i) {
  136.         for (int j = 0; j < range.columnCount(); ++j)
  137.             row.append(formula(range.topRow() + i,
  138.                                range.leftColumn() + j));
  139.         rows.append(row);
  140.     }
  141.  
  142.     qStableSort(rows.begin(), rows.end(), compare);
  143.  
  144.     for (i = 0; i < range.rowCount(); ++i) {
  145.         for (int j = 0; j < range.columnCount(); ++j)
  146.             setFormula(range.topRow() + i, range.leftColumn() + j,
  147.                        rows[i][j]);
  148.     }
  149.  
  150.     clearSelection();
  151.     somethingChanged();
  152. }
  153. void Spreadsheet::cut()
  154. {
  155.     copy();
  156.     del();
  157. }
  158. void Spreadsheet::copy()
  159. {
  160.     QTableWidgetSelectionRange range = selectedRange();
  161.     QString str;
  162.  
  163.     for (int i = 0; i < range.rowCount(); ++i) {
  164.         if (i > 0)
  165.             str += "\n";
  166.         for (int j = 0; j < range.columnCount(); ++j) {
  167.             if (j > 0)
  168.                 str += "\t";
  169.             str += formula(range.topRow() + i, range.leftColumn() + j);
  170.         }
  171.     }
  172.     QApplication::clipboard()->setText(str);
  173. }
  174. void Spreadsheet::paste()
  175. {
  176.     QTableWidgetSelectionRange range = selectedRange();
  177.     QString str = QApplication::clipboard()->text();
  178.     QStringList rows = str.split('\n');
  179.     int numRows = rows.count();
  180.     int numColumns = rows.first().count('\t') + 1;
  181.  
  182.     if (range.rowCount() * range.columnCount() != 1
  183.             && (range.rowCount() != numRows
  184.                 || range.columnCount() != numColumns)) {
  185.         QMessageBox::information(this, tr("Spreadsheet"),
  186.                 tr("The information cannot be pasted because the copy "
  187.                    "and paste areas aren't the same size."));
  188.         return;
  189.     }
  190.  
  191.     for (int i = 0; i < numRows; ++i) {
  192.         QStringList columns = rows[i].split('\t');
  193.         for (int j = 0; j < numColumns; ++j) {
  194.             int row = range.topRow() + i;
  195.             int column = range.leftColumn() + j;
  196.             if (row < RowCount && column < ColumnCount)
  197.                 setFormula(row, column, columns[j]);
  198.         }
  199.     }
  200.     somethingChanged();
  201. }
  202. void Spreadsheet::del()
  203. {
  204.     QList<QTableWidgetItem *> items = selectedItems();
  205.     if (!items.isEmpty()) {
  206.         foreach (QTableWidgetItem *item, items)
  207.             delete item;
  208.         somethingChanged();
  209.     }
  210. }
  211. void Spreadsheet::selectCurrentRow()
  212. {
  213.     selectRow(currentRow());
  214. }
  215.  
  216. void Spreadsheet::selectCurrentColumn()
  217. {
  218.     selectColumn(currentColumn());
  219. }
  220.  
  221. void Spreadsheet::recalculate()
  222. {
  223.     for (int row = 0; row < RowCount; ++row) {
  224.         for (int column = 0; column < ColumnCount; ++column) {
  225.             if (cell(row, column))
  226.                 cell(row, column)->setDirty();
  227.         }
  228.     }
  229.     viewport()->update();
  230. }
  231. void Spreadsheet::setAutoRecalculate(bool recalc)
  232. {
  233.     autoRecalc = recalc;
  234.     if (autoRecalc)
  235.         recalculate();
  236. }
  237.  
  238.  
  239. void Spreadsheet::somethingChanged()
  240. {
  241.     if (autoRecalc)
  242.         recalculate();
  243.     emit modified();
  244. }
  245.  
  246. Cell *Spreadsheet::cell(int row, int column) const
  247. {
  248.     return static_cast<Cell *>(item(row, column));
  249. }
  250.  
  251. void Spreadsheet::setFormula(int row, int column,
  252.                              const QString &formula)
  253. {
  254.     Cell *c = cell(row, column);
  255.     if (!c) {
  256.         c = new Cell;
  257.         setItem(row, column, c);
  258.     }
  259.     c->setFormula(formula);
  260. }
  261.  
  262. QString Spreadsheet::formula(int row, int column) const
  263. {
  264.     Cell *c = cell(row, column);
  265.     if (c) {
  266.         return c->formula();
  267.     } else {
  268.         return "";
  269.     }
  270. }
  271.  
  272. QString Spreadsheet::text(int row, int column) const
  273. {
  274.     Cell *c = cell(row, column);
  275.     if (c) {
  276.         return c->text();
  277.     } else {
  278.         return "";
  279.     }
  280. }
  281.  
  282. bool SpreadsheetCompare::operator()(const QStringList &row1,
  283.                                     const QStringList &row2) const
  284. {
  285.     for (int i = 0; i < KeyCount; ++i) {
  286.         int column = keys[i];
  287.         if (column != -1) {
  288.             if (row1[column] != row2[column]) {
  289.                 if (ascending[i]) {
  290.                     return row1[column] < row2[column];
  291.                 } else {
  292.                     return row1[column] > row2[column];
  293.                 }
  294.             }
  295.         }
  296.     }
  297.     return false;
  298. }
  299.  
  300.  
  301. void Spreadsheet::selectFont()
  302. {
  303.     QList<QTableWidgetItem *> items = selectedItems();
  304.     if (items.isEmpty()) 
  305. return;    	
  306.  
  307.  
  308.         bool ok = false;
  309.     	QFont fnt = QFontDialog::getFont(&ok, font(), this);
  310.  
  311.     if (!ok)
  312.         return;
  313.     foreach (QTableWidgetItem *item, items)
  314.         if(item)
  315.             item->setFont(fnt);
  316.         somethingChanged();
  317.  
  318. }
  319.  
  320. void::Spreadsheet::toHtml(const QString &plainText)
  321. {
  322.     QTableWidgetSelectionRange range = selectedRange();
  323.     QString html= Qt::escape(plainText);
  324.  
  325.     for (int i = 0; i < range.rowCount(); ++i) {
  326.         if (i > 0)
  327.             html.replace("\n", "\n<tr><td>");
  328.         for (int j = 0; j < range.columnCount(); ++j) {
  329.             if (j > 0)
  330.                 html.replace("\t", "\t<tr><td>");
  331.  
  332. html.prepend("<table>\n<tr><td>");
  333. html.append("\n</table>");
  334.         }
  335.     }
  336.     printHtml(html);
  337.  
  338. }
  339. }
  340. Spreadsheet *Spreadsheet::openFile(const QString &fileName, QWidget *parent)
  341. {
  342.     Spreadsheet *spreadsheet = new Spreadsheet(parent);
  343.     if (spreadsheet->readFile(fileName)) 
  344.     	{
  345.         spreadsheet->setCurrentFile(fileName);
  346.         return spreadsheet;
  347.         } else 
  348.         {
  349.         delete spreadsheet;
  350.         return 0;
  351.     }
  352. }
  353. void Spreadsheet::setCurrentFile(const QString &fileName)
  354. {
  355.     curFile = fileName;
  356.     isUntitled = false;
  357.     action->setText(strippedName(curFile));
  358.     //document()->setModified(false);
  359.     setWindowTitle(strippedName(curFile) + "[*]");
  360.     setWindowModified(false);
  361. }
To copy to clipboard, switch view to plain text mode