summaryrefslogtreecommitdiff
authorthufir <thufir>2002-07-04 17:21:16 (UTC)
committer thufir <thufir>2002-07-04 17:21:16 (UTC)
commit3fc06dce797f62393bab41f4ea520bdbeb31eb9f (patch) (side-by-side diff)
treedfd314d2c9a2241f3dce5649592808ff1ee4aea0
parentbaf06586f452ea77f773df038aba5635f57d96b8 (diff)
downloadopie-3fc06dce797f62393bab41f4ea520bdbeb31eb9f.zip
opie-3fc06dce797f62393bab41f4ea520bdbeb31eb9f.tar.gz
opie-3fc06dce797f62393bab41f4ea520bdbeb31eb9f.tar.bz2
added license headers to opie-sheet
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--noncore/apps/opie-sheet/cellformat.cpp14
-rw-r--r--noncore/apps/opie-sheet/cellformat.h14
-rw-r--r--noncore/apps/opie-sheet/finddlg.cpp14
-rw-r--r--noncore/apps/opie-sheet/finddlg.h14
-rw-r--r--noncore/apps/opie-sheet/main.cpp14
-rw-r--r--noncore/apps/opie-sheet/mainwindow.cpp14
-rw-r--r--noncore/apps/opie-sheet/mainwindow.h14
-rw-r--r--noncore/apps/opie-sheet/numberdlg.cpp14
-rw-r--r--noncore/apps/opie-sheet/numberdlg.h14
-rw-r--r--noncore/apps/opie-sheet/sheet.cpp14
-rw-r--r--noncore/apps/opie-sheet/sheet.h14
-rw-r--r--noncore/apps/opie-sheet/sortdlg.cpp14
-rw-r--r--noncore/apps/opie-sheet/sortdlg.h14
-rw-r--r--noncore/apps/opie-sheet/textdlg.cpp14
-rw-r--r--noncore/apps/opie-sheet/textdlg.h14
15 files changed, 210 insertions, 0 deletions
diff --git a/noncore/apps/opie-sheet/cellformat.cpp b/noncore/apps/opie-sheet/cellformat.cpp
index 6a2ff72..597502c 100644
--- a/noncore/apps/opie-sheet/cellformat.cpp
+++ b/noncore/apps/opie-sheet/cellformat.cpp
@@ -1,512 +1,526 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include "cellformat.h"
#include <qlistbox.h>
#include <qlabel.h>
#define COMBO_WIDTHS 155
#define COMBO_HEIGHTS 21
#define COLOR_COUNT 17
#define STYLE_COUNT 14
#define HALIGN_COUNT 3
#define VALIGN_COUNT 3
QColor qtColors[COLOR_COUNT]={Qt::black, Qt::white, Qt::darkGray, Qt::gray, Qt::lightGray, Qt::red, Qt::green, Qt::blue, Qt::cyan, Qt::magenta, Qt::yellow, Qt::darkRed, Qt::darkGreen, Qt::darkBlue, Qt::darkCyan, Qt::darkMagenta, Qt::darkYellow};
Qt::BrushStyle brushStyles[STYLE_COUNT]={Qt::SolidPattern, Qt::Dense1Pattern, Qt::Dense2Pattern, Qt::Dense3Pattern, Qt::Dense4Pattern, Qt::Dense5Pattern, Qt::Dense6Pattern, Qt::Dense7Pattern, Qt::HorPattern, Qt::VerPattern, Qt::CrossPattern, Qt::BDiagPattern, Qt::FDiagPattern, Qt::DiagCrossPattern};
QString namesHAlign[HALIGN_COUNT]={"Left", "Right", "Center"};
QString namesVAlign[VALIGN_COUNT]={"Top", "Bottom", "Center"};
Qt::AlignmentFlags flagsHAlign[HALIGN_COUNT]={Qt::AlignLeft, Qt::AlignRight, Qt::AlignHCenter};
Qt::AlignmentFlags flagsVAlign[VALIGN_COUNT]={Qt::AlignTop, Qt::AlignBottom, Qt::AlignVCenter};
CellFormat::CellFormat(QWidget *parent=0)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetBorders=new QWidget(tabs);
widgetBackground=new QWidget(tabs);
widgetFont=new QWidget(tabs);
widgetAlignment=new QWidget(tabs);
tabs->addTab(widgetBorders, tr("&Borders"));
tabs->addTab(widgetBackground, tr("Back&ground"));
tabs->addTab(widgetFont, tr("&Font"));
tabs->addTab(widgetAlignment, tr("&Alignment"));
fontDB.loadRenderers();
changedFont=changedAlign=changedBrush=FALSE;
// Borders tab
borderEditor=new BorderEditor(widgetBorders);
borderEditor->setGeometry(10, 10, 215, 145);
connect(borderEditor, SIGNAL(clicked(BorderEditor::BorderArea)), this, SLOT(borderClicked(BorderEditor::BorderArea)));
comboBordersWidth=createCombo(COMBO_WIDTH, widgetBorders, tr("&Width:"), 165);
comboBordersColor=createCombo(COMBO_COLOR, widgetBorders, tr("&Color:"), 165+(COMBO_HEIGHTS+10));
buttonBordersDefaults=new QPushButton(tr("&Default Borders"), widgetBorders);
buttonBordersDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonBordersDefaults, SIGNAL(clicked()), this, SLOT(slotBordersDefaults()));
// Background tab
frameBackground=new QFrame(widgetBackground);
frameBackground->setGeometry(10, 10, 215, 145);
frameBackground->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboBackgroundStyle=createCombo(COMBO_STYLE, widgetBackground, tr("&Style:"), 165);
connect(comboBackgroundStyle, SIGNAL(activated(int)), this, SLOT(backgroundClicked(int)));
comboBackgroundColor=createCombo(COMBO_COLOR, widgetBackground, tr("&Color:"), 165+(COMBO_HEIGHTS+10));
connect(comboBackgroundColor, SIGNAL(activated(int)), this, SLOT(backgroundClicked(int)));
buttonBackgroundDefaults=new QPushButton(tr("&Default Background"), widgetBackground);
buttonBackgroundDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonBackgroundDefaults, SIGNAL(clicked()), this, SLOT(slotBackgroundDefaults()));
// Font tab
frameFont=new QFrame(widgetFont);
frameFont->setGeometry(10, 10, 215, 125);
frameFont->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboFontFamily=createCombo(COMBO_FONT, widgetFont, tr("&Font:"), 145);
connect(comboFontFamily, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
comboFontSize=createCombo(COMBO_SIZE, widgetFont, tr("&Size:"), 145+(COMBO_HEIGHTS+10));
connect(comboFontSize, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
comboFontColor=createCombo(COMBO_COLOR, widgetFont, tr("&Color:"), 145+2*(COMBO_HEIGHTS+10));
connect(comboFontColor, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
checkFontBold=new QCheckBox(tr("&Bold"), widgetFont);
checkFontBold->setGeometry(10, 145+3*(COMBO_HEIGHTS+10), 40, COMBO_HEIGHTS);
connect(checkFontBold, SIGNAL(toggled(bool)), this, SLOT(fontClicked(bool)));
checkFontItalic=new QCheckBox(tr("&Italic"), widgetFont);
checkFontItalic->setGeometry(60, 145+3*(COMBO_HEIGHTS+10), 40, COMBO_HEIGHTS);
connect(checkFontItalic, SIGNAL(toggled(bool)), this, SLOT(fontClicked(bool)));
buttonFontDefaults=new QPushButton(tr("&Default Font"), widgetFont);
buttonFontDefaults->setGeometry(115, 145+3*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonFontDefaults, SIGNAL(clicked()), this, SLOT(slotFontDefaults()));
// Alignment tab
frameAlignment=new QFrame(widgetAlignment);
frameAlignment->setGeometry(10, 10, 215, 145);
frameAlignment->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboAlignmentVertical=createCombo(COMBO_VALIGN, widgetAlignment, tr("&Vertical:"), 165);
connect(comboAlignmentVertical, SIGNAL(activated(int)), this, SLOT(alignClicked(int)));
comboAlignmentHorizontal=createCombo(COMBO_HALIGN, widgetAlignment, tr("&Horizontal:"), 165+(COMBO_HEIGHTS+10));
connect(comboAlignmentHorizontal, SIGNAL(activated(int)), this, SLOT(alignClicked(int)));
checkAlignmentWrap=new QCheckBox(tr("&Word Wrap"), widgetAlignment);
checkAlignmentWrap->setGeometry(10, 165+2*(COMBO_HEIGHTS+10), 90, COMBO_HEIGHTS);
connect(checkAlignmentWrap, SIGNAL(toggled(bool)), this, SLOT(alignClicked(bool)));
buttonAlignmentDefaults=new QPushButton(tr("&Default Alignment"), widgetAlignment);
buttonAlignmentDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonAlignmentDefaults, SIGNAL(clicked()), this, SLOT(slotAlignmentDefaults()));
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Format Cells"));
}
CellFormat::~CellFormat()
{
}
int CellFormat::findColorIndex(const QColor &color)
{
for (int i=0; i<COLOR_COUNT; ++i)
if (qtColors[i]==color)
return i;
return 0;
}
int CellFormat::findVAlignIndex(Qt::AlignmentFlags flag)
{
for (int i=0; i<VALIGN_COUNT; ++i)
if (flagsVAlign[i] & flag)
return i;
return 0;
}
int CellFormat::findHAlignIndex(Qt::AlignmentFlags flag)
{
for (int i=0; i<HALIGN_COUNT; ++i)
if (flagsHAlign[i] & flag)
return i;
return 0;
}
int CellFormat::findBrushStyleIndex(Qt::BrushStyle style)
{
for (int i=0; i<STYLE_COUNT; ++i)
if (brushStyles[i]==style)
return i;
return 0;
}
void CellFormat::setBrushBackground(const QBrush &brush)
{
comboBackgroundColor->setCurrentItem(findColorIndex(brush.color()));
comboBackgroundStyle->setCurrentItem(findBrushStyleIndex(brush.style()));
QPixmap pix(frameBackground->contentsRect().width(), frameBackground->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), brush);
frameBackground->setBackgroundPixmap(pix);
brushBackground=brush;
}
void CellFormat::setTextFont(const QFont &font, const QColor &color)
{
comboFontColor->setCurrentItem(findColorIndex(color));
comboFontFamily->setCurrentItem(findComboItemIndex(comboFontFamily, font.family()));
comboFontSize->setCurrentItem(findComboItemIndex(comboFontSize, QString::number(font.pointSize())));
checkFontBold->setChecked(font.weight()==QFont::Bold);
checkFontItalic->setChecked(font.italic());
QPixmap pix(frameFont->contentsRect().width(), frameFont->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), Qt::white);
p.setFont(font);
p.setPen(color);
p.drawText(pix.rect(), Qt::AlignCenter, tr("Opie Sheet"));
frameFont->setBackgroundPixmap(pix);
fontFont=font;
fontColor=color;
}
void CellFormat::setTextAlign(Qt::AlignmentFlags flags)
{
comboAlignmentVertical->setCurrentItem(findVAlignIndex(flags));
comboAlignmentHorizontal->setCurrentItem(findHAlignIndex(flags));
checkAlignmentWrap->setChecked(flags & Qt::WordBreak);
QPixmap pix(frameAlignment->contentsRect().width(), frameAlignment->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), Qt::white);
p.drawText(10, 10, pix.width()-20, pix.height()-20, flags, tr("Opie Sheet"));
frameAlignment->setBackgroundPixmap(pix);
textAlignment=flags;
}
void CellFormat::slotFontDefaults()
{
changedFont=TRUE;
setTextFont(font(), Qt::black);
}
void CellFormat::slotAlignmentDefaults()
{
changedAlign=TRUE;
setTextAlign((Qt::AlignmentFlags)(Qt::AlignLeft | Qt::AlignTop));
}
void CellFormat::slotBackgroundDefaults()
{
changedBrush=TRUE;
setBrushBackground(Qt::white);
}
void CellFormat::slotBordersDefaults()
{
QPen defaultPen(Qt::gray, 1, Qt::SolidLine);
borderEditor->setPen(defaultPen, BorderEditor::Top);
borderEditor->setPen(defaultPen, BorderEditor::Bottom);
borderEditor->setPen(defaultPen, BorderEditor::Left);
borderEditor->setPen(defaultPen, BorderEditor::Right);
borderEditor->setPen(defaultPen, BorderEditor::Vert);
borderEditor->setPen(defaultPen, BorderEditor::Horz);
}
void CellFormat::backgroundClicked(int index)
{
changedBrush=TRUE;
setBrushBackground(QBrush(qtColors[comboBackgroundColor->currentItem()], brushStyles[comboBackgroundStyle->currentItem()]));
}
void CellFormat::fontClicked(bool on)
{
fontClicked(0);
}
void CellFormat::fontClicked(int index)
{
changedFont=TRUE;
setTextFont(QFont(comboFontFamily->currentText(), comboFontSize->currentText().toInt(), checkFontBold->isChecked() ? QFont::Bold : QFont::Normal, checkFontItalic->isChecked(), QFont::AnyCharSet), qtColors[comboFontColor->currentItem()]);
}
void CellFormat::alignClicked(bool on)
{
alignClicked(0);
}
void CellFormat::alignClicked(int index)
{
changedAlign=TRUE;
setTextAlign((Qt::AlignmentFlags)(flagsVAlign[comboAlignmentVertical->currentItem()] | flagsHAlign[comboAlignmentHorizontal->currentItem()] | (checkAlignmentWrap->isChecked() ? Qt::WordBreak : 0)));
}
void CellFormat::createSizeCombo(QComboBox *combo)
{
combo->clear();
QValueList<int> sizes=fontDB.standardSizes();
for (QValueList<int>::ConstIterator i=sizes.begin(); i!=sizes.end(); ++i)
combo->insertItem(QString::number(*i));
}
void CellFormat::borderClicked(BorderEditor::BorderArea area)
{
QPen newPen(qtColors[comboBordersColor->currentItem()], comboBordersWidth->currentItem()+1, Qt::SolidLine);
if (newPen==borderEditor->getPen(area))
borderEditor->setPen(QPen(Qt::gray, 1, Qt::NoPen), area);
else
borderEditor->setPen(newPen, area);
}
int CellFormat::findComboItemIndex(QComboBox *combo, const QString &item)
{
for (int i=0; i<combo->count(); ++i)
if (combo->text(i)==item)
return i;
return 0;
}
QComboBox *CellFormat::createCombo(comboType type, QWidget *parent, const QString &caption, int y)
{
QComboBox *combo=new QComboBox(FALSE, parent);
combo->setGeometry(70, y, COMBO_WIDTHS, COMBO_HEIGHTS);
combo->setSizeLimit(5);
switch (type)
{
case COMBO_WIDTH: createWidthCombo(combo); break;
case COMBO_STYLE: createStyleCombo(combo); break;
case COMBO_FONT: createFontCombo(combo); break;
case COMBO_SIZE: createSizeCombo(combo); break;
case COMBO_COLOR: createColorCombo(combo); break;
case COMBO_HALIGN: createHAlignCombo(combo); break;
case COMBO_VALIGN: createVAlignCombo(combo); break;
}
QLabel *label=new QLabel(combo, caption, parent);
label->setGeometry(10, y, 50, COMBO_HEIGHTS);
return combo;
}
void CellFormat::createHAlignCombo(QComboBox *combo)
{
for (int i=0; i<HALIGN_COUNT; ++i)
combo->insertItem(namesHAlign[i]);
}
void CellFormat::createVAlignCombo(QComboBox *combo)
{
for (int i=0; i<VALIGN_COUNT; ++i)
combo->insertItem(namesVAlign[i]);
}
void CellFormat::createWidthCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=1; i<=6; ++i)
{
pix.fill();
p.setPen(QPen(Qt::black, i, Qt::SolidLine));
p.drawLine(5, COMBO_HEIGHTS/2, width-10, COMBO_HEIGHTS/2);
combo->insertItem(pix);
}
}
void CellFormat::createFontCombo(QComboBox *combo)
{
combo->insertStringList(fontDB.families());
}
void CellFormat::createStyleCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=0; i<STYLE_COUNT; ++i)
{
pix.fill();
p.fillRect(5, 5, width-10, COMBO_HEIGHTS-10, brushStyles[i]);
combo->insertItem(pix);
}
}
void CellFormat::createColorCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=0; i<COLOR_COUNT; ++i)
{
pix.fill();
p.setPen(QPen(qtColors[i], 3, Qt::SolidLine));
p.drawLine(5, COMBO_HEIGHTS/2, width-10, COMBO_HEIGHTS/2);
combo->insertItem(pix);
}
}
int CellFormat::exec(Sheet *s)
{
sheet=s;
int row1, row2, col1, col2, row, col;
sheet->getSelection(&row1, &col1, &row2, &col2);
QPen penTop=sheet->getPen(row1-1, col1, 0), penBottom=sheet->getPen(row2, col1, 0),
penLeft=sheet->getPen(row1, col1-1, 1), penRight=sheet->getPen(row1, col2, 1),
penVert=sheet->getPen(row1, col1, 1), penHorz=sheet->getPen(row1, col1, 0),
penDefault=borderEditor->getDefaultPen();
for (row=row1+1; row<=row2; ++row)
if (sheet->getPen(row, col1-1, 1)!=penLeft)
{
penLeft=penDefault;
break;
}
for (row=row1+1; row<=row2; ++row)
if (sheet->getPen(row, col2, 1)!=penRight)
{
penRight=penDefault;
break;
}
for (col=col1+1; col<=col2; ++col)
if (sheet->getPen(row1-1, col, 0)!=penTop)
{
penTop=penDefault;
break;
}
for (col=col1+1; col<=col2; ++col)
if (sheet->getPen(row2, col, 0)!=penBottom)
{
penBottom=penDefault;
break;
}
for (row=row1; row<=row2; ++row)
for (col=col1; col<col2; ++col)
if (sheet->getPen(row, col, 1)!=penVert)
{
penVert=penDefault;
break;
}
for (row=row1; row<row2; ++row)
for (col=col1; col<=col2; ++col)
if (sheet->getPen(row, col, 0)!=penHorz)
{
penHorz=penDefault;
break;
}
borderEditor->setPen(penTop, BorderEditor::Top);
borderEditor->setPen(penBottom, BorderEditor::Bottom);
borderEditor->setPen(penLeft, BorderEditor::Left);
borderEditor->setPen(penRight, BorderEditor::Right);
borderEditor->setPen(penVert, BorderEditor::Vert);
borderEditor->setPen(penHorz, BorderEditor::Horz);
setBrushBackground(sheet->getBrush(row1, col1));
setTextFont(sheet->getFont(row1, col1), sheet->getFontColor(row1, col1));
setTextAlign(sheet->getAlignment(row1, col1));
if (QDialog::exec()==QDialog::Accepted)
{
penTop=borderEditor->getPen(BorderEditor::Top);
penBottom=borderEditor->getPen(BorderEditor::Bottom);
penLeft=borderEditor->getPen(BorderEditor::Left);
penRight=borderEditor->getPen(BorderEditor::Right);
penVert=borderEditor->getPen(BorderEditor::Vert);
penHorz=borderEditor->getPen(BorderEditor::Horz);
if (penTop!=penDefault)
for (col=col1; col<=col2; ++col)
sheet->setPen(row1-1, col, 0, penTop);
if (penBottom!=penDefault)
for (col=col1; col<=col2; ++col)
sheet->setPen(row2, col, 0, penBottom);
if (penLeft!=penDefault)
for (row=row1; row<=row2; ++row)
sheet->setPen(row, col1-1, 1, penLeft);
if (penRight!=penDefault)
for (row=row1; row<=row2; ++row)
sheet->setPen(row, col2, 1, penRight);
if (penVert!=penDefault)
for (row=row1; row<=row2; ++row)
for (col=col1; col<col2; ++col)
sheet->setPen(row, col, 1, penVert);
if (penHorz!=penDefault)
for (row=row1; row<row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setPen(row, col, 0, penHorz);
if (changedBrush)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setBrush(row, col, brushBackground);
}
if (changedAlign)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setTextAlign(row, col, textAlignment);
}
if (changedFont)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setTextFont(row, col, fontFont, fontColor);
}
return QDialog::Accepted;
}
return QDialog::Rejected;
}
//
// Border Editor
//
BorderEditor::BorderEditor(QWidget *parent=0)
:QFrame(parent)
{
setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
}
BorderEditor::~BorderEditor()
{
}
void BorderEditor::drawContents(QPainter *p)
{
QFrame::drawContents(p);
int x=contentsRect().x(), y=contentsRect().y(), width=contentsRect().width()/3, height=contentsRect().height()/3;
int lineFirstX=x+width/6, lineFirstY=y+height/6, lineLastX=contentsRect().right()-width/6, lineLastY=contentsRect().bottom()-height/6;
p->fillRect(contentsRect(), Qt::white);
p->fillRect(x+width/3, y+height/3, width, height, Qt::gray);
p->fillRect(x+(5*width/3), y+height/3, width, height, Qt::gray);
p->fillRect(x+width/3, y+(5*height)/3, width, height, Qt::gray);
p->fillRect(x+(5*width)/3, y+(5*height)/3, width, height, Qt::gray);
if (penTop.width()>0)
{
p->setPen(penTop);
p->drawLine(lineFirstX, lineFirstY, lineLastX, lineFirstY);
}
diff --git a/noncore/apps/opie-sheet/cellformat.h b/noncore/apps/opie-sheet/cellformat.h
index b552153..b569b7f 100644
--- a/noncore/apps/opie-sheet/cellformat.h
+++ b/noncore/apps/opie-sheet/cellformat.h
@@ -1,106 +1,120 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef CELLFORMAT_H
#define CELLFORMAT_H
#include <qpe/fontdatabase.h>
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qcombobox.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
#include "sheet.h"
class BorderEditor: public QFrame
{
Q_OBJECT
// QT objects
QPen penTop, penBottom, penLeft, penRight, penHorz, penVert;
// Private functions
void drawContents(QPainter *p);
// Reimplemented QFrame functions
void mouseReleaseEvent(QMouseEvent *e);
public:
// Definitions
enum BorderArea {None, Top, Bottom, Left, Right, Horz, Vert};
BorderEditor(QWidget *parent=0);
~BorderEditor();
void setPen(const QPen &pen, BorderArea area);
QPen getPen(BorderArea area);
QPen getDefaultPen() { return QPen(Qt::black, 1, Qt::DotLine); }
signals:
void clicked(BorderEditor::BorderArea);
};
class CellFormat: public QDialog
{
Q_OBJECT
enum comboType {COMBO_OTHER, COMBO_WIDTH, COMBO_FONT, COMBO_SIZE, COMBO_STYLE, COMBO_COLOR, COMBO_VALIGN, COMBO_HALIGN};
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetBorders, *widgetBackground, *widgetFont, *widgetAlignment;
QComboBox *comboBordersWidth, *comboBordersColor, *comboBackgroundColor, *comboBackgroundStyle, *comboFontColor, *comboFontSize, *comboFontFamily, *comboAlignmentVertical, *comboAlignmentHorizontal;
QCheckBox *checkFontBold, *checkFontItalic, *checkAlignmentWrap;
QPushButton *buttonBordersDefaults, *buttonBackgroundDefaults, *buttonFontDefaults, *buttonAlignmentDefaults;
QFrame *frameBackground, *frameFont, *frameAlignment;
QBrush brushBackground;
QFont fontFont;
QColor fontColor;
Qt::AlignmentFlags textAlignment;
FontDatabase fontDB;
// Other objects & variables
Sheet *sheet;
BorderEditor *borderEditor;
bool changedFont, changedAlign, changedBrush;
// Private functions
void createWidthCombo(QComboBox *combo);
void createFontCombo(QComboBox *combo);
void createHAlignCombo(QComboBox *combo);
void createVAlignCombo(QComboBox *combo);
void createStyleCombo(QComboBox *combo);
void createSizeCombo(QComboBox *combo);
void createColorCombo(QComboBox *combo);
QComboBox *createCombo(comboType type, QWidget *parent, const QString &caption, int y);
int findHAlignIndex(Qt::AlignmentFlags flag);
int findVAlignIndex(Qt::AlignmentFlags flag);
int findComboItemIndex(QComboBox *combo, const QString &item);
int findColorIndex(const QColor &color);
int findBrushStyleIndex(Qt::BrushStyle style);
private slots:
void borderClicked(BorderEditor::BorderArea area);
void backgroundClicked(int index);
void fontClicked(bool on);
void fontClicked(int index);
void alignClicked(bool on);
void alignClicked(int index);
void slotBordersDefaults();
void slotBackgroundDefaults();
void slotFontDefaults();
void slotAlignmentDefaults();
public:
CellFormat(QWidget *parent=0);
~CellFormat();
int exec(Sheet *s);
void setTextAlign(Qt::AlignmentFlags flags);
void setTextFont(const QFont &font, const QColor &color);
void setBrushBackground(const QBrush &brush);
};
#endif
diff --git a/noncore/apps/opie-sheet/finddlg.cpp b/noncore/apps/opie-sheet/finddlg.cpp
index cfe2f82..d1237ca 100644
--- a/noncore/apps/opie-sheet/finddlg.cpp
+++ b/noncore/apps/opie-sheet/finddlg.cpp
@@ -1,70 +1,84 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include <qlabel.h>
#include <qradiobutton.h>
#include "finddlg.h"
FindDialog::FindDialog(QWidget *parent=0)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetFind=new QWidget(tabs);
widgetOptions=new QWidget(tabs);
tabs->addTab(widgetFind, tr("&Find && Replace"));
tabs->addTab(widgetOptions, tr("&Options"));
// Find tab
QLabel *label=new QLabel(tr("&Search for:"), widgetFind);
label->setGeometry(10, 10, 215, 20);
editFind=new QLineEdit(widgetFind);
editFind->setGeometry(10, 40, 215, 20);
label->setBuddy(editFind);
label=new QLabel(tr("&Replace with:"), widgetFind);
label->setGeometry(10, 80, 215, 20);
editReplace=new QLineEdit(widgetFind);
editReplace->setGeometry(10, 110, 215, 20);
editReplace->setEnabled(FALSE);
label->setBuddy(editReplace);
groupType=new QVButtonGroup(tr("&Type"), widgetFind);
groupType->setGeometry(10, 150, 215, 90);
QRadioButton *radio=new QRadioButton(tr("&Find"), groupType);
radio=new QRadioButton(tr("&Replace"), groupType);
radio=new QRadioButton(tr("Replace &all"), groupType);
groupType->setButton(0);
connect(groupType, SIGNAL(clicked(int)), this, SLOT(typeChanged(int)));
// Options tab
checkCase=new QCheckBox(tr("Match &case"), widgetOptions);
checkCase->setGeometry(10, 10, 215, 20);
checkSelection=new QCheckBox(tr("Current &selection only"), widgetOptions);
checkSelection->setGeometry(10, 40, 215, 20);
checkEntire=new QCheckBox(tr("&Entire cell"), widgetOptions);
checkEntire->setGeometry(10, 70, 215, 20);
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Find & Replace"));
}
FindDialog::~FindDialog()
{
}
void FindDialog::typeChanged(int id)
{
editReplace->setEnabled(id>0);
}
int FindDialog::exec(Sheet *s)
{
if (QDialog::exec()==QDialog::Accepted)
{
int id=groupType->id(groupType->selected());
s->dataFindReplace(editFind->text(), editReplace->text(), checkCase->isChecked(), !checkSelection->isChecked(), checkEntire->isChecked(), id>0, id>1);
return QDialog::Accepted;
}
return QDialog::Rejected;
}
diff --git a/noncore/apps/opie-sheet/finddlg.h b/noncore/apps/opie-sheet/finddlg.h
index 02c9cdd..1af2da5 100644
--- a/noncore/apps/opie-sheet/finddlg.h
+++ b/noncore/apps/opie-sheet/finddlg.h
@@ -1,35 +1,49 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef FINDDLG_H
#define FINDDLG_H
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qlineedit.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
#include <qvbuttongroup.h>
#include "sheet.h"
class FindDialog: public QDialog
{
Q_OBJECT
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetFind, *widgetOptions;
QCheckBox *checkCase, *checkSelection, *checkEntire;
QLineEdit *editFind, *editReplace;
QVButtonGroup *groupType;
private slots:
void typeChanged(int id);
public:
FindDialog(QWidget *parent=0);
~FindDialog();
int exec(Sheet *s);
};
#endif
diff --git a/noncore/apps/opie-sheet/main.cpp b/noncore/apps/opie-sheet/main.cpp
index 236a579..e42b4a5 100644
--- a/noncore/apps/opie-sheet/main.cpp
+++ b/noncore/apps/opie-sheet/main.cpp
@@ -1,14 +1,28 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include <qpe/qpeapplication.h>
#include "mainwindow.h"
int main(int argc, char **argv)
{
QPEApplication application(argc, argv);
MainWindow windowMain;
windowMain.setHelpFile(application.qpeDir()+"/help/html/"+QString(argv[0])+".html");
application.showMainDocumentWidget(&windowMain);
return application.exec();
}
diff --git a/noncore/apps/opie-sheet/mainwindow.cpp b/noncore/apps/opie-sheet/mainwindow.cpp
index a7441b1..9d69b8a 100644
--- a/noncore/apps/opie-sheet/mainwindow.cpp
+++ b/noncore/apps/opie-sheet/mainwindow.cpp
@@ -1,512 +1,526 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include "mainwindow.h"
#include <qpe/filemanager.h>
#include <qpe/qcopenvelope_qws.h>
#include <qmessagebox.h>
#include <qfile.h>
#include <qradiobutton.h>
#include "cellformat.h"
#include "numberdlg.h"
#include "textdlg.h"
#include "sortdlg.h"
#include "finddlg.h"
#include "file-new.xpm"
#include "file-open.xpm"
#include "file-save.xpm"
#include "edit-cancel.xpm"
#include "edit-accept.xpm"
#include "help-general.xpm"
#include "func-plus.xpm"
#include "func-minus.xpm"
#include "func-cross.xpm"
#include "func-divide.xpm"
#include "func-paran-open.xpm"
#include "func-paran-close.xpm"
#include "func-comma.xpm"
#include "func-func.xpm"
#include "func-equal.xpm"
#include "cell-select.xpm"
#define DEFAULT_NUM_ROWS 199
#define DEFAULT_NUM_COLS (26*3)
#define DEFAULT_NUM_SHEETS 3
MainWindow::MainWindow()
:QMainWindow()
{
// initialize variables
documentModified=FALSE;
// construct objects
fileSelector=new FileSelector("application/sheet-qt", this, QString::null);
connect(fileSelector, SIGNAL(closeMe()), this, SLOT(selectorHide()));
connect(fileSelector, SIGNAL(newSelected(const DocLnk &)), this, SLOT(selectorFileNew(const DocLnk &)));
connect(fileSelector, SIGNAL(fileSelected(const DocLnk &)), this, SLOT(selectorFileOpen(const DocLnk &)));
listSheets.setAutoDelete(TRUE);
initActions();
initMenu();
initEditToolbar();
initFunctionsToolbar();
initStandardToolbar();
initSheet();
// set window title
setCaption(tr("Opie Sheet"));
// create sheets
selectorFileNew(currentDoc);
}
MainWindow::~MainWindow()
{
}
void MainWindow::documentSave(DocLnk &lnkDoc)
{
FileManager fm;
QByteArray streamBuffer;
QDataStream stream(streamBuffer, IO_WriteOnly);
typeSheet *currentSheet=findSheet(sheet->getName());
if (!currentSheet)
{
QMessageBox::critical(this, tr("Error"), tr("Inconsistency error!"));
return;
}
sheet->copySheetData(&currentSheet->data);
stream.writeRawBytes("SQT100", 6);
stream << (Q_UINT32)listSheets.count();
for (typeSheet *tempSheet=listSheets.first(); tempSheet; tempSheet=listSheets.next())
{
stream << tempSheet->name << (Q_UINT32)tempSheet->data.count();
for (typeCellData *tempCell=tempSheet->data.first(); tempCell; tempCell=tempSheet->data.next())
stream << (Q_UINT32)tempCell->col << (Q_UINT32)tempCell->row << tempCell->borders.right << tempCell->borders.bottom << tempCell->background << (Q_UINT32)tempCell->alignment << tempCell->fontColor << tempCell->font << tempCell->data;
}
lnkDoc.setType("application/sheet-qt");
if (!fm.saveFile(lnkDoc, streamBuffer))
{
QMessageBox::critical(this, tr("Error"), tr("File cannot be saved!"));
return;
}
documentModified=FALSE;
}
void MainWindow::documentOpen(const DocLnk &lnkDoc)
{
FileManager fm;
QByteArray streamBuffer;
if (!lnkDoc.isValid() || !fm.loadFile(lnkDoc, streamBuffer))
{
QMessageBox::critical(this, tr("Error"), tr("File cannot be opened!"));
documentModified=FALSE;
selectorFileNew(DocLnk());
return;
}
QDataStream stream(streamBuffer, IO_ReadOnly);
Q_UINT32 countSheet, countCell, i, j, row, col, alignment;
typeSheet *newSheet;
typeCellData *newCell;
char fileFormat[7];
stream.readRawBytes(fileFormat, 6);
fileFormat[6]=0;
if ((QString)fileFormat!="SQT100")
{
QMessageBox::critical(this, tr("Error"), tr("Invalid file format!"));
documentModified=FALSE;
selectorFileNew(DocLnk());
return;
}
stream >> countSheet;
for (i=0; i<countSheet; ++i)
{
newSheet=new typeSheet;
newSheet->data.setAutoDelete(TRUE);
stream >> newSheet->name >> countCell;
comboSheets->insertItem(newSheet->name);
for (j=0; j<countCell; ++j)
{
newCell=new typeCellData;
stream >> col >> row >> newCell->borders.right >> newCell->borders.bottom >> newCell->background >> alignment >> newCell->fontColor >> newCell->font >> newCell->data;
newCell->col=col;
newCell->row=row;
newCell->alignment=(Qt::AlignmentFlags)alignment;
newSheet->data.append(newCell);
}
listSheets.append(newSheet);
if (i==0)
{
sheet->setName(newSheet->name);
sheet->setSheetData(&newSheet->data);
}
}
}
int MainWindow::saveCurrentFile(bool ask=TRUE)
{
if (ask)
{
int result=QMessageBox::information(this, tr("Save File"), tr("Do you want to save the current file?"), QMessageBox::Yes, QMessageBox::No, QMessageBox::Cancel);
if (result!=QMessageBox::Yes) return result;
}
if (currentDoc.name().isEmpty() || !currentDoc.isValid())
{
TextDialog dialogText(this);
if (dialogText.exec(tr("Save File"), tr("&File Name:"), tr("UnnamedFile"))!=QDialog::Accepted || dialogText.getValue().isEmpty()) return QMessageBox::Cancel;
currentDoc.setName(dialogText.getValue());
}
documentSave(currentDoc);
return QMessageBox::Yes;
}
void MainWindow::copyDocLnk(const DocLnk &source, DocLnk &target)
{
target.setName(source.name());
target.setFile(source.file());
target.setLinkFile(source.linkFile());
target.setComment(source.comment());
target.setType(source.type());
target.setCategories(source.categories());
}
void MainWindow::selectorFileNew(const DocLnk &lnkDoc)
{
selectorHide();
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) return;
copyDocLnk(lnkDoc, currentDoc);
listSheets.clear();
comboSheets->clear();
typeSheet *newSheet=createNewSheet();
newSheet->data.setAutoDelete(TRUE);
sheet->setName(newSheet->name);
sheet->setSheetData(&newSheet->data);
for (int i=1; i<DEFAULT_NUM_SHEETS; ++i)
createNewSheet();
documentModified=FALSE;
}
void MainWindow::closeEvent(QCloseEvent *e)
{
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) e->ignore();
else e->accept();
}
void MainWindow::selectorFileOpen(const DocLnk &lnkDoc)
{
selectorHide();
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) return;
copyDocLnk(lnkDoc, currentDoc);
listSheets.clear();
comboSheets->clear();
documentOpen(lnkDoc);
documentModified=FALSE;
}
void MainWindow::selectorShow()
{
sheet->hide();
setCentralWidget(fileSelector);
fileSelector->show();
fileSelector->reread();
}
void MainWindow::selectorHide()
{
fileSelector->hide();
setCentralWidget(sheet);
sheet->show();
}
void MainWindow::slotFileNew()
{
selectorFileNew(DocLnk());
}
void MainWindow::slotFileOpen()
{
selectorShow();
}
void MainWindow::slotFileSave()
{
saveCurrentFile(FALSE);
}
void MainWindow::setDocument(const QString &applnk_filename)
{
selectorFileOpen(DocLnk(applnk_filename));
}
void MainWindow::initActions()
{
fileNew=new QAction(tr("New File"), QPixmap(file_new_xpm), tr("&New"), 0, this);
connect(fileNew, SIGNAL(activated()), this, SLOT(slotFileNew()));
fileOpen=new QAction(tr("Open File"), QPixmap(file_open_xpm), tr("&Open"), 0, this);
connect(fileOpen, SIGNAL(activated()), this, SLOT(slotFileOpen()));
fileSave=new QAction(tr("Save File"), QPixmap(file_save_xpm), tr("&Save"), 0, this);
connect(fileSave, SIGNAL(activated()), this, SLOT(slotFileSave()));
fileSaveAs=new QAction(tr("Save File As"), QPixmap(file_save_xpm), tr("Save &As"), 0, this);
connect(fileSaveAs, SIGNAL(activated()), this, SLOT(slotFileSaveAs()));
fileQuit=new QAction(tr("Quit"), tr("&Quit"), 0, this);
connect(fileQuit, SIGNAL(activated()), this, SLOT(close()));
helpGeneral=new QAction(tr("General Help"), QPixmap(help_general_xpm), tr("&General"), 0, this);
connect(helpGeneral, SIGNAL(activated()), this, SLOT(slotHelpGeneral()));
helpAbout=new QAction(tr("About Opie Sheet"), tr("&About"), 0, this);
connect(helpAbout, SIGNAL(activated()), this, SLOT(slotHelpAbout()));
editAccept=new QAction(tr("Accept"), QPixmap(edit_accept_xpm), tr("&Accept"), 0, this);
connect(editAccept, SIGNAL(activated()), this, SLOT(slotEditAccept()));
editCancel=new QAction(tr("Cancel"), QPixmap(edit_cancel_xpm), tr("&Cancel"), 0, this);
connect(editCancel, SIGNAL(activated()), this, SLOT(slotEditCancel()));
editCellSelect=new QAction(tr("Cell Selector"), QPixmap(cell_select_xpm), tr("Cell &Selector"), 0, this);
editCellSelect->setToggleAction(TRUE);
connect(editCellSelect, SIGNAL(toggled(bool)), this, SLOT(slotCellSelect(bool)));
editCut=new QAction(tr("Cut Cells"), tr("Cu&t"), 0, this);
editCopy=new QAction(tr("Copy Cells"), tr("&Copy"), 0, this);
editPaste=new QAction(tr("Paste Cells"), tr("&Paste"), 0, this);
connect(editPaste, SIGNAL(activated()), this, SLOT(slotEditPaste()));
editPasteContents=new QAction(tr("Paste Contents"), tr("Paste Cont&ents"), 0, this);
connect(editPasteContents, SIGNAL(activated()), this, SLOT(slotEditPasteContents()));
editClear=new QAction(tr("Clear Cells"), tr("C&lear"), 0, this);
insertCells=new QAction(tr("Insert Cells"), tr("C&ells"), 0, this);
connect(insertCells, SIGNAL(activated()), this, SLOT(slotInsertCells()));
insertRows=new QAction(tr("Insert Rows"), tr("&Rows"), 0, this);
connect(insertRows, SIGNAL(activated()), this, SLOT(slotInsertRows()));
insertCols=new QAction(tr("Insert Columns"), tr("&Columns"), 0, this);
connect(insertCols, SIGNAL(activated()), this, SLOT(slotInsertCols()));
insertSheets=new QAction(tr("Add Sheets"), tr("&Sheets"), 0, this);
connect(insertSheets, SIGNAL(activated()), this, SLOT(slotInsertSheets()));
formatCells=new QAction(tr("Cells"), tr("&Cells"), 0, this);
connect(formatCells, SIGNAL(activated()), this, SLOT(slotFormatCells()));
rowHeight=new QAction(tr("Row Height"), tr("H&eight"), 0, this);
connect(rowHeight, SIGNAL(activated()), this, SLOT(slotRowHeight()));
rowAdjust=new QAction(tr("Adjust Row"), tr("&Adjust"), 0, this);
connect(rowAdjust, SIGNAL(activated()), this, SLOT(slotRowAdjust()));
rowShow=new QAction(tr("Show Row"), tr("&Show"), 0, this);
connect(rowShow, SIGNAL(activated()), this, SLOT(slotRowShow()));
rowHide=new QAction(tr("Hide Row"), tr("&Hide"), 0, this);
connect(rowHide, SIGNAL(activated()), this, SLOT(slotRowHide()));
colWidth=new QAction(tr("Column Width"), tr("&Width"), 0, this);
connect(colWidth, SIGNAL(activated()), this, SLOT(slotColumnWidth()));
colAdjust=new QAction(tr("Adjust Column"), tr("&Adjust"), 0, this);
connect(colAdjust, SIGNAL(activated()), this, SLOT(slotColumnAdjust()));
colShow=new QAction(tr("Show Column"), tr("&Show"), 0, this);
connect(colShow, SIGNAL(activated()), this, SLOT(slotColumnShow()));
colHide=new QAction(tr("Hide Column"), tr("&Hide"), 0, this);
connect(colHide, SIGNAL(activated()), this, SLOT(slotColumnHide()));
sheetRename=new QAction(tr("Rename Sheet"), tr("&Rename"), 0, this);
connect(sheetRename, SIGNAL(activated()), this, SLOT(slotSheetRename()));
sheetRemove=new QAction(tr("Remove Sheet"), tr("R&emove"), 0, this);
connect(sheetRemove, SIGNAL(activated()), this, SLOT(slotSheetRemove()));
dataSort=new QAction(tr("Sort Data"), tr("&Sort"), 0, this);
connect(dataSort, SIGNAL(activated()), this, SLOT(slotDataSort()));
dataFindReplace=new QAction(tr("Find && Replace"), tr("&Find && Replace"), 0, this);
connect(dataFindReplace, SIGNAL(activated()), this, SLOT(slotDataFindReplace()));
funcEqual=new QAction(tr("Equal To"), QPixmap(func_equal_xpm), tr("&Equal To"), 0, this);
funcEqual->setToolTip("=");
connect(funcEqual, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcPlus=new QAction(tr("Addition"), QPixmap(func_plus_xpm), tr("&Addition"), 0, this);
funcPlus->setToolTip("+");
connect(funcPlus, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcMinus=new QAction(tr("Subtraction"), QPixmap(func_minus_xpm), tr("&Subtraction"), 0, this);
funcMinus->setToolTip("-");
connect(funcMinus, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcCross=new QAction(tr("Multiplication"), QPixmap(func_cross_xpm), tr("&Multiplication"), 0, this);
funcCross->setToolTip("*");
connect(funcCross, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcDivide=new QAction(tr("Division"), QPixmap(func_divide_xpm), tr("&Division"), 0, this);
funcDivide->setToolTip("/");
connect(funcDivide, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcParanOpen=new QAction(tr("Open ParanthesistempCellData->row+row1, tempCellData->col+col1"), QPixmap(func_paran_open_xpm), tr("&Open Paranthesis"), 0, this);
funcParanOpen->setToolTip("(");
connect(funcParanOpen, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcParanClose=new QAction(tr("Close Paranthesis"), QPixmap(func_paran_close_xpm), tr("&Close Paranthesis"), 0, this);
funcParanClose->setToolTip(")");
connect(funcParanClose, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
funcComma=new QAction(tr("Comma"), QPixmap(func_comma_xpm), tr("&Comma"), 0, this);
funcComma->setToolTip(",");
connect(funcComma, SIGNAL(activated()), this, SLOT(slotFuncOutput()));
}
void MainWindow::initMenu()
{
menu=new QPEMenuBar(this);
menuFile=new QPopupMenu;
fileNew->addTo(menuFile);
fileOpen->addTo(menuFile);
fileSave->addTo(menuFile);
fileSaveAs->addTo(menuFile);
menuFile->insertSeparator();
fileQuit->addTo(menuFile);
menu->insertItem(tr("&File"), menuFile);
menuEdit=new QPopupMenu;
editAccept->addTo(menuEdit);
editCancel->addTo(menuEdit);
editCellSelect->addTo(menuEdit);
menuEdit->insertSeparator();
editCut->addTo(menuEdit);
editCopy->addTo(menuEdit);
editPaste->addTo(menuEdit);
editPasteContents->addTo(menuEdit);
editClear->addTo(menuEdit);
menu->insertItem(tr("&Edit"), menuEdit);
menuInsert=new QPopupMenu;
menu->insertItem(tr("&Insert"), menuInsert);
menuFormat=new QPopupMenu;
formatCells->addTo(menuFormat);
menu->insertItem(tr("&Format"), menuFormat);
menuData=new QPopupMenu;
dataSort->addTo(menuData);
dataFindReplace->addTo(menuData);
menu->insertItem(tr("&Data"), menuData);
menuHelp=new QPopupMenu;
helpGeneral->addTo(menuHelp);
helpAbout->addTo(menuHelp);
menu->insertItem(tr("&Help"), menuHelp);
submenuRow=new QPopupMenu;
rowHeight->addTo(submenuRow);
rowAdjust->addTo(submenuRow);
rowShow->addTo(submenuRow);
rowHide->addTo(submenuRow);
menuFormat->insertItem(tr("&Row"), submenuRow);
submenuCol=new QPopupMenu;
colWidth->addTo(submenuCol);
colAdjust->addTo(submenuCol);
colShow->addTo(submenuCol);
colHide->addTo(submenuCol);
menuFormat->insertItem(tr("Colum&n"), submenuCol);
submenuSheet=new QPopupMenu;
sheetRename->addTo(submenuSheet);
sheetRemove->addTo(submenuSheet);
menuFormat->insertItem(tr("&Sheet"), submenuSheet);
submenuFunc=new QPopupMenu;
menuInsert->insertItem(tr("&Function"), submenuFunc);
submenuFuncStd=new QPopupMenu;
funcPlus->addTo(submenuFuncStd);
funcMinus->addTo(submenuFuncStd);
funcCross->addTo(submenuFuncStd);
funcDivide->addTo(submenuFuncStd);
submenuFunc->insertItem(tr("&Standard"), submenuFuncStd);
submenuFuncMath=new QPopupMenu;
addFlyAction(tr("Summation"), tr("&Summation"), "SUM(", submenuFuncMath);
addFlyAction(tr("Absolute Value"), tr("&Absolute"), "ABS(", submenuFuncMath);
submenuFuncMath->insertSeparator();
addFlyAction(tr("Sine"), tr("Si&ne"), "SIN(", submenuFuncMath);
addFlyAction(tr("Arc Sine"), tr("A&rc Sine"), "ASIN(", submenuFuncMath);
addFlyAction(tr("Cosine"), tr("&Cosine"), "COS(", submenuFuncMath);
addFlyAction(tr("ArcCosine"), tr("Arc Cos&ine"), "COS(", submenuFuncMath);
addFlyAction(tr("Tangent"), tr("&Tangent"), "TAN(", submenuFuncMath);
addFlyAction(tr("Arc Tangent"), tr("Arc Tan&gent"), "ATAN(", submenuFuncMath);
addFlyAction(tr("Arc Tangent of Coordinates"), tr("C&oor. Arc Tangent"), "ATAN2(", submenuFuncMath);
submenuFuncMath->insertSeparator();
addFlyAction(tr("Exponential"), tr("&Exponential"), "EXP(", submenuFuncMath);
addFlyAction(tr("Logarithm"), tr("&Logarithm"), "LOG(", submenuFuncMath);
addFlyAction(tr("Power"), tr("&Power"), "POW(", submenuFuncMath);
submenuFunc->insertItem(tr("&Mathematical"), submenuFuncMath);
submenuFuncStat=new QPopupMenu;
addFlyAction(tr("Average"), tr("&Average"), "AVG(", submenuFuncStat);
addFlyAction(tr("Maximum"), tr("Ma&ximum"), "MAX(", submenuFuncStat);
addFlyAction(tr("Minimum"), tr("&Minimum"), "MIN(", submenuFuncStat);
addFlyAction(tr("Count"), tr("&Count"), "COUNT(", submenuFuncStat);
submenuFunc->insertItem(tr("&Statistical"), submenuFuncStat);
menuInsert->insertSeparator();
insertCells->addTo(menuInsert);
insertRows->addTo(menuInsert);
insertCols->addTo(menuInsert);
insertSheets->addTo(menuInsert);
}
void MainWindow::initStandardToolbar()
{
toolbarStandard=new QPEToolBar(this);
toolbarStandard->setHorizontalStretchable(TRUE);
moveToolBar(toolbarStandard, Top);
fileNew->addTo(toolbarStandard);
fileOpen->addTo(toolbarStandard);
fileSave->addTo(toolbarStandard);
comboSheets=new QComboBox(toolbarStandard);
toolbarStandard->setStretchableWidget(comboSheets);
connect(comboSheets, SIGNAL(activated(const QString &)), this, SLOT(slotSheetChanged(const QString &)));
}
void MainWindow::initFunctionsToolbar()
{
toolbarFunctions=new QPEToolBar(this);
toolbarFunctions->setHorizontalStretchable(TRUE);
moveToolBar(toolbarFunctions, Bottom);
funcEqual->addTo(toolbarFunctions);
funcPlus->addTo(toolbarFunctions);
funcMinus->addTo(toolbarFunctions);
funcCross->addTo(toolbarFunctions);
funcDivide->addTo(toolbarFunctions);
funcParanOpen->addTo(toolbarFunctions);
funcParanClose->addTo(toolbarFunctions);
funcComma->addTo(toolbarFunctions);
toolFunction=new QToolButton(toolbarFunctions);
toolFunction->setPixmap(func_func_xpm);
toolFunction->setTextLabel(tr("Functions"));
toolFunction->setPopup(submenuFunc);
toolFunction->setPopupDelay(0);
}
void MainWindow::initEditToolbar()
{
toolbarEdit=new QPEToolBar(this);
toolbarEdit->setHorizontalStretchable(TRUE);
moveToolBar(toolbarEdit, Bottom);
editAccept->addTo(toolbarEdit);
editCancel->addTo(toolbarEdit);
editData=new QLineEdit(toolbarEdit);
toolbarEdit->setStretchableWidget(editData);
connect(editData, SIGNAL(returnPressed()), this, SLOT(slotEditAccept()));
editCellSelect->addTo(toolbarEdit);
}
void MainWindow::slotHelpGeneral()
{
if (QFile::exists(helpFile))
{
diff --git a/noncore/apps/opie-sheet/mainwindow.h b/noncore/apps/opie-sheet/mainwindow.h
index ac90504..554e6f6 100644
--- a/noncore/apps/opie-sheet/mainwindow.h
+++ b/noncore/apps/opie-sheet/mainwindow.h
@@ -1,120 +1,134 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <qpe/applnk.h>
#include <qpe/fileselector.h>
#include <qpe/qpemenubar.h>
#include <qpe/qpetoolbar.h>
#include <qmainwindow.h>
#include <qaction.h>
#include <qlineedit.h>
#include <qbutton.h>
#include <qcombobox.h>
#include <qtoolbutton.h>
#include "sheet.h"
typedef struct typeSheet
{
QString name;
QList<typeCellData> data;
};
class MainWindow: public QMainWindow
{
Q_OBJECT
// QPE objects
DocLnk currentDoc;
QPEMenuBar *menu;
QPEToolBar *toolbarFunctions, *toolbarEdit, *toolbarStandard;
FileSelector *fileSelector;
// QT objects
QPopupMenu *menuFile, *menuEdit, *menuInsert, *menuFormat, *menuData, *menuHelp,
*submenuFunc, *submenuFuncStd, *submenuFuncMath, *submenuFuncStat,
*submenuRow, *submenuCol, *submenuSheet;
QAction *fileNew, *fileOpen, *fileSave, *fileSaveAs, *fileQuit, *helpAbout, *editAccept, *editCancel, *formatCells,
*funcPlus, *funcMinus, *funcCross, *funcDivide, *funcParanOpen, *funcParanClose, *funcComma, *funcEqual,
*editCut, *editCopy, *editPaste, *editPasteContents, *editClear, *insertCols, *insertRows, *insertSheets, *insertCells,
*rowHeight, *rowShow, *rowHide, *rowAdjust, *colWidth, *colShow, *colHide, *colAdjust, *sheetRename, *sheetRemove,
*dataSort, *dataFindReplace, *editCellSelect, *helpGeneral;
QLineEdit *editData;
QButton *buttonUp, *buttonDown, *buttonLeft, *buttonRight;
QComboBox *comboSheets;
QToolButton *toolFunction;
QList<typeSheet> listSheets;
QString helpFile;
// Other objects
Sheet *sheet;
// Variables
bool documentModified;
// Private functions
void initMenu();
void initActions();
void initFunctionsToolbar();
void initEditToolbar();
void initStandardToolbar();
void initSheet();
void addToData(const QString &data);
int saveCurrentFile(bool ask=TRUE);
void documentOpen(const DocLnk &lnkDoc);
void copyDocLnk(const DocLnk &source, DocLnk &target);
void documentSave(DocLnk &lnkDoc);
void closeEvent(QCloseEvent *e);
void addFlyAction(const QString &text, const QString &menuText, const QString &tip, QWidget *w);
typeSheet *createNewSheet();
typeSheet *findSheet(const QString &name);
private slots:
void slotFileNew();
void slotFileOpen();
void slotFileSave();
void slotFileSaveAs();
void slotHelpAbout();
void slotHelpGeneral();
void slotEditAccept();
void slotEditCancel();
void slotEditPaste();
void slotEditPasteContents();
void slotFormatCells();
void slotInsertCells();
void slotInsertRows();
void slotInsertCols();
void slotInsertSheets();
void slotDataSort();
void slotDataFindReplace();
void slotRowHeight();
void slotRowAdjust();
void slotRowShow();
void slotRowHide();
void slotColumnWidth();
void slotColumnAdjust();
void slotColumnShow();
void slotColumnHide();
void slotSheetRename();
void slotSheetRemove();
void slotFuncOutput();
void slotCellSelect(bool lock);
void slotCellClicked(const QString &cell);
void slotSheetChanged(const QString &name);
void slotDocModified();
void selectorShow();
void selectorHide();
void selectorFileNew(const DocLnk &lnkDoc);
void selectorFileOpen(const DocLnk &lnkDoc);
public:
MainWindow();
~MainWindow();
void setHelpFile(const QString &help_filename) { helpFile=help_filename; }
public slots:
void setDocument(const QString &applnk_filename);
};
#endif
diff --git a/noncore/apps/opie-sheet/numberdlg.cpp b/noncore/apps/opie-sheet/numberdlg.cpp
index de84378..e8de639 100644
--- a/noncore/apps/opie-sheet/numberdlg.cpp
+++ b/noncore/apps/opie-sheet/numberdlg.cpp
@@ -1,35 +1,49 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include "numberdlg.h"
NumberDialog::NumberDialog(QWidget *parent=0)
:QDialog(parent, 0, TRUE)
{
edit=new QSpinBox(this);
edit->setGeometry(120, 10, 70, 25);
label=new QLabel(this);
label->setGeometry(10, 10, 100, 25);
label->setBuddy(edit);
resize(200, 45);
}
NumberDialog::~NumberDialog()
{
}
int NumberDialog::exec(const QString &caption, const QString &text, int value=1, int min=1, int max=99, int step=1)
{
setCaption(caption);
label->setText(text);
edit->setValue(value);
edit->setMinValue(min);
edit->setMaxValue(max);
edit->setLineStep(step);
return QDialog::exec();
}
int NumberDialog::getValue()
{
return edit->value();
}
diff --git a/noncore/apps/opie-sheet/numberdlg.h b/noncore/apps/opie-sheet/numberdlg.h
index 46af1d0..81e3326 100644
--- a/noncore/apps/opie-sheet/numberdlg.h
+++ b/noncore/apps/opie-sheet/numberdlg.h
@@ -1,24 +1,38 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef NUMBERDLG_H
#define NUMBERDLG_H
#include <qdialog.h>
#include <qlabel.h>
#include <qspinbox.h>
class NumberDialog: public QDialog
{
Q_OBJECT
// QT objects
QLabel *label;
QSpinBox *edit;
public:
NumberDialog(QWidget *parent=0);
~NumberDialog();
int exec(const QString &caption, const QString &text, int value=1, int min=1, int max=99, int step=1);
int getValue();
};
#endif
diff --git a/noncore/apps/opie-sheet/sheet.cpp b/noncore/apps/opie-sheet/sheet.cpp
index 9526937..1d7ec6f 100644
--- a/noncore/apps/opie-sheet/sheet.cpp
+++ b/noncore/apps/opie-sheet/sheet.cpp
@@ -1,512 +1,526 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include "sheet.h"
#include <qmainwindow.h>
#include <qmessagebox.h>
#include <math.h>
#define DEFAULT_COL_WIDTH 50
Sheet::Sheet(int numRows, int numCols, QWidget *parent)
:QTable(numRows, numCols, parent)
{
defaultBorders.right=defaultBorders.bottom=QPen(Qt::gray, 1, Qt::SolidLine);
defaultCellData.data="";
defaultCellData.background=QBrush(Qt::white, Qt::SolidPattern);
defaultCellData.alignment=(Qt::AlignmentFlags)(Qt::AlignLeft | Qt::AlignTop);
defaultCellData.fontColor=Qt::black;
defaultCellData.font=font();
defaultCellData.borders=defaultBorders;
selectionNo=-1;
setSelectionMode(QTable::Single);
sheetData.setAutoDelete(TRUE);
clipboardData.setAutoDelete(TRUE);
for (int i=0; i<numCols; ++i)
horizontalHeader()->setLabel(i, getHeaderString(i+1), DEFAULT_COL_WIDTH);
connect(this, SIGNAL(currentChanged(int, int)), this, SLOT(slotCellSelected(int, int)));
connect(this, SIGNAL(valueChanged(int, int)), this, SLOT(slotCellChanged(int, int)));
}
Sheet::~Sheet()
{
}
typeCellData *Sheet::findCellData(int row, int col)
{
typeCellData *tempCellData;
for (tempCellData=sheetData.first(); tempCellData; tempCellData=sheetData.next())
if (tempCellData->row==row && tempCellData->col==col)
return tempCellData;
return NULL;
}
void Sheet::slotCellSelected(int row, int col)
{
typeCellData *cellData=findCellData(row, col);
if (cellData)
emit currentDataChanged(cellData->data);
else
emit currentDataChanged("");
}
typeCellData *Sheet::createCellData(int row, int col)
{
if (row<0 || col<0) return NULL;
typeCellData *cellData=new typeCellData;
cellData->row=row;
cellData->col=col;
cellData->data=defaultCellData.data;
cellData->borders=defaultCellData.borders;
cellData->alignment=defaultCellData.alignment;
cellData->font=defaultCellData.font;
cellData->fontColor=defaultCellData.fontColor;
cellData->background=defaultCellData.background;
sheetData.append(cellData);
return cellData;
}
void Sheet::slotCellChanged(int row, int col)
{
typeCellData *cellData=findCellData(row, col);
if (!cellData) cellData=createCellData(row, col);
if (cellData) cellData->data=text(row, col);
for (cellData=sheetData.first(); cellData; cellData=sheetData.next())
setText(cellData->row, cellData->col, dataParser(cellData->data));
emit sheetModified();
}
void Sheet::swapCells(int row1, int col1, int row2, int col2)
{
typeCellData *cellData1=findCellData(row1, col1), *cellData2=findCellData(row2, col2);
if (!cellData1) cellData1=createCellData(row1, col1);
if (!cellData2) cellData2=createCellData(row2, col2);
if (cellData1 && cellData2)
{
QString tempData(cellData1->data);
cellData1->data=cellData2->data;
cellData2->data=tempData;
setText(cellData1->row, cellData1->col, dataParser(cellData1->data));
setText(cellData2->row, cellData2->col, dataParser(cellData2->data));
emit sheetModified();
}
}
QString Sheet::getParameter(const QString &parameters, int paramNo, bool giveError=FALSE, const QString funcName="")
{
QString params(parameters);
int position;
for (int i=0; i<paramNo; ++i)
{
position=params.find(',');
if (position<0)
{
if (giveError) QMessageBox::critical(this, tr("Error"), tr("Too few arguments to function '"+funcName+'\''));
return QString();
}
params=params.mid(position+1);
}
position=params.find(',');
if (position<0) return params;
return params.left(position);
}
bool Sheet::findRange(const QString &variable1, const QString &variable2, int *row1, int *col1, int *row2, int *col2)
{
int row, col;
if (!findRowColumn(variable1, row1, col1, TRUE) || !findRowColumn(variable2, row2, col2, TRUE)) return FALSE;
if (*row1>*row2)
{
row=*row1;
*row1=*row2;
*row2=row;
}
if (*col1>*col2)
{
col=*col1;
*col1=*col2;
*col2=col;
}
return TRUE;
}
bool Sheet::findRowColumn(const QString &variable, int *row, int *col, bool giveError=FALSE)
{
int position=variable.find(QRegExp("\\d"));
if (position<1)
{
if (giveError) QMessageBox::critical(this, tr("Error"), tr("Invalid variable: '"+variable+'\''));
return FALSE;
}
*row=variable.mid(position).toInt()-1;
*col=getHeaderColumn(variable.left(position))-1;
return TRUE;
}
double Sheet::calculateVariable(const QString &variable)
{
bool ok;
double tempResult=variable.toDouble(&ok);
if (ok) return tempResult;
int row, col;
return (findRowColumn(variable, &row, &col, TRUE) ? text(row, col).toDouble() : 0);
}
double Sheet::functionSum(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double result=0, tempResult;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok) result+=tempResult;
}
return result;
}
double Sheet::functionMin(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double min=0, tempMin;
bool ok, init=FALSE;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempMin=text(row, col).toDouble(&ok);
if (ok && (!init || tempMin<min))
{
min=tempMin;
init=TRUE;
}
}
return min;
}
double Sheet::functionMax(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double max=0, tempMax;
bool ok, init=FALSE;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempMax=text(row, col).toDouble(&ok);
if (ok && (!init || tempMax>max))
{
max=tempMax;
init=TRUE;
}
}
return max;
}
double Sheet::functionAvg(const QString &param1, const QString &param2)
{
double resultSum=functionSum(param1, param2), resultCount=functionCount(param1, param2);
return (resultCount>0 ? resultSum/resultCount : 0);
}
double Sheet::functionCount(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
int divider=0;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
text(row, col).toDouble(&ok);
if (ok) ++divider;
}
return divider;
}
double Sheet::calculateFunction(const QString &function, const QString &parameters)
{
if (function=="+")
return calculateVariable(getParameter(parameters, 0))+calculateVariable(getParameter(parameters, 1));
if (function=="-")
return calculateVariable(getParameter(parameters, 0))-calculateVariable(getParameter(parameters, 1));
if (function=="*")
return calculateVariable(getParameter(parameters, 0))*calculateVariable(getParameter(parameters, 1));
if (function=="/")
return calculateVariable(getParameter(parameters, 0))/calculateVariable(getParameter(parameters, 1));
if (function=="SUM")
return functionSum(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if (function=="COUNT")
return functionCount(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if (function=="MIN")
return functionMin(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if (function=="MAX")
return functionMax(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if (function=="AVG")
return functionAvg(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if (function=="ABS")
return fabs(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="SIN")
return sin(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="COS")
return cos(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="TAN")
return tan(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="ATAN")
return atan(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="ATAN2")
return atan2(calculateVariable(getParameter(parameters, 0, TRUE, function)), calculateVariable(getParameter(parameters, 1, TRUE, function)));
if (function=="ASIN")
return asin(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="ACOS")
return acos(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="EXP")
return exp(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="LOG")
return log(calculateVariable(getParameter(parameters, 0, TRUE, function)));
if (function=="POW")
return pow(calculateVariable(getParameter(parameters, 0, TRUE, function)), calculateVariable(getParameter(parameters, 1, TRUE, function)));
return 0;
}
int Sheet::getOperatorPriority(char oper)
{
switch (oper)
{
case '+':
case '-':
return 1;
case '*':
case '/':
return 2;
}
return 0;
}
void Sheet::pushCharStack(QStack<QChar> *stackChars, const QChar &character)
{
QChar *temp=new QChar(character);
stackChars->push(temp);
}
void Sheet::pushStringStack(QStack<QString> *stackStrings, const QString &string)
{
QString *temp=new QString(string);
stackStrings->push(temp);
}
QChar Sheet::popCharStack(QStack<QChar> *stackChars)
{
if (stackChars->isEmpty())
{
QMessageBox::critical(this, tr("Error"), tr("Syntax error!"));
return '0';
}
QChar *temp=stackChars->pop();
QChar temp2(*temp);
delete temp;
return temp2;
}
QString Sheet::popStringStack(QStack<QString> *stackStrings)
{
if (stackStrings->isEmpty())
{
QMessageBox::critical(this, tr("Error"), tr("Syntax error!"));
return "0";
}
QString *temp=stackStrings->pop();
QString temp2(*temp);
delete temp;
return temp2;
}
QString Sheet::dataParserHelper(const QString &data)
{
QStack<QString> stackElements;
QStack<QChar> stackOperators;
QString tempElement(""), temp2Element, firstElement, secondElement;
int paranCount;
for (unsigned int i=0; i<data.length(); ++i)
{
if (data[i]=='+' || data[i]=='-' || data[i]=='*' || data[i]=='/')
{
pushStringStack(&stackElements, tempElement);
tempElement="";
if (!stackOperators.isEmpty() && getOperatorPriority(*stackOperators.top())>getOperatorPriority(data[i]))
{
secondElement=popStringStack(&stackElements);
firstElement=popStringStack(&stackElements);
pushStringStack(&stackElements, QString::number(calculateFunction(popCharStack(&stackOperators), firstElement+","+secondElement)));
}
pushCharStack(&stackOperators, data[i]);
}
else
if (data[i]==',')
{
if (!tempElement.isEmpty()) pushStringStack(&stackElements, tempElement);
while (!stackOperators.isEmpty())
{
secondElement=popStringStack(&stackElements);
firstElement=popStringStack(&stackElements);
pushStringStack(&stackElements, QString::number(calculateFunction(popCharStack(&stackOperators), firstElement+","+secondElement)));
}
tempElement="";
}
else
if (data[i]=='(')
{
paranCount=1;
temp2Element="";
for (++i; paranCount>0; ++i)
{
temp2Element+=data[i];
if (data[i]=='(') ++paranCount;
if (data[i]==')') --paranCount;
}
temp2Element=dataParserHelper(temp2Element.left(temp2Element.length()-1));
if (tempElement.isEmpty())
tempElement=temp2Element;
else
tempElement.setNum(calculateFunction(tempElement, temp2Element));
--i;
}
else
tempElement+=data[i];
}
if (!tempElement.isEmpty()) pushStringStack(&stackElements, tempElement);
while (!stackOperators.isEmpty())
{
secondElement=popStringStack(&stackElements);
firstElement=popStringStack(&stackElements);
pushStringStack(&stackElements, QString::number(calculateFunction(popCharStack(&stackOperators), firstElement+","+secondElement)));
}
if (!stackElements.isEmpty())
tempElement=popStringStack(&stackElements);
while (!stackElements.isEmpty())
tempElement.prepend(popStringStack(&stackElements)+",");
return tempElement;
}
QString Sheet::dataParser(const QString &data)
{
QString strippedData(data);
strippedData.replace(QRegExp("\\s"), "");
if (strippedData.isEmpty() || strippedData[0]!='=') return data;
strippedData=dataParserHelper(strippedData.remove(0, 1).upper().replace(QRegExp(":"), ","));
int i=0;
QString tempParameter(getParameter(strippedData, i)), result="";
do
{
result+=","+QString::number(calculateVariable(tempParameter));
tempParameter=getParameter(strippedData, ++i);
}
while (!tempParameter.isNull());
return result.mid(1);
}
void Sheet::setData(const QString &data)
{
setText(currentRow(), currentColumn(), data);
slotCellChanged(currentRow(), currentColumn());
activateNextCell();
}
QString Sheet::getData()
{
typeCellData *cellData=findCellData(currentRow(), currentColumn());
if (cellData)
return cellData->data;
return "";
}
void Sheet::lockClicks(bool lock=TRUE)
{
clicksLocked=lock;
}
void Sheet::paintCell(QPainter *p, int row, int col, const QRect & cr, bool selected)
{
if (selected && row==currentRow() && col==currentColumn()) selected=FALSE;
int sheetDataCurrent=sheetData.at();
typeCellData *cellData=findCellData(row, col);
if (sheetDataCurrent>=0) sheetData.at(sheetDataCurrent);
if (!cellData) cellData=&defaultCellData;
if (selected)
p->fillRect(0, 0, cr.width(), cr.height(), colorGroup().highlight());
else
{
p->fillRect(0, 0, cr.width(), cr.height(), colorGroup().base());
p->fillRect(0, 0, cr.width(), cr.height(), cellData->background);
}
QTableItem *cellItem=item(row, col);
if (cellItem)
{
p->setPen(selected ? colorGroup().highlightedText() : cellData->fontColor);
p->setFont(cellData->font);
p->drawText(2, 2, cr.width()-4, cr.height()-4, cellData->alignment, cellItem->text());
}
int rx=cr.width()-1, ry=cr.height()-1;
QPen pen(p->pen());
p->setPen(cellData->borders.right);
p->drawLine(rx, 0, rx, ry);
p->setPen(cellData->borders.bottom);
p->drawLine(0, ry, rx, ry);
p->setPen(pen);
}
void Sheet::viewportMousePressEvent(QMouseEvent *e)
{
QMouseEvent ce(e->type(), viewportToContents(e->pos()), e->globalPos(), e->button(), e->state());
if (clicksLocked)
{
if (selectionNo<0)
{
clearSelection();
QTableSelection newSelection;
newSelection.init(rowAt(ce.pos().y()), columnAt(ce.pos().x()));
newSelection.expandTo(newSelection.anchorRow(), newSelection.anchorCol());
selectionNo=addSelection(newSelection);
}
}
else
QTable::contentsMousePressEvent(&ce);
}
void Sheet::viewportMouseMoveEvent(QMouseEvent *e)
{
QMouseEvent ce(e->type(), viewportToContents(e->pos()), e->globalPos(), e->button(), e->state());
if (clicksLocked)
{
if (selectionNo>=0)
{
QTableSelection oldSelection(selection(selectionNo));
oldSelection.expandTo(rowAt(ce.pos().y()), columnAt(ce.pos().x()));
if (!(oldSelection==selection(selectionNo)))
{
removeSelection(selectionNo);
selectionNo=addSelection(oldSelection);
}
}
}
diff --git a/noncore/apps/opie-sheet/sheet.h b/noncore/apps/opie-sheet/sheet.h
index 02899a0..f78a684 100644
--- a/noncore/apps/opie-sheet/sheet.h
+++ b/noncore/apps/opie-sheet/sheet.h
@@ -1,120 +1,134 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef SHEET_H
#define SHEET_H
#include <qtable.h>
#include <qstack.h>
typedef struct typeCellBorders
{
QPen right, bottom;
};
typedef struct typeCellData
{
int col, row;
typeCellBorders borders;
QBrush background;
Qt::AlignmentFlags alignment;
QColor fontColor;
QFont font;
QString data;
};
class Sheet: public QTable
{
Q_OBJECT
// Variables
bool clicksLocked;
int selectionNo;
typeCellBorders defaultBorders;
typeCellData defaultCellData;
// QT objects
QList<typeCellData> sheetData, clipboardData;
QString pressedCell, releasedCell, sheetName;
// Private functions
int getOperatorPriority(char oper);
bool findRowColumn(const QString &variable, int *row, int *col, bool giveError=FALSE);
bool findRange(const QString &variable1, const QString &variable2, int *row1, int *col1, int *row2, int *col2);
double calculateVariable(const QString &variable);
double calculateFunction(const QString &function, const QString &parameters);
QChar popCharStack(QStack<QChar> *stackChars);
QString popStringStack(QStack<QString> *stackStrings);
QString getParameter(const QString &parameters, int paramNo, bool giveError=FALSE, const QString funcName="");
QString dataParser(const QString &data);
QString dataParserHelper(const QString &data);
typeCellData *createCellData(int row, int col);
typeCellData *findCellData(int row, int col);
void pushCharStack(QStack<QChar> *stackChars, const QChar &character);
void pushStringStack(QStack<QString> *stackStrings, const QString &string);
// Sheet/Qt parser functions
double functionSum(const QString &param1, const QString &param2);
double functionAvg(const QString &param1, const QString &param2);
double functionMax(const QString &param1, const QString &param2);
double functionMin(const QString &param1, const QString &param2);
double functionCount(const QString &param1, const QString &param2);
// Reimplemented QTable functions
void paintCell(QPainter *p, int row, int col, const QRect & cr, bool selected);
void viewportMousePressEvent(QMouseEvent *e);
void viewportMouseMoveEvent(QMouseEvent *e);
void viewportMouseReleaseEvent(QMouseEvent *e);
private slots:
void slotCellSelected(int row, int col);
void slotCellChanged(int row, int col);
public:
Sheet(int numRows, int numCols, QWidget *parent);
~Sheet();
void setData(const QString &data);
QString getData();
void setName(const QString &data);
QString getName();
void setPen(int row, int col, int vertical, const QPen &pen);
QPen getPen(int row, int col, int vertical);
void setBrush(int row, int col, const QBrush &brush);
QBrush getBrush(int row, int col);
void setTextAlign(int row, int col, Qt::AlignmentFlags flags);
Qt::AlignmentFlags getAlignment(int row, int col);
void setTextFont(int row, int col, const QFont &font, const QColor &color);
QFont getFont(int row, int col);
QColor getFontColor(int row, int col);
void lockClicks(bool lock=TRUE);
void copySheetData(QList<typeCellData> *destSheetData);
void setSheetData(QList<typeCellData> *srcSheetData);
void getSelection(int *row1, int *col1, int *row2, int *col2);
void insertRows(int no=1, bool allColumns=TRUE);
void insertColumns(int no=1, bool allRows=TRUE);
void dataFindReplace(const QString &find, const QString &replace, bool matchCase=TRUE, bool allCells=TRUE, bool entireCell=FALSE, bool replace=FALSE, bool replaceAll=FALSE);
// Static functions
static int getHeaderColumn(const QString &section);
static QString getHeaderString(int section);
public slots:
void editCut();
void editCopy();
void editPaste(bool onlyContents=FALSE);
void editClear();
void swapCells(int row1, int col1, int row2, int col2);
signals:
void currentDataChanged(const QString &data);
void cellClicked(const QString &cell);
void sheetModified();
};
#endif
diff --git a/noncore/apps/opie-sheet/sortdlg.cpp b/noncore/apps/opie-sheet/sortdlg.cpp
index f46562e..4f18fd3 100644
--- a/noncore/apps/opie-sheet/sortdlg.cpp
+++ b/noncore/apps/opie-sheet/sortdlg.cpp
@@ -1,178 +1,192 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include <qlabel.h>
#include <qradiobutton.h>
#include <qmessagebox.h>
#include "sortdlg.h"
SortDialog::SortDialog(QWidget *parent=0)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetSort=new QWidget(tabs);
widgetOptions=new QWidget(tabs);
tabs->addTab(widgetSort, tr("&Sort"));
tabs->addTab(widgetOptions, tr("&Options"));
// Sort tab
comboFieldA=createFieldCombo(tr("&Sort by"), 10);
groupOrderA=createOrderButtons(10);
comboFieldB=createFieldCombo(tr("&Then by"), 90);
groupOrderB=createOrderButtons(90);
comboFieldC=createFieldCombo(tr("Then &by"), 170);
groupOrderC=createOrderButtons(170);
// Options tab
checkCase=new QCheckBox(tr("&Case Sensitive"), widgetOptions);
checkCase->setGeometry(10, 10, 215, 20);
checkCase->setChecked(TRUE);
groupDirection=new QVButtonGroup(tr("&Direction"), widgetOptions);
groupDirection->setGeometry(10, 40, 215, 70);
QRadioButton *radio=new QRadioButton(tr("&Top to bottom (rows)"), groupDirection);
radio=new QRadioButton(tr("&Left to right (columns)"), groupDirection);
groupDirection->setButton(0);
connect(groupDirection, SIGNAL(clicked(int)), this, SLOT(directionChanged(int)));
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Sort"));
}
SortDialog::~SortDialog()
{
}
QComboBox *SortDialog::createFieldCombo(const QString &caption, int y)
{
QLabel *label=new QLabel(caption, widgetSort);
label->setGeometry(10, y+5, 215, 20);
QComboBox *combo=new QComboBox(FALSE, widgetSort);
combo->setGeometry(10, y+35, 105, 20);
label->setBuddy(combo);
return combo;
}
QVButtonGroup *SortDialog::createOrderButtons(int y)
{
QVButtonGroup *group=new QVButtonGroup(widgetSort);
group->setGeometry(125, y, 100, 60);
QRadioButton *radio=new QRadioButton(tr("&Ascending"), group);
radio=new QRadioButton(tr("&Descending"), group);
group->setButton(0);
return group;
}
void SortDialog::directionChanged(int id)
{
direction=id;
fillFieldCombo(comboFieldA);
fillFieldCombo(comboFieldB);
fillFieldCombo(comboFieldC);
}
void SortDialog::fillFieldCombo(QComboBox *combo)
{
combo->clear();
if (direction)
for (int row=row1; row<=row2; ++row)
combo->insertItem("Row "+QString::number(row+1));
else
for (int col=col1; col<=col2; ++col)
combo->insertItem("Column "+Sheet::getHeaderString(col+1));
}
int SortDialog::exec(Sheet *s)
{
sheet=s;
sheet->getSelection(&row1, &col1, &row2, &col2);
direction=0;
fillFieldCombo(comboFieldA);
fillFieldCombo(comboFieldB);
fillFieldCombo(comboFieldC);
if (row1==row2 && col1==col2)
{
QMessageBox::warning(this, tr("Error"), tr("One cell cannot be sorted!"));
return QDialog::Rejected;
}
if (QDialog::exec()==QDialog::Accepted)
{
QString field1S=comboFieldA->currentText(), field2S=comboFieldA->currentText(), field3S=comboFieldA->currentText();
field1S=field1S.mid(field1S.find(' ')+1);
field2S=field2S.mid(field2S.find(' ')+1);
field3S=field3S.mid(field3S.find(' ')+1);
int field1, field2, field3;
if (direction)
{
field1=field1S.toInt()-1;
field2=field2S.toInt()-1;
field3=field3S.toInt()-1;
int i, j;
for (i=col2; i>=col1; --i)
for (j=col1+1; j<=i; ++j)
{
bool swap=FALSE;
int compareResult=compareItems(s->item(field1, j-1), s->item(field1, j), groupOrderA->id(groupOrderA->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(field2, j-1), s->item(field2, j), groupOrderA->id(groupOrderB->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(field3, j-1), s->item(field3, j), groupOrderA->id(groupOrderC->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
}
}
if (swap)
for (int row=row1; row<=row2; ++row)
s->swapCells(row, j-1, row, j);
}
}
else
{
field1=Sheet::getHeaderColumn(field1S)-1;
field2=Sheet::getHeaderColumn(field2S)-1;
field3=Sheet::getHeaderColumn(field3S)-1;
int i, j;
for (i=row2; i>=row1; --i)
for (j=row1+1; j<=i; ++j)
{
bool swap=FALSE;
int compareResult=compareItems(s->item(j-1, field1), s->item(j, field1), groupOrderA->id(groupOrderA->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(j-1, field2), s->item(j, field2), groupOrderA->id(groupOrderB->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(j-1, field3), s->item(j, field3), groupOrderA->id(groupOrderC->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
}
}
if (swap)
for (int col=col1; col<=col2; ++col)
s->swapCells(j-1, col, j, col);
}
}
return QDialog::Accepted;
}
return QDialog::Rejected;
}
int SortDialog::compareItems(QTableItem *item1, QTableItem *item2, int descending=0, bool caseSensitive=TRUE)
{
int result=0;
if (item1)
{
if (item2) result=(caseSensitive ? item1->text().compare(item2->text()) : item1->text().upper().compare(item2->text().upper()));
else result=-1;
}
else
if (item2) result=1;
return (descending ? -result : result);
}
diff --git a/noncore/apps/opie-sheet/sortdlg.h b/noncore/apps/opie-sheet/sortdlg.h
index 2c99f02..b3699a9 100644
--- a/noncore/apps/opie-sheet/sortdlg.h
+++ b/noncore/apps/opie-sheet/sortdlg.h
@@ -1,45 +1,59 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef SORTDLG_H
#define SORTDLG_H
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qcombobox.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
#include <qvbuttongroup.h>
#include "sheet.h"
class SortDialog: public QDialog
{
Q_OBJECT
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetSort, *widgetOptions;
QVButtonGroup *groupOrderA, *groupOrderB, *groupOrderC, *groupDirection;
QCheckBox *checkCase;
QComboBox *comboFieldA, *comboFieldB, *comboFieldC;
// Other objects & variables
int row1, col1, row2, col2, direction;
Sheet *sheet;
// Private functions
QVButtonGroup *createOrderButtons(int y);
QComboBox *createFieldCombo(const QString &caption, int y);
void fillFieldCombo(QComboBox *combo);
int compareItems(QTableItem *item1, QTableItem *item2, int descending=0, bool caseSensitive=TRUE);
private slots:
void directionChanged(int id);
public:
SortDialog(QWidget *parent=0);
~SortDialog();
int exec(Sheet *s);
};
#endif
diff --git a/noncore/apps/opie-sheet/textdlg.cpp b/noncore/apps/opie-sheet/textdlg.cpp
index 8245fe4..0810eb2 100644
--- a/noncore/apps/opie-sheet/textdlg.cpp
+++ b/noncore/apps/opie-sheet/textdlg.cpp
@@ -1,32 +1,46 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#include "textdlg.h"
TextDialog::TextDialog(QWidget *parent=0)
:QDialog(parent, 0, TRUE)
{
edit=new QLineEdit(this);
edit->setGeometry(90, 10, 100, 25);
label=new QLabel(this);
label->setGeometry(10, 10, 70, 25);
label->setBuddy(edit);
resize(200, 45);
}
TextDialog::~TextDialog()
{
}
int TextDialog::exec(const QString &caption, const QString &text, const QString &value="")
{
setCaption(caption);
label->setText(text);
edit->setText(value);
return QDialog::exec();
}
QString TextDialog::getValue()
{
return edit->text();
}
diff --git a/noncore/apps/opie-sheet/textdlg.h b/noncore/apps/opie-sheet/textdlg.h
index f948228..78ef580 100644
--- a/noncore/apps/opie-sheet/textdlg.h
+++ b/noncore/apps/opie-sheet/textdlg.h
@@ -1,24 +1,38 @@
+/***************************************************************************
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ ***************************************************************************/
+
+/*
+ * Opie Sheet (formerly Sheet/Qt)
+ * by Serdar Ozler <sozler@sitebest.com>
+ */
+
#ifndef TEXTDLG_H
#define TEXTDLG_H
#include <qdialog.h>
#include <qlabel.h>
#include <qlineedit.h>
class TextDialog: public QDialog
{
Q_OBJECT
// QT objects
QLabel *label;
QLineEdit *edit;
public:
TextDialog(QWidget *parent=0);
~TextDialog();
int exec(const QString &caption, const QString &text, const QString &value="");
QString getValue();
};
#endif