diff options
Diffstat (limited to 'filters/kspread/libkspreadexport/KSpreadLeader.cpp')
| -rw-r--r-- | filters/kspread/libkspreadexport/KSpreadLeader.cpp | 359 |
1 files changed, 359 insertions, 0 deletions
diff --git a/filters/kspread/libkspreadexport/KSpreadLeader.cpp b/filters/kspread/libkspreadexport/KSpreadLeader.cpp new file mode 100644 index 000000000..8e300c7d1 --- /dev/null +++ b/filters/kspread/libkspreadexport/KSpreadLeader.cpp @@ -0,0 +1,359 @@ +/* +This file is part of the KDE project +Copyright (C) 2002 Fred Malabre <fmalabre@yahoo.com> + +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. +*/ + +#include "KSpreadLeader.h" + +using namespace KSpread; + +Leader::Leader(KoFilterChain *filterChain) { + m_worker = NULL; + m_filterChain = filterChain; +} + + +Leader::Leader(KoFilterChain *filterChain, KSpreadBaseWorker *newWorker) { + m_worker = newWorker; + m_filterChain = filterChain; +} + + +Leader::~Leader() { +} + + +KSpreadBaseWorker *Leader::getWorker() const { + return m_worker; +} + + +void Leader::setWorker(KSpreadBaseWorker *newWorker) { + m_worker = newWorker; +} + + +KoFilter::ConversionStatus Leader::convert() { + KoFilter::ConversionStatus status; + + // Validate the filter chain and the worker + if (!m_filterChain) { + kdWarning(30508) << "koFilterChain is NULL!" << endl; + return KoFilter::StupidError; + } + if (!m_worker) { + kdWarning(30508) << "the KSpreadWorker is NULL!" << endl; + return KoFilter::StupidError; + } + + // Gather data about the filter itself + KSpreadFilterProperty docProperty; + docProperty["outputfile"] = m_filterChain->outputFile(); + status = m_worker->startDocument(docProperty); + if (status != KoFilter::OK) + return status; + + // Get the document in memory + KSpreadDoc *document = (KSpreadDoc *) m_filterChain->inputDocument(); + if (!document) { + kdWarning(30508) << "the KSpreadDoc is NULL!" << endl; + return KoFilter::StupidError; + } + if ( !::tqqt_cast<const KSpread::Doc *>( document ) ) { + kdWarning(30508) << "the document is not a KSpreadDoc!" << endl; + return KoFilter::StupidError; + } + if (document->mimeType() != "application/x-kspread") { + kdWarning(30508) << "the mime type document is not application/x-kspread!" << endl; + return KoFilter::StupidError; + } + KoDocumentInfo *info = document->documentInfo(); + if (!document) { + kdWarning(30508) << "the KoDocumentInfo is NULL!" << endl; + return KoFilter::StupidError; + } + + // Gather data about the document info + status = doInfo(info); + if (status != KoFilter::OK) + return status; + + // Gather data about the spread book + status = doSpreadBook(document); + if (status != KoFilter::OK) + return status; + + // Gather data about the spread sheet + KSpreadSheet *spreadSheet = document->map()->firstTable(); + while (spreadSheet != 0) { + status = doSpreadSheet(spreadSheet); + if (status != KoFilter::OK) + return status; + + // Gather data about the cell + for (int row = 1; row <= m_maxCellRow; ++row) { + for (int column = 1; column <= m_maxCellColumn; ++column) { + Cell*spreadCell = spreadSheet->cellAt(column, row); + status = doSpreadCell(spreadCell, column, row); + if (status != KoFilter::OK) + return status; + } + } + + spreadSheet = document->map()->nextTable(); + } + + return status; +} + + +KoFilter::ConversionStatus Leader::doInfo(KoDocumentInfo *info) { + KoFilter::ConversionStatus status; + +#if 0 // this was never used, it's been removed now + // Gather data about the document log + KSpreadFilterProperty docInfoLogProperty; + KoDocumentInfoLog *infoLog = (KoDocumentInfoLog *) info->page("log"); + docInfoLogProperty["oldlog"] = infoLog->oldLog(); + docInfoLogProperty["newlog"] = infoLog->newLog(); + status = m_worker->startInfoLog(docInfoLogProperty); + if (status != KoFilter::OK) + return status; +#endif + + // Gather data about the document author + KSpreadFilterProperty docInfoAuthorProperty; + KoDocumentInfoAuthor *infoAuthor = (KoDocumentInfoAuthor *) info->page("author"); + docInfoAuthorProperty["fullname"] = infoAuthor->fullName(); + docInfoAuthorProperty["initial"] = infoAuthor->initial(); + docInfoAuthorProperty["title"] = infoAuthor->title(); + docInfoAuthorProperty["company"] = infoAuthor->company(); + docInfoAuthorProperty["email"] = infoAuthor->email(); + docInfoAuthorProperty["telephone"] = infoAuthor->telephone(); + docInfoAuthorProperty["fax"] = infoAuthor->fax(); + docInfoAuthorProperty["country"] = infoAuthor->country(); + docInfoAuthorProperty["postalcode"] = infoAuthor->postalCode(); + docInfoAuthorProperty["city"] = infoAuthor->city(); + docInfoAuthorProperty["street"] = infoAuthor->street(); + status = m_worker->startInfoAuthor(docInfoAuthorProperty); + if (status != KoFilter::OK) + return status; + + // Gather data about the document about + KSpreadFilterProperty docInfoAboutProperty; + KoDocumentInfoAbout *infoAbout = (KoDocumentInfoAbout *) info->page("about"); + docInfoAboutProperty["title"] = infoAbout->title(); + docInfoAboutProperty["author"] = infoAbout->abstract(); + status = m_worker->startInfoAbout(docInfoAboutProperty); + return status; +} + + +KoFilter::ConversionStatus Leader::doSpreadBook(KSpreadDoc *document) { + KSpreadFilterProperty docSpreadBookProperty; + docSpreadBookProperty["spreadsheetcount"] = TQString::number(document->map()->count()); + docSpreadBookProperty["decimalsymbol"] = document->locale()->decimalSymbol(); + docSpreadBookProperty["thousandsseparator"] = document->locale()->thousandsSeparator(); + docSpreadBookProperty["currencysymbol"] = document->locale()->currencySymbol(); + docSpreadBookProperty["monetarydecimalsymbol"] = document->locale()->monetaryDecimalSymbol(); + docSpreadBookProperty["monetarythousandsseparator"] = document->locale()->monetaryThousandsSeparator(); + docSpreadBookProperty["positivesign"] = document->locale()->positiveSign(); + docSpreadBookProperty["negativesign"] = document->locale()->negativeSign(); + docSpreadBookProperty["fracdigits"] = TQString::number(document->locale()->fracDigits()); + docSpreadBookProperty["positiveprefixcurrencysymbol"] = (document->locale()->positivePrefixCurrencySymbol()==0?"false":"true"); + docSpreadBookProperty["negativeprefixcurrencysymbol"] = (document->locale()->negativePrefixCurrencySymbol()==0?"false":"true"); + docSpreadBookProperty["use12clock"] = (document->locale()->use12Clock()==0?"false":"true"); + docSpreadBookProperty["weekstartsmonday"] = (document->locale()->weekStartsMonday()==0?"false":"true"); + docSpreadBookProperty["weekstartday"] = TQString::number(document->locale()->weekStartDay()); + docSpreadBookProperty["language"] = document->locale()->language(); + docSpreadBookProperty["country"] = document->locale()->country(); + docSpreadBookProperty["encoding"] = document->locale()->encoding(); + docSpreadBookProperty["dateformat"] = document->locale()->dateFormat(); + docSpreadBookProperty["dateformatshort"] = document->locale()->dateFormatShort(); + docSpreadBookProperty["timeformat"] = document->locale()->timeFormat(); + docSpreadBookProperty["defaultlanguage"] = TDELocale::defaultLanguage(); + docSpreadBookProperty["defaultcountry"] = TDELocale::defaultCountry(); + docSpreadBookProperty["defaultgridpencolorname"] = document->defaultGridPen().color().name(); + docSpreadBookProperty["defaultgridpencolorred"] = TQString::number(document->defaultGridPen().color().red()); + docSpreadBookProperty["defaultgridpencolorgreen"] = TQString::number(document->defaultGridPen().color().green()); + docSpreadBookProperty["defaultgridpencolorblue"] = TQString::number(document->defaultGridPen().color().blue()); + docSpreadBookProperty["defaultgridpenwidth"] = TQString::number(document->defaultGridPen().width()); + docSpreadBookProperty["showverticalscrollbar"] = (document->getShowVerticalScrollBar()==0?"false":"true"); + docSpreadBookProperty["showhorizontalscrollbar"] = (document->getShowHorizontalScrollBar()==0?"false":"true"); + docSpreadBookProperty["showcolheader"] = (document->getShowColHeader()==0?"false":"true"); + docSpreadBookProperty["showrowheader"] = (document->getShowRowHeader()==0?"false":"true"); + docSpreadBookProperty["indentvalue"] = TQString::number(document->getIndentValue()); + docSpreadBookProperty["movetovalue"] = TQString::number(document->getMoveToValue()); + docSpreadBookProperty["showmessageerror"] = (document->getShowMessageError()==0?"false":"true"); + docSpreadBookProperty["showtabbar"] = (document->getShowTabBar()==0?"false":"true"); + docSpreadBookProperty["pagebordercolorname"] = document->pageBorderColor().name(); + docSpreadBookProperty["pagebordercolorred"] = TQString::number(document->pageBorderColor().red()); + docSpreadBookProperty["pagebordercolorgreen"] = TQString::number(document->pageBorderColor().green()); + docSpreadBookProperty["pagebordercolorblue"] = TQString::number(document->pageBorderColor().blue()); + docSpreadBookProperty["showcommentindicator"] = (document->getShowCommentIndicator()==0?"false":"true"); + docSpreadBookProperty["showformulabar"] = (document->getShowFormulaBar()==0?"false":"true"); + docSpreadBookProperty["dontcheckupperword"] = (document->dontCheckUpperWord()==0?"false":"true"); + docSpreadBookProperty["dontchecktitlecase"] = (document->dontCheckTitleCase()==0?"false":"true"); + docSpreadBookProperty["showstatusbar"] = (document->getShowStatusBar()==0?"false":"true"); + docSpreadBookProperty["unitname"] = document->getUnitName(); + docSpreadBookProperty["syntaxversion"] = TQString::number(document->syntaxVersion()); + return m_worker->startSpreadBook(docSpreadBookProperty); +} + + +KoFilter::ConversionStatus Leader::doSpreadSheet(KSpreadSheet *spreadSheet) { + KSpreadFilterProperty docSpreadSheetProperty; + docSpreadSheetProperty["name"] = spreadSheet->tableName(); + docSpreadSheetProperty["sizemaxx"] = TQString::number(spreadSheet->sizeMaxX()); + docSpreadSheetProperty["sizemaxy"] = TQString::number(spreadSheet->sizeMaxY()); + docSpreadSheetProperty["showgrid"] = (spreadSheet->getShowGrid()==0?"false":"true"); + docSpreadSheetProperty["showformula"] = (spreadSheet->getShowFormula()==0?"false":"true"); + docSpreadSheetProperty["showformulaindicator"] = (spreadSheet->getShowFormulaIndicator()==0?"false":"true"); + docSpreadSheetProperty["lcmode"] = (spreadSheet->getLcMode()==0?"false":"true"); + docSpreadSheetProperty["autocalc"] = (spreadSheet->getAutoCalc()==0?"false":"true"); + docSpreadSheetProperty["showcolumnnumber"] = (spreadSheet->getShowColumnNumber()==0?"false":"true"); + docSpreadSheetProperty["hidezero"] = (spreadSheet->getHideZero()==0?"false":"true"); + docSpreadSheetProperty["firstletterupper"] = (spreadSheet->getFirstLetterUpper()==0?"false":"true"); + docSpreadSheetProperty["ishidden"] = (spreadSheet->isHidden()==0?"false":"true"); + docSpreadSheetProperty["showpageborders"] = (spreadSheet->isShowPageBorders()==0?"false":"true"); + docSpreadSheetProperty["printablewidth"] = TQString::number(spreadSheet->printableWidth()); + docSpreadSheetProperty["printableheight"] = TQString::number(spreadSheet->printableHeight()); + docSpreadSheetProperty["paperwidth"] = TQString::number(spreadSheet->paperWidth()); + docSpreadSheetProperty["paperheight"] = TQString::number(spreadSheet->paperHeight()); + docSpreadSheetProperty["leftborder"] = TQString::number(spreadSheet->leftBorder()); + docSpreadSheetProperty["rightborder"] = TQString::number(spreadSheet->rightBorder()); + docSpreadSheetProperty["topborder"] = TQString::number(spreadSheet->topBorder()); + docSpreadSheetProperty["bottomborder"] = TQString::number(spreadSheet->bottomBorder()); + docSpreadSheetProperty["headleft"] = spreadSheet->headLeft(); + docSpreadSheetProperty["headmid"] = spreadSheet->headMid(); + docSpreadSheetProperty["headright"] = spreadSheet->headRight(); + docSpreadSheetProperty["footleft"] = spreadSheet->footLeft(); + docSpreadSheetProperty["footmid"] = spreadSheet->footMid(); + docSpreadSheetProperty["footright"] = spreadSheet->footRight(); + docSpreadSheetProperty["orientation"] = spreadSheet->orientationString(); + docSpreadSheetProperty["paperformat"] = spreadSheet->paperFormatString(); + docSpreadSheetProperty["printgrid"] = (spreadSheet->getPrintGrid()==0?"false":"true"); + docSpreadSheetProperty["printcomment"] = (spreadSheet->getPrintCommentIndicator()==0?"false":"true"); + docSpreadSheetProperty["printformula"] = (spreadSheet->getPrintFormulaIndicator()==0?"false":"true"); + updateMaxCells(spreadSheet); + docSpreadSheetProperty["maxcellrow"] = TQString::number(m_maxCellRow); + docSpreadSheetProperty["maxcellcolumn"] = TQString::number(m_maxCellColumn); + return m_worker->startSpreadSheet(docSpreadSheetProperty); +} + + +KoFilter::ConversionStatus Leader::doSpreadCell(Cell*spreadCell, int column, int row) { + KSpreadFilterProperty docSpreadCellProperty; + docSpreadCellProperty["column"] = TQString::number(column); + docSpreadCellProperty["row"] = TQString::number(row); + docSpreadCellProperty["width"] = TQString::number(spreadCell->dblWidth()); + docSpreadCellProperty["height"] = TQString::number(spreadCell->dblHeight()); + docSpreadCellProperty["empty"] = (spreadCell->isEmpty()==0?"false":"true"); + if (!spreadCell->isEmpty()) { + docSpreadCellProperty["text"] = spreadCell->text(); + docSpreadCellProperty["strouttext"] = spreadCell->strOutText(); + docSpreadCellProperty["action"] = spreadCell->action(); + docSpreadCellProperty["date"] = (spreadCell->isDate()==0?"false":"true"); + docSpreadCellProperty["time"] = (spreadCell->isTime()==0?"false":"true"); + docSpreadCellProperty["textwidth"] = TQString::number(spreadCell->textWidth()); + docSpreadCellProperty["textheight"] = TQString::number(spreadCell->textHeight()); + docSpreadCellProperty["forceextracells"] = (spreadCell->isForceExtraCells()==0?"false":"true"); + docSpreadCellProperty["mergedxcells"] = TQString::number(spreadCell->mergedXCells()); + docSpreadCellProperty["mergedycells"] = TQString::number(spreadCell->mergedYCells()); + docSpreadCellProperty["extraxcells"] = TQString::number(spreadCell->extraXCells()); + docSpreadCellProperty["extraycells"] = TQString::number(spreadCell->extraYCells()); + docSpreadCellProperty["extrawidth"] = TQString::number(spreadCell->extraWidth()); + docSpreadCellProperty["extraheight"] = TQString::number(spreadCell->extraHeight()); + docSpreadCellProperty["formula"] = (spreadCell->isFormula()==0?"false":"true"); + docSpreadCellProperty["haserror"] = (spreadCell->hasError()==0?"false":"true"); + docSpreadCellProperty["alignx"] = TQString::number(spreadCell->defineAlignX()); + docSpreadCellProperty["name"] = spreadCell->name(); + docSpreadCellProperty["fullname"] = spreadCell->fullName(); + docSpreadCellProperty["content"] = TQString::number(spreadCell->content()); + docSpreadCellProperty["style"] = TQString::number(spreadCell->style()); + docSpreadCellProperty["valuedate"] = spreadCell->valueDate().toString(); + docSpreadCellProperty["valuetime"] = spreadCell->valueTime().toString(); + docSpreadCellProperty["leftborderwidth"] = TQString::number(spreadCell->leftBorderPen(column, row).width()); + docSpreadCellProperty["leftbordercolorname"] = spreadCell->leftBorderPen(column, row).color().name(); + docSpreadCellProperty["leftbordercolorred"] = TQString::number(spreadCell->leftBorderPen(column, row).color().red()); + docSpreadCellProperty["leftbordercolorgreen"] = TQString::number(spreadCell->leftBorderPen(column, row).color().green()); + docSpreadCellProperty["leftbordercolorblue"] = TQString::number(spreadCell->leftBorderPen(column, row).color().blue()); + docSpreadCellProperty["topborderwidth"] = TQString::number(spreadCell->topBorderPen(column, row).width()); + docSpreadCellProperty["topbordercolorname"] = spreadCell->topBorderPen(column, row).color().name(); + docSpreadCellProperty["topbordercolorred"] = TQString::number(spreadCell->topBorderPen(column, row).color().red()); + docSpreadCellProperty["topbordercolorgreen"] = TQString::number(spreadCell->topBorderPen(column, row).color().green()); + docSpreadCellProperty["topbordercolorblue"] = TQString::number(spreadCell->topBorderPen(column, row).color().blue()); + docSpreadCellProperty["rightborderwidth"] = TQString::number(spreadCell->rightBorderPen(column, row).width()); + docSpreadCellProperty["rightbordercolorname"] = spreadCell->rightBorderPen(column, row).color().name(); + docSpreadCellProperty["rightbordercolorred"] = TQString::number(spreadCell->rightBorderPen(column, row).color().red()); + docSpreadCellProperty["rightbordercolorgreen"] = TQString::number(spreadCell->rightBorderPen(column, row).color().green()); + docSpreadCellProperty["rightbordercolorblue"] = TQString::number(spreadCell->rightBorderPen(column, row).color().blue()); + docSpreadCellProperty["bottomborderwidth"] = TQString::number(spreadCell->bottomBorderPen(column, row).width()); + docSpreadCellProperty["bottombordercolorname"] = spreadCell->bottomBorderPen(column, row).color().name(); + docSpreadCellProperty["bottombordercolorred"] = TQString::number(spreadCell->bottomBorderPen(column, row).color().red()); + docSpreadCellProperty["bottombordercolorgreen"] = TQString::number(spreadCell->bottomBorderPen(column, row).color().green()); + docSpreadCellProperty["bottombordercolorblue"] = TQString::number(spreadCell->bottomBorderPen(column, row).color().blue()); + docSpreadCellProperty["bgcolorname"] = spreadCell->bgColor(column, row).name(); + docSpreadCellProperty["bgcolorred"] = TQString::number(spreadCell->bgColor(column, row).red()); + docSpreadCellProperty["bgcolorgreen"] = TQString::number(spreadCell->bgColor(column, row).green()); + docSpreadCellProperty["bgcolorblue"] = TQString::number(spreadCell->bgColor(column, row).blue()); + docSpreadCellProperty["bgbrushstyle"] = TQString::number(spreadCell->backGroundBrush(column, row).style()); + docSpreadCellProperty["valueempty"] = (spreadCell->value().isEmpty()==0?"false":"true"); + docSpreadCellProperty["valueboolean"] = (spreadCell->value().isBoolean()==0?"false":"true"); + docSpreadCellProperty["valueinteger"] = (spreadCell->value().isInteger()==0?"false":"true"); + docSpreadCellProperty["valuefloat"] = (spreadCell->value().isFloat()==0?"false":"true"); + docSpreadCellProperty["valuenumber"] = (spreadCell->value().isNumber()==0?"false":"true"); + docSpreadCellProperty["valuestring"] = (spreadCell->value().isString()==0?"false":"true"); + docSpreadCellProperty["valueerror"] = (spreadCell->value().isError()==0?"false":"true"); + docSpreadCellProperty["valueasboolean"] = (spreadCell->value().asBoolean()==0?"false":"true"); + docSpreadCellProperty["valueasinteger"] = TQString::number(spreadCell->value().asInteger()); + docSpreadCellProperty["valueasfloat"] = TQString::number(spreadCell->value().asFloat()); + docSpreadCellProperty["valueasstring"] = spreadCell->value().asString(); + docSpreadCellProperty["valueasdatetime"] = spreadCell->value().asDateTime().toString(); + docSpreadCellProperty["valueaserror"] = spreadCell->value().errorMessage(); + } + return m_worker->startSpreadCell(docSpreadCellProperty); +} + + +void Leader::updateMaxCells(KSpreadSheet *spreadSheet) { + m_maxCellColumn = 0; + m_maxCellRow = 0; + + int maxColumn = spreadSheet->maxColumn(); + int maxRow = spreadSheet->maxRow(); + + // Go through all the SpreadSheet to find out the minimum rectangle of cells + // Maybe we should have something which does that in the KSpreadSheet class, + // it would be easy to keep track of this each time a new Cellis instanciated. + for (int row = 1; row < maxRow; ++row) { + bool usedColumn = FALSE; + for (int column = 1; column < maxColumn; ++column) { + Cell*cell = spreadSheet->cellAt(column, row); + if (!cell->isDefault() && !cell->isEmpty()) { + if (column > m_maxCellColumn) { + m_maxCellColumn = column; + } + usedColumn = TRUE; + } + } + if (usedColumn) { + m_maxCellRow = row; + } + } +} |