sc/source/ui/vba/vbaformatcondition.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19 #include "vbaformatcondition.hxx"
  20 #include "vbaformatconditions.hxx"
  21 #include <ooo/vba/excel/XlFormatConditionType.hpp>
  22
  23 using namespace ::ooo::vba;
  24 using namespace ::com::sun::star;
  25
  26 static ScVbaFormatConditions*
  27 lcl_getScVbaFormatConditionsPtr( const uno::Reference< excel::XFormatConditions >& xFormatConditions ) throw ( script::BasicErrorException )
  28 {
  29     ScVbaFormatConditions* pFormatConditions = static_cast< ScVbaFormatConditions* >( xFormatConditions.get() );
  30     if ( !pFormatConditions )
  31         DebugHelper::exception(SbERR_METHOD_FAILED, OUString() );
  32     return pFormatConditions;
  33 }
  34 ScVbaFormatCondition::ScVbaFormatCondition(  const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XComponentContext > & xContext, const uno::Reference< sheet::XSheetConditionalEntry >& _xSheetConditionalEntry, const uno::Reference< excel::XStyle >& _xStyle, const uno::Reference< excel::XFormatConditions >& _xFormatConditions, const uno::Reference< css::beans::XPropertySet >& _xPropertySet ) throw ( css::uno::RuntimeException ) : ScVbaFormatCondition_BASE( xParent, xContext, uno::Reference< sheet::XSheetCondition >( _xSheetConditionalEntry, css::uno::UNO_QUERY_THROW ) ), moFormatConditions( _xFormatConditions ), mxStyle( _xStyle ), mxParentRangePropertySet( _xPropertySet )
  35 {
  36         mxSheetConditionalEntries = lcl_getScVbaFormatConditionsPtr( moFormatConditions )->getSheetConditionalEntries();
  37
  38         mxSheetConditionalEntry = _xSheetConditionalEntry;
  39         msStyleName = mxStyle->getName();
  40 }
  41
  42
  43 void SAL_CALL
  44 ScVbaFormatCondition::Delete(  ) throw (script::BasicErrorException, uno::RuntimeException)
  45 {
  46     ScVbaFormatConditions* pFormatConditions = lcl_getScVbaFormatConditionsPtr( moFormatConditions );
  47     pFormatConditions->removeFormatCondition(msStyleName, sal_True);
  48         notifyRange();
  49 }
  50
  51 void SAL_CALL
  52 ScVbaFormatCondition::Modify( ::sal_Int32 _nType, const uno::Any& _aOperator, const uno::Any& _aFormula1, const uno::Any& _aFormula2 ) throw (script::BasicErrorException, uno::RuntimeException)
  53 {
  54     try
  55     {
  56         ScVbaFormatConditions* pFormatConditions = lcl_getScVbaFormatConditionsPtr( moFormatConditions );
  57         pFormatConditions->removeFormatCondition(msStyleName, false);
  58         pFormatConditions->Add(_nType, _aOperator, _aFormula1, _aFormula2, mxStyle);
  59     }
  60     catch (uno::Exception& )
  61     {
  62         DebugHelper::exception(SbERR_METHOD_FAILED, OUString() );
  63     }
  64 }
  65
  66 uno::Reference< excel::XInterior > SAL_CALL
  67 ScVbaFormatCondition::Interior(  ) throw (script::BasicErrorException, uno::RuntimeException)
  68 {
  69     return mxStyle->Interior();
  70 }
  71
  72 uno::Reference< excel::XFont > SAL_CALL
  73 ScVbaFormatCondition::Font(  ) throw (script::BasicErrorException, uno::RuntimeException)
  74 {
  75     return mxStyle->Font();
  76 }
  77 uno::Any SAL_CALL
  78 ScVbaFormatCondition::Borders( const uno::Any& Index ) throw (script::BasicErrorException, uno::RuntimeException)
  79 { return mxStyle->Borders( Index );
  80 }
  81
  82 sheet::ConditionOperator
  83 ScVbaFormatCondition::retrieveAPIType(sal_Int32 _nVBAType, const uno::Reference< sheet::XSheetCondition >& _xSheetCondition ) throw ( script::BasicErrorException )
  84 {
  85     sheet::ConditionOperator aAPIType = sheet::ConditionOperator_NONE;
  86     switch (_nVBAType)
  87     {
  88         case excel::XlFormatConditionType::xlExpression:
  89             aAPIType = sheet::ConditionOperator_FORMULA;
  90             break;
  91         case excel::XlFormatConditionType::xlCellValue:
  92             if ( _xSheetCondition.is() && (_xSheetCondition->getOperator() == sheet::ConditionOperator_FORMULA ) )
  93                 aAPIType = sheet::ConditionOperator_NONE;
  94             break;
  95         default:
  96             DebugHelper::exception(SbERR_METHOD_FAILED, OUString() );
  97     }
  98     return aAPIType;
  99 }
 100
 101 void
 102 ScVbaFormatCondition::setFormula1( const uno::Any& _aFormula1) throw ( script::BasicErrorException )
 103 {
 104     // getA1Formula *SHOULD* detect whether the formula is r1c1 or A1 syntax
 105     // and if R1C1 convert to A1
 106     ScVbaFormatCondition_BASE::setFormula1( uno::makeAny( lcl_getScVbaFormatConditionsPtr( moFormatConditions )->getA1Formula(_aFormula1) ) );
 107 }
 108
 109 void
 110 ScVbaFormatCondition::setFormula2( const uno::Any& _aFormula2) throw ( script::BasicErrorException )
 111 {
 112     ScVbaFormatCondition_BASE::setFormula1( uno::makeAny( lcl_getScVbaFormatConditionsPtr( moFormatConditions )->getA1Formula(_aFormula2)) );
 113 }
 114
 115 ::sal_Int32 SAL_CALL
 116 ScVbaFormatCondition::Type(  ) throw ( script::BasicErrorException, uno::RuntimeException )
 117 {
 118     sal_Int32 nReturnType = 0;
 119     if ( mxSheetCondition->getOperator() == sheet::ConditionOperator_FORMULA)
 120         nReturnType = excel::XlFormatConditionType::xlExpression;
 121     else
 122         nReturnType = excel::XlFormatConditionType::xlCellValue;
 123     return nReturnType;
 124 }
 125
 126
 127 ::sal_Int32
 128 ScVbaFormatCondition::Operator( sal_Bool bVal ) throw (script::BasicErrorException )
 129 {
 130     return ScVbaFormatCondition_BASE::Operator( bVal );
 131 }
 132 ::sal_Int32 SAL_CALL
 133 ScVbaFormatCondition::Operator(  ) throw (script::BasicErrorException, uno::RuntimeException)
 134 {
 135     return ScVbaFormatCondition_BASE::Operator( sal_True );
 136 }
 137
 138 void
 139 ScVbaFormatCondition::notifyRange() throw ( script::BasicErrorException )
 140 {
 141     try
 142     {
 143         mxParentRangePropertySet->setPropertyValue("ConditionalFormat", uno::makeAny( mxSheetConditionalEntries) );
 144     }
 145     catch (uno::Exception& )
 146     {
 147         DebugHelper::exception(SbERR_METHOD_FAILED, OUString() );
 148     }
 149 }
 150
 151 OUString
 152 ScVbaFormatCondition::getServiceImplName()
 153 {
 154     return OUString("ScVbaFormatCondition");
 155 }
 156
 157 uno::Sequence< OUString >
 158 ScVbaFormatCondition::getServiceNames()
 159 {
 160     static uno::Sequence< OUString > aServiceNames;
 161     if ( aServiceNames.getLength() == 0 )
 162     {
 163         aServiceNames.realloc( 1 );
 164         aServiceNames[ 0 ] = "ooo.vba.excel.FormatCondition";
 165     }
 166     return aServiceNames;
 167 }
 168
 169 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */