changeset 6:a10425e7ef98

Add free text handling
author Andre Heinecke <andre.heinecke@intevation.de>
date Tue, 22 Mar 2016 15:15:39 +0100
parents 2559010c1202
children afb1ecf0f1db
files src/constants.h src/converter.cpp src/converter.h
diffstat 3 files changed, 72 insertions(+), 10 deletions(-) [+]
line wrap: on
line diff
--- a/src/constants.h	Tue Mar 22 15:14:58 2016 +0100
+++ b/src/constants.h	Tue Mar 22 15:15:39 2016 +0100
@@ -73,6 +73,8 @@
 
 #define CHOICE_ROW_HEIGHT 30
 
+#define TEXT_ROW_HEIGHT 20
+
 #define TEXT_IDENTIFIER "Answer"
 
 #endif // CONSTANTS_H
--- a/src/converter.cpp	Tue Mar 22 15:14:58 2016 +0100
+++ b/src/converter.cpp	Tue Mar 22 15:15:39 2016 +0100
@@ -36,22 +36,23 @@
     mQuestionFmt.setFontName("Calibri");
     mQuestionFmt.setFontBold(true);
     mQuestionFmt.setTopBorderStyle(Format::BorderThin);
+    mQuestionFmt.setBottomBorderStyle(Format::BorderThin);
     mQuestionFmt.setTextWarp(true);
 
     mAnswerChoiceFmt.setFontSize(11);
     mAnswerChoiceFmt.setFontName("Calibri");
     mAnswerChoiceFmt.setHorizontalAlignment(Format::AlignRight);
+    mAnswerChoiceFmt.setTextWarp(true);
 
     mChoiceTextFmt = mAnswerChoiceFmt;
     mChoiceTextFmt.setVerticalAlignment(Format::AlignVCenter);
 
-    mChoiceBarFmt = mChoiceTextFmt;
-    mChoiceBarFmt.setFontName("Webdings");
-    mChoiceBarFmt.setFontSize(9);
-    mChoiceBarFmt.setFontColor(QColor(0xFF, 0x99, 0x33));
+    mFreeTextFmt = mQuestionFmt;
+    mFreeTextFmt.setFontBold(false);
 
-    mChoiceBarInactiveFmt = mChoiceBarFmt;
-    mChoiceBarInactiveFmt.setFontColor(QColor(0xD9, 0xD9, 0xD9));
+    mAnswerTextFmt = mQuestionFmt;
+    mAnswerTextFmt.setVerticalAlignment(Format::AlignVCenter);
+    mAnswerTextFmt.setHorizontalAlignment(Format::AlignLeft);
 }
 
 void Converter::run()
@@ -94,13 +95,20 @@
 
     ConditionalFormatting bars;
 
-    bars.addDataBarRule(QColor(0xFF, 0x99, 0x33), ConditionalFormatting::VOT_Num, "0", ConditionalFormatting::VOT_Num, "100", false);
+    bars.addDataBarRule(QColor(0xFF, 0x99, 0x33), ConditionalFormatting::VOT_Num,
+                        "0", ConditionalFormatting::VOT_Num, "100", false);
 
     const double colWidth[] = COLUMN_WIDTHS;
+    double sum = 0;
     for (int i = 1; i <= COLUMN_CNT; i++) {
         xlsx.setColumnWidth(i, colWidth[i-1]);
+        sum += colWidth[i-1];
     }
 
+    /* For the merged cell wordwrap trick. */
+    xlsx.setColumnWidth(26, sum - 1);
+    xlsx.setColumnHidden(26, true);
+
     int row = 1;
     if (!mTitle.isEmpty()) {
         // Set the title of the Questionaire
@@ -129,6 +137,8 @@
         foundSomething = true;
         const QString question = match.captured(1).trimmed();
         const QString answerLine = match.captured(2).trimmed();
+        xlsx.write(row, 2, QString(" "), mQuestionFmt);
+        xlsx.write(row, 3, QString(" "), mQuestionFmt);
         xlsx.write(row++, 1, question, mQuestionFmt);
 
         if (answerLine == QStringLiteral(CHOICE_IDENTIFIER)) {
@@ -163,7 +173,59 @@
             }
             bars.addRange(QString("B%1:B%2").arg(firstChoiceRow).arg(lastChoiceRow));
         } else if (answerLine == QStringLiteral(TEXT_IDENTIFIER)) {
-            
+            QRegularExpressionMatch textMatch = freetxtEx.match(input, cursor);
+            xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
+            xlsx.write(row++, 1, tr("Answer"), mAnswerTextFmt);
+            while (textMatch.hasMatch()) {
+                if (textMatch.capturedStart() != cursor + 1) {
+                    /* The format allows unescaped quotes in the text.
+                       This makes a workaround neccessary. If we have
+                       an Unquoted string between the next quoted string
+                       and that Unquoted string is before the next question
+                       we append the unquoted string and the next quoted string
+                       with Quotes in the Row.*/
+                    QRegularExpressionMatch nextQuestion = questionEx.match(input, cursor);
+                    if (nextQuestion.hasMatch() &&
+                        nextQuestion.capturedStart() < textMatch.capturedEnd()) {
+                        /* The next question comes before the textMatch so we really have
+                           a new question. */
+                        break;
+                    }
+                    const QString lastRow = xlsx.read(row - 1, 26).toString();
+                    int unquotedLen = textMatch.capturedStart() - cursor;
+                    const QString unquoted = input.mid(cursor, unquotedLen);
+                    qDebug() << "Found inner quoted string: " << unquoted;
+                    /* Now combine */
+                    const QString combined = QString("%1\"%2\"%3").arg(lastRow).
+                                                                   arg(unquoted).
+                                                                   arg(textMatch.captured(1).trimmed());
+                    qDebug() << "Last row: " << lastRow;
+                    qDebug() << "Next Question is at: " << nextQuestion.capturedStart();
+                    qDebug() << "Text match is: " << textMatch.captured(1).trimmed();
+                    qDebug() << "cursor is at: " << cursor;
+                    qDebug() << "text match starts at: " << textMatch.capturedStart();
+                    xlsx.write(row - 1, 26, combined, mFreeTextFmt);
+                    cursor = textMatch.capturedEnd();
+                    textMatch = freetxtEx.match(input, cursor);
+                    continue;
+                }
+                cursor = textMatch.capturedEnd();
+
+                QString text = textMatch.captured(1).trimmed();
+                qDebug() << "Found free text: " << text;
+
+                /* Merge the cells */
+                xlsx.mergeCells(QString("A%1:C%1").arg(row), mFreeTextFmt);
+
+                /* Merged cells ignore wordwrap the following trick is based on:
+                   http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html
+                */
+                /* Write the values */
+                xlsx.write(QString("Z%1").arg(row), text, mFreeTextFmt);
+                xlsx.write(row, 1, QString("=Z%1").arg(row));
+                row++;
+                textMatch = freetxtEx.match(input, cursor);
+            }
         }
         /* Insert Empty row. */
         xlsx.setRowHeight(row++, CHOICE_ROW_HEIGHT);
--- a/src/converter.h	Tue Mar 22 15:14:58 2016 +0100
+++ b/src/converter.h	Tue Mar 22 15:15:39 2016 +0100
@@ -73,8 +73,6 @@
                   mAnswerTextFmt,
                   mFreeTextFmt,
                   mChoiceTextFmt,
-                  mChoiceBarFmt,
-                  mChoiceBarInactiveFmt,
                   mChoiceVotesFmt;
 };
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)