1
0
Fork 0
libreoffice/sc/source/ui/vba/vbaname.cxx
Daniel Baumann 8e63e14cf6
Adding upstream version 4:25.2.3.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
2025-06-22 16:20:04 +02:00

219 lines
5.2 KiB
C++

/* -*- 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 u"ScVbaName"_ustr;
}
uno::Sequence< OUString >
ScVbaName::getServiceNames()
{
static uno::Sequence< OUString > const aServiceNames
{
u"ooo.vba.excel.Name"_ustr
};
return aServiceNames;
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */