summaryrefslogtreecommitdiffstats
path: root/kspread/kspread_genvalidationstyle.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'kspread/kspread_genvalidationstyle.cpp')
-rw-r--r--kspread/kspread_genvalidationstyle.cpp401
1 files changed, 401 insertions, 0 deletions
diff --git a/kspread/kspread_genvalidationstyle.cpp b/kspread/kspread_genvalidationstyle.cpp
new file mode 100644
index 000000000..613be1769
--- /dev/null
+++ b/kspread/kspread_genvalidationstyle.cpp
@@ -0,0 +1,401 @@
+/* This file is part of the KDE project
+
+ Copyright 2004 Laurent Montel <montel@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 "kspread_genvalidationstyle.h"
+#include "kspread_cell.h"
+#include <KoXmlWriter.h>
+
+using namespace KSpread;
+
+GenValidationStyles::GenValidationStyles()
+{
+
+}
+
+GenValidationStyles::~GenValidationStyles()
+{
+
+}
+
+TQString GenValidationStyles::lookup( const GenValidationStyle& style )
+{
+ StyleMap::iterator it = m_styles.find( style );
+ if ( it == m_styles.end() ) {
+
+ TQString styleName( "val" );
+ styleName = makeUniqueName( styleName );
+ m_names.insert( styleName, true );
+ it = m_styles.insert( style, styleName );
+ }
+ return it.data();
+}
+
+TQString GenValidationStyles::makeUniqueName( const TQString& base ) const
+{
+ int num = 1;
+ TQString name;
+ do {
+ name = base;
+ name += TQString::number( num++ );
+ } while ( m_names.find( name ) != m_names.end() );
+ return name;
+}
+
+void GenValidationStyles::writeStyle( KoXmlWriter& writer )
+{
+ if ( m_styles.count()>0 )
+ {
+ writer.startElement( "table:content-validations" );
+ StyleMap::Iterator it;
+ for ( it = m_styles.begin(); it != m_styles.end(); ++it )
+ {
+ writer.startElement( "table:content-validation" );
+ writer.addAttribute( "table:name", it.data() );
+ writer.addAttribute( "table:allow-empty-cell", it.key().allowEmptyCell );
+ writer.addAttribute( "table:condition", it.key().condition );
+
+ writer.startElement( "table:help-message" );
+ writer.addAttribute( "table:title", it.key().title );
+ writer.addAttribute( "table:display", it.key().displayValidationInformation );
+
+ TQStringList text = TQStringList::split( "\n", it.key().messageInfo );
+ for ( TQStringList::Iterator it2 = text.begin(); it2 != text.end(); ++it2 ) {
+ writer.startElement( "text:p" );
+ writer.addTextNode( *it2 );
+ writer.endElement();
+ }
+ writer.endElement();
+
+ writer.startElement( "table:error-message" );
+ writer.addAttribute( "table:message-type", it.key().messageType );
+
+ writer.addAttribute("table:title", it.key().titleInfo);
+ writer.addAttribute("table:display", it.key().displayMessage);
+ text = TQStringList::split( "\n", it.key().message );
+ for ( TQStringList::Iterator it3 = text.begin(); it3 != text.end(); ++it3 ) {
+ writer.startElement( "text:p" );
+ writer.addTextNode( *it3 );
+ writer.endElement();
+ }
+ writer.endElement();
+
+ writer.endElement();
+ }
+ writer.endElement();//close sheet:content-validation
+ }
+}
+
+void GenValidationStyle::initVal( Validity *_val )
+{
+ if ( _val )
+ {
+ allowEmptyCell = ( _val->allowEmptyCell ? "true" : "false" );
+ condition = createValidationCondition( _val );
+ title = _val->title;
+ displayValidationInformation = ( _val->displayValidationInformation ? "true" : "false" );
+ messageInfo = _val->messageInfo;
+
+ switch( _val->m_action )
+ {
+ case Action::Warning:
+ messageType = "warning";
+ break;
+ case Action::Information:
+ messageType = "information";
+ break;
+ case Action::Stop:
+ messageType = "stop";
+ break;
+ }
+
+ titleInfo = _val->titleInfo;
+ displayMessage = ( _val->displayMessage ? "true" : "false" );
+ message = _val->message;
+ }
+}
+
+TQString GenValidationStyle::createValidationCondition( Validity* _val )
+{
+ TQString result;
+ switch( _val->m_restriction )
+ {
+ case Restriction::None:
+ //nothing
+ break;
+ case Restriction::Text:
+ //doesn't exist into oo spec
+ result = "cell-content-is-text()";
+ break;
+ case Restriction::Time:
+ result = createTimeValidationCondition( _val );
+ break;
+ case Restriction::Date:
+ result = createDateValidationCondition( _val );
+ break;
+ case Restriction::Integer:
+ case Restriction::Number:
+ result = createNumberValidationCondition( _val );
+ break;
+ case Restriction::TextLength:
+ result = createTextValidationCondition( _val );
+ break;
+ case Restriction::List:
+ result = createListValidationCondition( _val );
+ break;
+ }
+ return result;
+}
+
+TQString GenValidationStyle::createListValidationCondition( Validity* _val )
+{
+ TQString result = "oooc:cell-content-is-in-list(";
+ result = _val->listValidity.join( ";" );
+ result +=")";
+ return result;
+}
+
+TQString GenValidationStyle::createNumberValidationCondition( Validity* _val )
+{
+ TQString result;
+ if ( _val->m_restriction == Restriction::Number )
+ result = "oooc:cell-content-is-whole-number() and ";
+ else if ( _val->m_restriction == Restriction::Integer )
+ result = "oooc:cell-content-is-decimal-number() and ";
+ switch( _val->m_cond )
+ {
+ case Conditional::None:
+ //nothing
+ break;
+ case Conditional::Equal:
+ result+="cell-content()";
+ result+="=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Superior:
+ result+="cell-content()";
+ result+=">";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Inferior:
+ result+="cell-content()";
+ result+="<";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::SuperiorEqual:
+ result+="cell-content()";
+ result+=">=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::InferiorEqual:
+ result+="cell-content()";
+ result+="<=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Different:
+ result+="cell-content()";
+ result+="!=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Between:
+ result+="cell-content-is-between(";
+ result+=TQString::number( _val->valMin );
+ result+=",";
+ result+=TQString::number( _val->valMax );
+ result+=")";
+ break;
+ case Conditional::DifferentTo:
+ result+="cell-content-is-not-between(";
+ result+=TQString::number( _val->valMin );
+ result+=",";
+ result+=TQString::number( _val->valMax );
+ result+=")";
+ break;
+ }
+ return result;
+}
+
+
+TQString GenValidationStyle::createTimeValidationCondition( Validity* _val )
+{
+ TQString result( "oooc:cell-content-is-time() and " );
+ switch( _val->m_cond )
+ {
+ case Conditional::None:
+ //nothing
+ break;
+ case Conditional::Equal:
+ result+="cell-content()";
+ result+="=";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::Superior:
+ result+="cell-content()";
+ result+=">";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::Inferior:
+ result+="cell-content()";
+ result+="<";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::SuperiorEqual:
+ result+="cell-content()";
+ result+=">=";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::InferiorEqual:
+ result+="cell-content()";
+ result+="<=";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::Different:
+ result+="cell-content()";
+ result+="!=";
+ result+=_val->timeMin.toString( );
+ break;
+ case Conditional::Between:
+ result+="cell-content-is-between(";
+ result+=_val->timeMin.toString( );
+ result+=",";
+ result+=_val->timeMax.toString( );
+ result+=")";
+ break;
+ case Conditional::DifferentTo:
+ result+="cell-content-is-not-between(";
+ result+=_val->timeMin.toString( );
+ result+=",";
+ result+=_val->timeMax.toString( );
+ result+=")";
+ break;
+ }
+ return result;
+}
+
+TQString GenValidationStyle::createDateValidationCondition( Validity* _val )
+{
+ TQString result( "oooc:cell-content-is-date() and " );
+ switch( _val->m_cond )
+ {
+ case Conditional::None:
+ //nothing
+ break;
+ case Conditional::Equal:
+ result+="cell-content()";
+ result+="=";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::Superior:
+ result+="cell-content()";
+ result+=">";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::Inferior:
+ result+="cell-content()";
+ result+="<";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::SuperiorEqual:
+ result+="cell-content()";
+ result+=">=";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::InferiorEqual:
+ result+="cell-content()";
+ result+="<=";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::Different:
+ result+="cell-content()";
+ result+="!=";
+ result+=_val->dateMin.toString();
+ break;
+ case Conditional::Between:
+ result+="cell-content-is-between(";
+ result+=_val->dateMin.toString();
+ result+=",";
+ result+=_val->dateMax.toString();
+ result+=")";
+ break;
+ case Conditional::DifferentTo:
+ result+="cell-content-is-not-between(";
+ result+=_val->dateMin.toString();
+ result+=",";
+ result+=_val->dateMax.toString();
+ result+=")";
+ break;
+ }
+ return result;
+}
+
+TQString GenValidationStyle::createTextValidationCondition( Validity* _val )
+{
+ TQString result;
+ switch( _val->m_cond )
+ {
+ case Conditional::None:
+ //nothing
+ break;
+ case Conditional::Equal:
+ result+="oooc:cell-content-text-length()";
+ result+="=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Superior:
+ result+="oooc:cell-content-text-length()";
+ result+=">";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Inferior:
+ result+="oooc:cell-content-text-length()";
+ result+="<";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::SuperiorEqual:
+ result+="oooc:cell-content-text-length()";
+ result+=">=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::InferiorEqual:
+ result+="oooc:cell-content-text-length()";
+ result+="<=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Different:
+ result+="oooc:cell-content-text-length()";
+ result+="!=";
+ result+=TQString::number( _val->valMin );
+ break;
+ case Conditional::Between:
+ result+="oooc:cell-content-text-length-is-between(";
+ result+=TQString::number( _val->valMin );
+ result+=",";
+ result+=TQString::number( _val->valMax );
+ result+=")";
+ break;
+ case Conditional::DifferentTo:
+ result+="oooc:cell-content-text-length-is-not-between(";
+ result+=TQString::number( _val->valMin );
+ result+=",";
+ result+=TQString::number( _val->valMax );
+ result+=")";
+ break;
+ }
+ return result;
+}
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-30 22:14:03 +0000