/* -*- 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 #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include 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; nPageNoGetPage(nPageNo); OSL_ENSURE(pPage,"Page ?"); SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups ); SdrObject* pObject = aIter.Next(); while (pObject) { if ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && ScDocument::IsChart( pObject ) ) { OUString aName = static_cast(pObject)->GetPersistName(); rDoc.UpdateChart( aName ); ++nFound; } pObject = aIter.Next(); } } 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(nDestTab)); if( !pDestPage ) return; SdrObjListIter aIter( pDestPage, SdrIterMode::Flat ); SdrObject* pObject = aIter.Next(); while( pObject ) { if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast(pObject)->IsChart() ) { OUString aChartName = static_cast(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 ); } } pObject = aIter.Next(); } } void ScChartHelper::UpdateChartsOnDestinationPage( ScDocument& rDestDoc, const SCTAB nDestTab ) { ScDrawLayer* pDrawLayer = rDestDoc.GetDrawLayer(); if( !pDrawLayer ) return; SdrPage* pDestPage = pDrawLayer->GetPage(static_cast(nDestTab)); if( !pDestPage ) return; SdrObjListIter aIter( pDestPage, SdrIterMode::Flat ); SdrObject* pObject = aIter.Next(); while( pObject ) { if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast(pObject)->IsChart() ) { OUString aChartName = static_cast(pObject)->GetPersistName(); Reference< chart2::XChartDocument > xChartDoc( rDestDoc.GetChartByName( aChartName ) ); Reference< util::XModifiable > xModif(xChartDoc, uno::UNO_QUERY_THROW); xModif->setModified( true); } pObject = aIter.Next(); } } uno::Reference< chart2::XChartDocument > ScChartHelper::GetChartFromSdrObject( const SdrObject* pObject ) { uno::Reference< chart2::XChartDocument > xReturn; if( pObject ) { if( pObject->GetObjIdentifier() == SdrObjKind::OLE2 && static_cast(pObject)->IsChart() ) { uno::Reference< embed::XEmbeddedObject > xIPObj = static_cast(pObject)->GetObjRef(); if( xIPObj.is() ) { 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& 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( "Role" ); uno::Sequence< uno::Reference< chart2::data::XLabeledDataSequence > > aLabeledDataSequences( xDataSource->getDataSequences() ); sal_Int32 nRange=0; for( uno::Reference& 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(); svt::EmbeddedObjectRef::TryRunningState( xEmbeddedObj ); uno::Reference< beans::XPropertySet > xProps( xEmbeddedObj->getComponent(), uno::UNO_QUERY ); if ( xProps.is() && ( xProps->getPropertyValue("DisableDataTableDialog") >>= bDisableDataTableDialog ) && bDisableDataTableDialog ) { ScChartListenerCollection* pCollection = rDocument.GetChartListenerCollection(); if (pCollection) { const OUString& aChartName = pSdrOle2Obj->GetPersistName(); const ScChartListener* pListener = pCollection->findByName(aChartName); if (pListener) { const ScRangeListRef& rRangeList = pListener->GetRangeList(); if ( rRangeList.is() ) { rRangesVector.push_back( *rRangeList ); } } } } 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 ); SdrObject* pObject = aIter.Next(); while ( pObject ) { AddRangesIfProtectedChart( rRangesVector, rDocument, pObject ); pObject = aIter.Next(); } } } void ScChartHelper::GetChartNames( ::std::vector< OUString >& rChartNames, const SdrPage* pPage ) { if ( !pPage ) return; SdrObjListIter aIter( pPage, SdrIterMode::DeepNoGroups ); SdrObject* pObject = aIter.Next(); while ( pObject ) { if ( pObject->GetObjIdentifier() == SdrObjKind::OLE2 ) { SdrOle2Obj* pSdrOle2Obj = dynamic_cast< SdrOle2Obj* >( pObject ); if ( pSdrOle2Obj && pSdrOle2Obj->IsChart() ) { rChartNames.push_back( pSdrOle2Obj->GetPersistName() ); } } pObject = aIter.Next(); } } 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 ); SdrObject* pObject = aIter.Next(); while ( pObject ) { 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; svt::EmbeddedObjectRef::TryRunningState( xEmbeddedObj ); uno::Reference< beans::XPropertySet > xProps( xEmbeddedObj->getComponent(), uno::UNO_QUERY ); if ( xProps.is() && ( xProps->getPropertyValue("DisableDataTableDialog") >>= bDisableDataTableDialog ) && bDisableDataTableDialog ) { if ( bSameDoc ) { ScChartListenerCollection* pCollection = rDoc.GetChartListenerCollection(); if (pCollection && !pCollection->findByName(aChartName)) { ScRangeList aRangeList( rRangesVector[ nRangeList++ ] ); ScRangeListRef rRangeList( new ScRangeList( aRangeList ) ); ScChartListener* pChartListener = new ScChartListener( aChartName, rDoc, rRangeList ); pCollection->insert( pChartListener ); pChartListener->StartListeningTo(); } } else { xProps->setPropertyValue("DisableDataTableDialog", uno::Any( false ) ); xProps->setPropertyValue("DisableComplexChartTypes", 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("Name", aChartName) }; pModelObj->NotifyChanges( "insert-chart", aChangeRanges, aProperties ); } } } } pObject = aIter.Next(); } } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */