File indexing completed on 2024-05-12 16:35:39

 /* This file is part of the KDE project
    Copyright 1998-2016 The Calligra Team <calligra-devel@kde.org>
    Copyright 2016 Tomas Mecir <mecirt@gmail.com>
    Copyright 2010 Marijn Kruisselbrink <mkruisselbrink@kde.org>
    Copyright 2007 Stefan Nikolaus <stefan.nikolaus@kdemail.net>
    Copyright 2007 Thorsten Zachmann <zachmann@kde.org>
    Copyright 2005-2006 Inge Wallin <inge@lysator.liu.se>
    Copyright 2004 Ariya Hidayat <ariya@kde.org>
    Copyright 2002-2003 Norbert Andres <nandres@web.de>
    Copyright 2000-2002 Laurent Montel <montel@kde.org>
    Copyright 2002 John Dailey <dailey@vt.edu>
    Copyright 2002 Phillip Mueller <philipp.mueller@gmx.de>
    Copyright 2000 Werner Trobin <trobin@kde.org>
    Copyright 1999-2000 Simon Hausmann <hausmann@kde.org>
    Copyright 1999 David Faure <faure@kde.org>
    Copyright 1998-2000 Torben Weis <weis@kde.org>
 
    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 "SheetsOdf.h"
 #include "SheetsOdfPrivate.h"
 #include "Region.h"
 
 // This file contains functionality to load/save regions
 
 namespace Calligra {
 namespace Sheets {
 
 static void append(const QChar *from, const QChar *to, QChar **dest)
 {
     while (from < to) {
         **dest = *from;
         ++from;
         ++*dest;
     }
 }
 
 void Odf::loadRegion(const QChar *&data, const QChar *&end, QChar *&out)
 {
     enum { Start, InQuotes } state = Start;
 
     if (*data == QChar('$', 0)) {
         ++data;
     }
 
     bool isRange = false;
 
     const QChar *pos = data;
     while (data < end) {
         switch (state) {
         case Start:
             switch (data->unicode()) {
             case '\'': // quoted sheet name or named area
                 state = InQuotes;
                 break;
             case '.': // sheet name separator
                 if (pos != data && !isRange) {
                     append(pos, data, &out);
                     *out = QChar('!', 0);
                     ++out;
                 }
                 pos = data;
                 ++pos;
                 break;
             case ':': { // cell separator
                 isRange = true;
                 append(pos, data, &out);
                 *out = *data; // append :
                 ++out;
                 const QChar * next = data + 1;
                 if (!next->isNull()) {
                     const QChar * nextnext = next + 1;
                     if (!nextnext->isNull() && *next == QChar('$', 0) && *nextnext != QChar('.', 0)) {
                         ++data;
                     }
                 }
                 pos = data + 1;
             }   break;
             case ' ': // range separator
                 append(pos, data, &out);
                 *out = QChar(';', 0);
                 ++out;
                 pos = data;
                 break;
             default:
                 break;
             }
             break;
         case InQuotes:
             if (data->unicode() == '\'') {
                 // an escaped apostrophe?
                 // As long as Calligra Sheets does not support fixed sheets eat the dollar sign.
                 const QChar * next = data + 1;
                 if (!next->isNull() && *next == QChar('\'', 0)) {
                     ++data;
                 }
                 else { // the end
                     state = Start;
                 }
             }
             break;
         }
         ++data;
     }
     append(pos, data, &out);
 }
 
 QString Odf::loadRegion(const QString& expression)
 {
     QString result;
     QString temp;
     bool isRange = false;
     enum { Start, InQuotes } state = Start;
     int i = 0;
     // NOTE Stefan: As long as Calligra Sheets does not support fixed sheets eat the dollar sign.
     if (expression[i] == '$')
         ++i;
     while (i < expression.count()) {
         switch (state) {
         case Start: {
             if (expression[i] == '\'') { // quoted sheet name or named area
                 temp.append(expression[i]);
                 state = InQuotes;
             } else if (expression[i] == '.') { // sheet name separator
                 // was there already a sheet name?
                 if (!temp.isEmpty() && !isRange) {
                     result.append(temp);
                     result.append('!');
                 }
                 temp.clear();
             } else if (expression[i] == ':') { // cell separator
                 isRange = true;
                 result.append(temp);
                 result.append(':');
                 temp.clear();
                 // NOTE Stefan: As long as Calligra Sheets does not support fixed sheets eat the dollar sign.
                 if (i + 2 < expression.count() && expression[i+1] == '$' && expression[i+2] != '.')
                     ++i;
             } else if (expression[i] == ' ') { // range separator
                 result.append(temp);
                 result.append(';');
                 temp.clear();
             } else
                 temp.append(expression[i]);
             ++i;
             break;
         }
         case InQuotes: {
             temp.append(expression[i]);
             if (expression[i] == '\'') {
                 // an escaped apostrophe?
                 if (i + 1 < expression.count() && expression[i+1] == '\'')
                     ++i; // eat it
                 else // the end
                     state = Start;
             }
             ++i;
             break;
         }
         }
     }
     return result + temp;
 }
 
 QString Odf::saveRegion(const QString& expression)
 {
     QString result;
     QString sheetName;
     QString temp;
     enum { Start, InQuotes } state = Start;
     int i = 0;
     while (i < expression.count()) {
         switch (state) {
         case Start: {
             if (expression[i] == '\'') {
                 temp.append(expression[i]);
                 state = InQuotes;
             } else if (expression[i] == '!') { // sheet name separator
                 // There has to be a sheet name.
                 if (temp.isEmpty())
                     return expression; // error
                 if (temp.count() > 2 && (temp[0] != '\'' && temp[temp.count()-1] != '\'')) {
                     temp.replace('\'', "''");
                     if (temp.contains(' ') || temp.contains('.') ||
                             temp.contains(';') || temp.contains('!') ||
                             temp.contains('$') || temp.contains(']'))
                         temp = '\'' + temp + '\'';
                 }
                 sheetName = temp;
                 result.append(temp);
                 result.append('.');
                 temp.clear();
             } else if (expression[i] == ':') { // cell separator
                 if (result.isEmpty())
                     result = '.';
                 result.append(temp);
                 result.append(':');
                 result.append(sheetName);
                 result.append('.');
                 temp.clear();
             } else if (expression[i] == ';') { // range separator
                 result.append(temp);
                 result.append(' ');
                 temp.clear();
             } else
                 temp.append(expression[i]);
             ++i;
             break;
         }
         case InQuotes: {
             temp.append(expression[i]);
             if (expression[i] == '\'') {
                 // an escaped apostrophe?
                 if (i + 1 < expression.count() && expression[i+1] == '\'')
                     ++i; // eat it
                 else // the end
                     state = Start;
             }
             ++i;
             break;
         }
         }
     }
     if (result.isEmpty())
         result = '.';
     return result + temp;
 }
 
 QString Odf::saveRegion(Region *region)
 {
     return saveRegion(region->name());
 }
 
 
 }  // Sheets
 }  // Calligra