417 lines
16 KiB
C++
417 lines
16 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 <charthelper.hxx>
|
|
#include <document.hxx>
|
|
#include <drwlayer.hxx>
|
|
#include <rangelst.hxx>
|
|
#include <chartlis.hxx>
|
|
#include <docuno.hxx>
|
|
|
|
#include <comphelper/propertyvalue.hxx>
|
|
#include <svx/svditer.hxx>
|
|
#include <svx/svdoole2.hxx>
|
|
#include <svx/svdpage.hxx>
|
|
#include <svtools/embedhlp.hxx>
|
|
#include <comphelper/diagnose_ex.hxx>
|
|
|
|
#include <com/sun/star/chart2/XChartDocument.hpp>
|
|
#include <com/sun/star/chart2/data/XDataReceiver.hpp>
|
|
#include <com/sun/star/embed/XEmbeddedObject.hpp>
|
|
#include <com/sun/star/util/XModifiable.hpp>
|
|
|
|
using namespace com::sun::star;
|
|
using ::com::sun::star::uno::Reference;
|
|
|
|
namespace
|
|
{
|
|
|
|
sal_uInt16 lcl_DoUpdateCharts( ScDocument& rDoc )
|
|
{
|
|
ScDrawLayer* pModel = rDoc.GetDrawLayer();
|
|
if (!pModel)
|
|
return 0;
|
|
|
|
sal_uInt16 nFound = 0;
|
|
|
|
sal_uInt16 nPageCount = pModel->GetPageCount();
|
|
for (sal_uInt16 nPageNo=0; nPageNo<nPageCount; nPageNo++)
|
|
{
|
|
SdrPage* pPage = pModel->GetPage(nPageNo);
|
|
OSL_ENSURE(pPage,"Page ?");
|
|
|
|
SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
{
|
|
if ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && ScDocument::IsChart( pObject ) )
|
|
{
|
|
OUString aName = static_cast<SdrOle2Obj*>(pObject)->GetPersistName();
|
|
rDoc.UpdateChart( aName );
|
|
++nFound;
|
|
}
|
|
}
|
|
}
|
|
return nFound;
|
|
}
|
|
|
|
bool lcl_AdjustRanges( ScRangeList& rRanges, SCTAB nSourceTab, SCTAB nDestTab, SCTAB nTabCount )
|
|
{
|
|
//TODO: if multiple sheets are copied, update references into the other copied sheets?
|
|
|
|
bool bChanged = false;
|
|
|
|
for ( size_t i=0, nCount = rRanges.size(); i < nCount; i++ )
|
|
{
|
|
ScRange & rRange = rRanges[ i ];
|
|
if ( rRange.aStart.Tab() == nSourceTab && rRange.aEnd.Tab() == nSourceTab )
|
|
{
|
|
rRange.aStart.SetTab( nDestTab );
|
|
rRange.aEnd.SetTab( nDestTab );
|
|
bChanged = true;
|
|
}
|
|
if ( rRange.aStart.Tab() >= nTabCount )
|
|
{
|
|
rRange.aStart.SetTab( nTabCount > 0 ? ( nTabCount - 1 ) : 0 );
|
|
bChanged = true;
|
|
}
|
|
if ( rRange.aEnd.Tab() >= nTabCount )
|
|
{
|
|
rRange.aEnd.SetTab( nTabCount > 0 ? ( nTabCount - 1 ) : 0 );
|
|
bChanged = true;
|
|
}
|
|
}
|
|
|
|
return bChanged;
|
|
}
|
|
|
|
}//end anonymous namespace
|
|
|
|
// ScChartHelper
|
|
//static
|
|
sal_uInt16 ScChartHelper::DoUpdateAllCharts( ScDocument& rDoc )
|
|
{
|
|
return lcl_DoUpdateCharts( rDoc );
|
|
}
|
|
|
|
void ScChartHelper::AdjustRangesOfChartsOnDestinationPage( const ScDocument& rSrcDoc, ScDocument& rDestDoc, const SCTAB nSrcTab, const SCTAB nDestTab )
|
|
{
|
|
ScDrawLayer* pDrawLayer = rDestDoc.GetDrawLayer();
|
|
if( !pDrawLayer )
|
|
return;
|
|
|
|
SdrPage* pDestPage = pDrawLayer->GetPage(static_cast<sal_uInt16>(nDestTab));
|
|
if( !pDestPage )
|
|
return;
|
|
|
|
SdrObjListIter aIter( pDestPage, SdrIterMode::Flat );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
{
|
|
if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast<SdrOle2Obj*>(pObject)->IsChart() )
|
|
{
|
|
OUString aChartName = static_cast<SdrOle2Obj*>(pObject)->GetPersistName();
|
|
|
|
Reference< chart2::XChartDocument > xChartDoc( rDestDoc.GetChartByName( aChartName ) );
|
|
Reference< chart2::data::XDataReceiver > xReceiver( xChartDoc, uno::UNO_QUERY );
|
|
if( xChartDoc.is() && xReceiver.is() && !xChartDoc->hasInternalDataProvider() )
|
|
{
|
|
::std::vector< ScRangeList > aRangesVector;
|
|
rDestDoc.GetChartRanges( aChartName, aRangesVector, rSrcDoc );
|
|
|
|
for( ScRangeList& rScRangeList : aRangesVector )
|
|
{
|
|
lcl_AdjustRanges( rScRangeList, nSrcTab, nDestTab, rDestDoc.GetTableCount() );
|
|
}
|
|
rDestDoc.SetChartRanges( aChartName, aRangesVector );
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
void ScChartHelper::UpdateChartsOnDestinationPage( ScDocument& rDestDoc, const SCTAB nDestTab )
|
|
{
|
|
ScDrawLayer* pDrawLayer = rDestDoc.GetDrawLayer();
|
|
if( !pDrawLayer )
|
|
return;
|
|
|
|
SdrPage* pDestPage = pDrawLayer->GetPage(static_cast<sal_uInt16>(nDestTab));
|
|
if( !pDestPage )
|
|
return;
|
|
|
|
SdrObjListIter aIter( pDestPage, SdrIterMode::Flat );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
{
|
|
if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast<SdrOle2Obj*>(pObject)->IsChart() )
|
|
{
|
|
OUString aChartName = static_cast<SdrOle2Obj*>(pObject)->GetPersistName();
|
|
Reference< chart2::XChartDocument > xChartDoc( rDestDoc.GetChartByName( aChartName ) );
|
|
Reference< util::XModifiable > xModif(xChartDoc, uno::UNO_QUERY_THROW);
|
|
xModif->setModified( true);
|
|
}
|
|
}
|
|
}
|
|
|
|
uno::Reference< chart2::XChartDocument > ScChartHelper::GetChartFromSdrObject( const SdrObject* pObject )
|
|
{
|
|
uno::Reference< chart2::XChartDocument > xReturn;
|
|
if( pObject )
|
|
{
|
|
if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast<const SdrOle2Obj*>(pObject)->IsChart() )
|
|
{
|
|
uno::Reference< embed::XEmbeddedObject > xIPObj = static_cast<const SdrOle2Obj*>(pObject)->GetObjRef();
|
|
if( xIPObj.is() )
|
|
{
|
|
(void)svt::EmbeddedObjectRef::TryRunningState( xIPObj );
|
|
uno::Reference< util::XCloseable > xComponent = xIPObj->getComponent();
|
|
xReturn.set( uno::Reference< chart2::XChartDocument >( xComponent, uno::UNO_QUERY ) );
|
|
}
|
|
}
|
|
}
|
|
return xReturn;
|
|
}
|
|
|
|
void ScChartHelper::GetChartRanges( const uno::Reference< chart2::XChartDocument >& xChartDoc,
|
|
std::vector< OUString >& rRanges )
|
|
{
|
|
rRanges.clear();
|
|
uno::Reference< chart2::data::XDataSource > xDataSource( xChartDoc, uno::UNO_QUERY );
|
|
if( !xDataSource.is() )
|
|
return;
|
|
|
|
const uno::Sequence< uno::Reference< chart2::data::XLabeledDataSequence > > aLabeledDataSequences( xDataSource->getDataSequences() );
|
|
rRanges.reserve(2*aLabeledDataSequences.getLength());
|
|
for(const uno::Reference<chart2::data::XLabeledDataSequence>& xLabeledSequence : aLabeledDataSequences)
|
|
{
|
|
if(!xLabeledSequence.is())
|
|
continue;
|
|
uno::Reference< chart2::data::XDataSequence > xLabel( xLabeledSequence->getLabel());
|
|
uno::Reference< chart2::data::XDataSequence > xValues( xLabeledSequence->getValues());
|
|
|
|
if (xLabel.is())
|
|
rRanges.push_back( xLabel->getSourceRangeRepresentation() );
|
|
if (xValues.is())
|
|
rRanges.push_back( xValues->getSourceRangeRepresentation() );
|
|
}
|
|
}
|
|
|
|
void ScChartHelper::SetChartRanges( const uno::Reference< chart2::XChartDocument >& xChartDoc,
|
|
const uno::Sequence< OUString >& rRanges )
|
|
{
|
|
uno::Reference< chart2::data::XDataSource > xDataSource( xChartDoc, uno::UNO_QUERY );
|
|
if( !xDataSource.is() )
|
|
return;
|
|
uno::Reference< chart2::data::XDataProvider > xDataProvider = xChartDoc->getDataProvider();
|
|
if( !xDataProvider.is() )
|
|
return;
|
|
|
|
xChartDoc->lockControllers();
|
|
|
|
try
|
|
{
|
|
OUString aPropertyNameRole( u"Role"_ustr );
|
|
|
|
uno::Sequence< uno::Reference< chart2::data::XLabeledDataSequence > > aLabeledDataSequences( xDataSource->getDataSequences() );
|
|
sal_Int32 nRange=0;
|
|
for( uno::Reference<chart2::data::XLabeledDataSequence>& xLabeledSequence : asNonConstRange(aLabeledDataSequences) )
|
|
{
|
|
if( nRange >= rRanges.getLength() )
|
|
break;
|
|
|
|
if(!xLabeledSequence.is())
|
|
continue;
|
|
uno::Reference< beans::XPropertySet > xLabel( xLabeledSequence->getLabel(), uno::UNO_QUERY );
|
|
uno::Reference< beans::XPropertySet > xValues( xLabeledSequence->getValues(), uno::UNO_QUERY );
|
|
|
|
if( xLabel.is())
|
|
{
|
|
uno::Reference< chart2::data::XDataSequence > xNewSeq(
|
|
xDataProvider->createDataSequenceByRangeRepresentation( rRanges[nRange++] ));
|
|
|
|
uno::Reference< beans::XPropertySet > xNewProps( xNewSeq, uno::UNO_QUERY );
|
|
if( xNewProps.is() )
|
|
xNewProps->setPropertyValue( aPropertyNameRole, xLabel->getPropertyValue( aPropertyNameRole ) );
|
|
|
|
xLabeledSequence->setLabel( xNewSeq );
|
|
}
|
|
|
|
if( nRange >= rRanges.getLength() )
|
|
break;
|
|
|
|
if( xValues.is())
|
|
{
|
|
uno::Reference< chart2::data::XDataSequence > xNewSeq(
|
|
xDataProvider->createDataSequenceByRangeRepresentation( rRanges[nRange++] ));
|
|
|
|
uno::Reference< beans::XPropertySet > xNewProps( xNewSeq, uno::UNO_QUERY );
|
|
if( xNewProps.is() )
|
|
xNewProps->setPropertyValue( aPropertyNameRole, xValues->getPropertyValue( aPropertyNameRole ) );
|
|
|
|
xLabeledSequence->setValues( xNewSeq );
|
|
}
|
|
}
|
|
}
|
|
catch (const uno::Exception&)
|
|
{
|
|
TOOLS_WARN_EXCEPTION( "sc", "Exception in ScChartHelper::SetChartRanges - invalid range string?");
|
|
}
|
|
|
|
xChartDoc->unlockControllers();
|
|
}
|
|
|
|
void ScChartHelper::AddRangesIfProtectedChart( ScRangeListVector& rRangesVector, const ScDocument& rDocument, SdrObject* pObject )
|
|
{
|
|
if ( !(pObject && ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 )) )
|
|
return;
|
|
|
|
SdrOle2Obj* pSdrOle2Obj = dynamic_cast< SdrOle2Obj* >( pObject );
|
|
if ( !(pSdrOle2Obj && pSdrOle2Obj->IsChart()) )
|
|
return;
|
|
|
|
const uno::Reference< embed::XEmbeddedObject >& xEmbeddedObj = pSdrOle2Obj->GetObjRef();
|
|
if ( !xEmbeddedObj.is() )
|
|
return;
|
|
|
|
bool bDisableDataTableDialog = false;
|
|
sal_Int32 nOldState = xEmbeddedObj->getCurrentState();
|
|
(void)svt::EmbeddedObjectRef::TryRunningState( xEmbeddedObj );
|
|
uno::Reference< beans::XPropertySet > xProps( xEmbeddedObj->getComponent(), uno::UNO_QUERY );
|
|
if ( xProps.is() &&
|
|
( xProps->getPropertyValue(u"DisableDataTableDialog"_ustr) >>= bDisableDataTableDialog ) &&
|
|
bDisableDataTableDialog )
|
|
{
|
|
ScChartListenerCollection* pCollection = rDocument.GetChartListenerCollection();
|
|
if (pCollection)
|
|
{
|
|
const OUString& aChartName = pSdrOle2Obj->GetPersistName();
|
|
const ScChartListener* pListener = pCollection->findByName(aChartName);
|
|
if (pListener)
|
|
{
|
|
const ScRangeListRef xRangeList = pListener->GetRangeList();
|
|
if ( xRangeList.is() )
|
|
{
|
|
rRangesVector.push_back( *xRangeList );
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if ( xEmbeddedObj->getCurrentState() != nOldState )
|
|
{
|
|
xEmbeddedObj->changeState( nOldState );
|
|
}
|
|
}
|
|
|
|
void ScChartHelper::FillProtectedChartRangesVector( ScRangeListVector& rRangesVector, const ScDocument& rDocument, const SdrPage* pPage )
|
|
{
|
|
if ( pPage )
|
|
{
|
|
SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
AddRangesIfProtectedChart( rRangesVector, rDocument, pObject );
|
|
}
|
|
}
|
|
|
|
void ScChartHelper::GetChartNames( ::std::vector< OUString >& rChartNames, const SdrPage* pPage )
|
|
{
|
|
if ( !pPage )
|
|
return;
|
|
|
|
SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
{
|
|
if ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 )
|
|
{
|
|
SdrOle2Obj* pSdrOle2Obj = dynamic_cast< SdrOle2Obj* >( pObject );
|
|
if ( pSdrOle2Obj && pSdrOle2Obj->IsChart() )
|
|
{
|
|
rChartNames.push_back( pSdrOle2Obj->GetPersistName() );
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
void ScChartHelper::CreateProtectedChartListenersAndNotify( ScDocument& rDoc, const SdrPage* pPage, ScModelObj* pModelObj, SCTAB nTab,
|
|
const ScRangeListVector& rRangesVector, const ::std::vector< OUString >& rExcludedChartNames, bool bSameDoc )
|
|
{
|
|
if ( !(pPage && pModelObj) )
|
|
return;
|
|
|
|
size_t nRangeListCount = rRangesVector.size();
|
|
size_t nRangeList = 0;
|
|
SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups );
|
|
while (SdrObject* pObject = aIter.Next())
|
|
{
|
|
if ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 )
|
|
{
|
|
SdrOle2Obj* pSdrOle2Obj = dynamic_cast< SdrOle2Obj* >( pObject );
|
|
if ( pSdrOle2Obj && pSdrOle2Obj->IsChart() )
|
|
{
|
|
const OUString& aChartName = pSdrOle2Obj->GetPersistName();
|
|
::std::vector< OUString >::const_iterator aEnd = rExcludedChartNames.end();
|
|
::std::vector< OUString >::const_iterator aFound = ::std::find( rExcludedChartNames.begin(), aEnd, aChartName );
|
|
if ( aFound == aEnd )
|
|
{
|
|
const uno::Reference< embed::XEmbeddedObject >& xEmbeddedObj = pSdrOle2Obj->GetObjRef();
|
|
if ( xEmbeddedObj.is() && ( nRangeList < nRangeListCount ) )
|
|
{
|
|
bool bDisableDataTableDialog = false;
|
|
(void)svt::EmbeddedObjectRef::TryRunningState( xEmbeddedObj );
|
|
uno::Reference< beans::XPropertySet > xProps( xEmbeddedObj->getComponent(), uno::UNO_QUERY );
|
|
if ( xProps.is() &&
|
|
( xProps->getPropertyValue(u"DisableDataTableDialog"_ustr) >>= bDisableDataTableDialog ) &&
|
|
bDisableDataTableDialog )
|
|
{
|
|
if ( bSameDoc )
|
|
{
|
|
ScChartListenerCollection* pCollection = rDoc.GetChartListenerCollection();
|
|
if (pCollection && !pCollection->findByName(aChartName))
|
|
{
|
|
ScRangeListRef rRangeList(new ScRangeList(rRangesVector[nRangeList++]));
|
|
ScChartListener* pChartListener = new ScChartListener( aChartName, rDoc, rRangeList );
|
|
pCollection->insert( pChartListener );
|
|
pChartListener->StartListeningTo();
|
|
}
|
|
}
|
|
else
|
|
{
|
|
xProps->setPropertyValue(u"DisableDataTableDialog"_ustr,
|
|
uno::Any( false ) );
|
|
xProps->setPropertyValue(u"DisableComplexChartTypes"_ustr,
|
|
uno::Any( false ) );
|
|
}
|
|
}
|
|
}
|
|
|
|
if (pModelObj->HasChangesListeners())
|
|
{
|
|
tools::Rectangle aRectangle = pSdrOle2Obj->GetSnapRect();
|
|
ScRange aRange( rDoc.GetRange( nTab, aRectangle ) );
|
|
ScRangeList aChangeRanges( aRange );
|
|
|
|
uno::Sequence< beans::PropertyValue > aProperties{
|
|
comphelper::makePropertyValue(u"Name"_ustr, aChartName)
|
|
};
|
|
|
|
pModelObj->NotifyChanges( u"insert-chart"_ustr, aChangeRanges, aProperties );
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|