Skip to main content :: ::

KOffice API Docs

:: Skip to Link Menu
/ KOffice / API Docs / kspread

kspread CalendarTool.cpp Go to the documentation of this file. /* This file is part of the KDE project Copyright 2008 Stefan Nikolaus <stefan.nikolaus@kdemail.net> This library is free software; you can redistribute it and/or modify it under the terms of the GNU Library General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; see the file COPYING.LIB. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. */ // Local #include "CalendarTool.h" #include "CalendarToolWidget.h" #include <Sheet.h> #include <commands/DataManipulators.h> #include <part/Doc.h> #include <KCalendarSystem> #include <KGenericFactory> #include <KMessageBox> using namespace KSpread; class CalendarTool::Private { public: }; CalendarTool::CalendarTool(KoCanvasBase* canvas) : CellTool(canvas) , d(new Private) { setObjectName("CalendarTool"); /* KAction* importAction = new KAction(KIcon("document-import"), i18n("Import OpenDocument Spreadsheet File"), this); importAction->setIconText(i18n("Import")); addAction("import", importAction); connect(importAction, SIGNAL(triggered()), this, SLOT(importDocument()));*/ } CalendarTool::~CalendarTool() { delete d; } void CalendarTool::activate(bool temporary) { CellTool::activate(temporary); } void CalendarTool::deactivate() { CellTool::deactivate(); } void CalendarTool::insertCalendar(const QDate &start, const QDate &end) { if (end < start) { KMessageBox::error(0,i18n("End date is before start date! Please make sure that end date comes after start date."),i18n("Error")); return; } if (start.daysTo(end) > 3652) { KMessageBox::error(0,i18n("Calendars should not be longer than 10 years. If you really need such long periods you need to split them up."),i18n("Error")); return; } if (start == end) { if (KMessageBox::No == KMessageBox::warningYesNo(0,i18n("Start and end dates are equal! Only one day will be inserted, do you want to continue?"),i18n("Warning"))) return; } if (start.daysTo(end)> 366) { if (KMessageBox::No == KMessageBox::warningYesNo(0,i18n("Creating a calendar for a longer period than a year can take up a lot of space, do you want to continue?"),i18n("Warning"))) return; } const QPoint marker = this->selection()->lastRange().topLeft(); Sheet* const sheet = this->selection()->activeSheet(); //now let's check if the area is really empty... //we use two columns per day and one column for the week number int sizeX = 15; //we use two rows per week, some additional space between months... //so that should be ok, but can be improved of course //@todo improve calendar size prediction! int sizeY = 4 + (int)(0.5*(float)(start.daysTo(end))); if (!sheet->areaIsEmpty(Region(QRect(marker,QSize(sizeX,sizeY))))) { if (KMessageBox::No == KMessageBox::warningYesNo(0,i18n("The area where the calendar is inserted is NOT empty, are you sure you want to continue, overwriting existing data? If you choose No the area that would be required for the desired calendar will be selected so you can see what data would be overwritten."),i18n("Warning"))) { //select the area so the user knows what's in the way selection()->initialize(QRect(marker.x(),marker.y(),sizeX,sizeY));//,sheet); return; } } KCalendarSystem* cs = KCalendarSystem::create(); Q_ASSERT(cs); sheet->doc()->beginMacro(i18n("Insert Calendar")); int row = marker.y(); int col = marker.x(); int colstart = col; //this is where we get back after each week setText(sheet, row, colstart, i18n("Calendar from %1 to %2", start.toString(), end.toString())); QDate current(start); // QDate previous(current); bool yearheader = true; bool monthheader = true; bool weekheader = true; //this loop creates the actual calendar //@todo formatting of cells - each day occupies QRect(row,col,row,col+1) while (current <= end) { //let's see if any header is required if (cs->dayOfWeek(current)==1) { col=colstart; row++; weekheader=true; } if (cs->day(current)==1) { row+=2; col=colstart + (cs->dayOfWeek(current)-1)*2; monthheader=true; weekheader=true; if (cs->month(current)==1) { row++; yearheader=true; } } if (yearheader) { kDebug() <<"inserting year" + QString::number(current.year()); setText(sheet,row, colstart + 6, cs->yearString(current, KCalendarSystem::LongFormat)); row+=2; yearheader=false; } if (monthheader) { kDebug() <<"inserting month" + QString::number(current.month()); setText(sheet, row, colstart + 6, cs->monthName(current, KCalendarSystem::LongName)); row+=2; //we always have the week number in the first column setText(sheet, row, colstart, i18n("week")); for (int i=1; i<8; i++) { setText(sheet, row, colstart + (i-1) * 2 + 1, cs->weekDayName(i)); } row++; monthheader=false; } if (weekheader) { setText(sheet, row, colstart, QString::number(cs->weekNumber(current))); col++; weekheader=false; //if we are at the beginning of the month we might need an offset if (cs->day(current)==1) { col=colstart + (cs->dayOfWeek(current)-1)*2 + 1; } } setText(sheet, row, col, QString::number(cs->day(current))); //go to the next date //@todo isn't there a better way, like current++ or something?? QDate next = current.addDays(1); current.setYMD(next.year(),next.month(),next.day()); col+=2; } sheet->doc()->endMacro(); kDebug() <<"inserting calendar completed"; } QWidget* CalendarTool::createOptionWidget() { // Create the main cell tool widget. It is not visible, but the CellTool makes heavy use // of it, and it refuses to work correctly if it does not exist CellTool::createOptionWidget (); CalendarToolWidget* widget = new CalendarToolWidget(m_canvas->canvasWidget()); connect(widget, SIGNAL(insertCalendar(const QDate&, const QDate&)), this, SLOT(insertCalendar(const QDate&, const QDate&))); return widget; } void CalendarTool::setText(Sheet* sheet, int _row, int _column, const QString& _text, bool asString) { DataManipulator* const command = new DataManipulator(); command->setSheet(sheet); command->setValue(Value(_text)); command->setParsing(!asString); command->add(QPoint(_column, _row)); command->execute(); //refresh anchor if ((!_text.isEmpty()) && (_text.at(0)=='!')) { sheet->updateView(Region(_column, _row, sheet)); } } #include "CalendarTool.moc" kspread Skip menu "kspread" Main Page Modules Namespace List Class Hierarchy Alphabetical List Class List File List Namespace Members Class Members Related Pages API Reference Skip menu "API Reference" kdgantt Kexi   KoProperty   flake kplato krita   image   plugins       libbrush       libpaintop   ui kspread   part     scripting libs   flake   kotext   main   pigment   store   musicshape Generated for API Reference by doxygen 1.5.9-20090814 This website is maintained by Adriaan de Groot and Allen Winter. KDE® and the K Desktop Environment® logo are registered trademarks of KDE e.V. | Legal