219 lines
5.2 KiB
C++
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: */
|