diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
commit | 267c6f2ac71f92999e969232431ba04678e7437e (patch) | |
tree | 358c9467650e1d0a1d7227a21dac2e3d08b622b2 /sc/source/ui/vba/vbaname.cxx | |
parent | Initial commit. (diff) | |
download | libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.tar.xz libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.zip |
Adding upstream version 4:24.2.0.upstream/4%24.2.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sc/source/ui/vba/vbaname.cxx')
-rw-r--r-- | sc/source/ui/vba/vbaname.cxx | 219 |
1 files changed, 219 insertions, 0 deletions
diff --git a/sc/source/ui/vba/vbaname.cxx b/sc/source/ui/vba/vbaname.cxx new file mode 100644 index 0000000000..98a242401e --- /dev/null +++ b/sc/source/ui/vba/vbaname.cxx @@ -0,0 +1,219 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#include "excelvbahelper.hxx" +#include "vbaname.hxx" +#include "vbarange.hxx" +#include <docsh.hxx> +#include <rangenam.hxx> +#include <nameuno.hxx> +#include <compiler.hxx> +#include <tokenarray.hxx> + +#include <comphelper/servicehelper.hxx> + +#include <memory> +#include <utility> + +using namespace ::ooo::vba; +using namespace ::com::sun::star; + +ScVbaName::ScVbaName(const css::uno::Reference< ov::XHelperInterface >& xParent, + const css::uno::Reference< css::uno::XComponentContext >& xContext, + css::uno::Reference< css::sheet::XNamedRange > xName, + css::uno::Reference< css::sheet::XNamedRanges > xNames, + css::uno::Reference< css::frame::XModel > xModel ): + NameImpl_BASE( xParent , xContext ), + mxModel(std::move( xModel )), + mxNamedRange(std::move( xName )), + mxNames(std::move( xNames )) +{ +} + +ScVbaName::~ScVbaName() +{ +} + +OUString +ScVbaName::getName() +{ + return mxNamedRange->getName(); +} + +void +ScVbaName::setName( const OUString & rName ) +{ + mxNamedRange->setName( rName ); +} + +OUString +ScVbaName::getNameLocal() +{ + return getName(); +} + +void +ScVbaName::setNameLocal( const OUString & rName ) +{ + setName( rName ); +} + +sal_Bool +ScVbaName::getVisible() +{ + return true; +} + +void +ScVbaName::setVisible( sal_Bool /*bVisible*/ ) +{ +} + +OUString ScVbaName::getContent( const formula::FormulaGrammar::Grammar eGrammar ) +{ + ScNamedRangeObj* pNamedRange = dynamic_cast< ScNamedRangeObj* >( mxNamedRange.get() ); + OUString aContent; + if ( pNamedRange ) + { + ScRangeData* pData = pNamedRange->GetRangeData_Impl(); + if (pData) + aContent = pData->GetSymbol( eGrammar ); + } + if (aContent.indexOf('=') != 0) + aContent = "=" + aContent; + return aContent; +} + +void ScVbaName::setContent( const OUString& rContent, const formula::FormulaGrammar::Grammar eGrammar ) +{ + OUString sContent( rContent ); + if (sContent.startsWith("=")) + sContent = sContent.copy(1); + ScNamedRangeObj* pNamedRange = dynamic_cast< ScNamedRangeObj* >( mxNamedRange.get() ); + + // We should be able to do the below by just setting calling SetCode on pNamedRange + // right? + if ( !(pNamedRange && pNamedRange->pDocShell) ) + return; + + ScDocument& rDoc = pNamedRange->pDocShell->GetDocument(); + ScRangeData* pOldData = pNamedRange->GetRangeData_Impl(); + if (pOldData) + { + // Shorter way of doing this ? + ScCompiler aComp( rDoc, pOldData->GetPos(), eGrammar ); + std::unique_ptr<ScTokenArray> pArray(aComp.CompileString(sContent)); + pOldData->SetCode(*pArray); + } +} + +OUString +ScVbaName::getValue() +{ + OUString sResult = getContent( formula::FormulaGrammar::GRAM_NATIVE_XL_A1 ); + + return sResult; +} + +void +ScVbaName::setValue( const OUString & rValue ) +{ + setContent( rValue, formula::FormulaGrammar::GRAM_NATIVE_XL_A1 ); +} + +OUString +ScVbaName::getRefersTo() +{ + return getValue(); +} + +void +ScVbaName::setRefersTo( const OUString & rRefersTo ) +{ + setValue( rRefersTo ); +} + +OUString +ScVbaName::getRefersToLocal() +{ + return getRefersTo(); +} + +void +ScVbaName::setRefersToLocal( const OUString & rRefersTo ) +{ + setRefersTo( rRefersTo ); +} + +OUString +ScVbaName::getRefersToR1C1() +{ + OUString sResult = getContent( formula::FormulaGrammar::GRAM_NATIVE_XL_R1C1 ); + return sResult; +} + +void +ScVbaName::setRefersToR1C1( const OUString & rRefersTo ) +{ + setContent( rRefersTo, formula::FormulaGrammar::GRAM_NATIVE_XL_R1C1 ); +} + +OUString +ScVbaName::getRefersToR1C1Local() +{ + return getRefersToR1C1(); +} + +void +ScVbaName::setRefersToR1C1Local( const OUString & rRefersTo ) +{ + setRefersTo( rRefersTo ); +} + +css::uno::Reference< ov::excel::XRange > +ScVbaName::getRefersToRange() +{ + uno::Reference< ov::excel::XRange > xRange = ScVbaRange::getRangeObjectForName( + mxContext, mxNamedRange->getName(), excel::getDocShell( mxModel ), formula::FormulaGrammar::CONV_XL_R1C1 ); + return xRange; +} + +void +ScVbaName::Delete() +{ + mxNames->removeByName( mxNamedRange->getName() ); +} + +OUString +ScVbaName::getServiceImplName() +{ + return "ScVbaName"; +} + +uno::Sequence< OUString > +ScVbaName::getServiceNames() +{ + static uno::Sequence< OUString > const aServiceNames + { + "ooo.vba.excel.Name" + }; + return aServiceNames; +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |