1*cde9e8dcSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*cde9e8dcSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*cde9e8dcSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*cde9e8dcSAndrew Rist * distributed with this work for additional information 6*cde9e8dcSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*cde9e8dcSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*cde9e8dcSAndrew Rist * "License"); you may not use this file except in compliance 9*cde9e8dcSAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*cde9e8dcSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*cde9e8dcSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*cde9e8dcSAndrew Rist * software distributed under the License is distributed on an 15*cde9e8dcSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*cde9e8dcSAndrew Rist * KIND, either express or implied. See the License for the 17*cde9e8dcSAndrew Rist * specific language governing permissions and limitations 18*cde9e8dcSAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*cde9e8dcSAndrew Rist *************************************************************/ 21*cde9e8dcSAndrew Rist 22*cde9e8dcSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 25cdf0e10cSrcweir #include "precompiled_chart2.hxx" 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include "RangeSelectionHelper.hxx" 28cdf0e10cSrcweir #include "RangeSelectionListener.hxx" 29cdf0e10cSrcweir #include "macros.hxx" 30cdf0e10cSrcweir #include "ControllerLockGuard.hxx" 31cdf0e10cSrcweir #include <com/sun/star/frame/XModel.hpp> 32cdf0e10cSrcweir #include <com/sun/star/awt/XTopWindow.hpp> 33cdf0e10cSrcweir #include <com/sun/star/text/XText.hpp> 34cdf0e10cSrcweir #include <com/sun/star/embed/XEmbeddedObject.hpp> 35cdf0e10cSrcweir #include <com/sun/star/embed/EmbedStates.hpp> 36cdf0e10cSrcweir #include <com/sun/star/embed/XComponentSupplier.hpp> 37cdf0e10cSrcweir #include <com/sun/star/sheet/XCellRangeAddressable.hpp> 38cdf0e10cSrcweir #include <com/sun/star/sheet/XSpreadsheetDocument.hpp> 39cdf0e10cSrcweir #include <com/sun/star/sheet/XCellRangesAccess.hpp> 40cdf0e10cSrcweir #include <com/sun/star/chart2/data/XRangeXMLConversion.hpp> 41cdf0e10cSrcweir #include <rtl/ustrbuf.hxx> 42cdf0e10cSrcweir 43cdf0e10cSrcweir using namespace ::com::sun::star; 44cdf0e10cSrcweir 45cdf0e10cSrcweir using ::com::sun::star::uno::Reference; 46cdf0e10cSrcweir using ::com::sun::star::uno::Sequence; 47cdf0e10cSrcweir using ::rtl::OUString; 48cdf0e10cSrcweir 49cdf0e10cSrcweir // ---------------------------------------- 50cdf0e10cSrcweir 51cdf0e10cSrcweir namespace chart 52cdf0e10cSrcweir { 53cdf0e10cSrcweir 54cdf0e10cSrcweir RangeSelectionHelper::RangeSelectionHelper( 55cdf0e10cSrcweir const Reference< chart2::XChartDocument > & xChartDocument ) : 56cdf0e10cSrcweir m_xChartDocument( xChartDocument ) 57cdf0e10cSrcweir {} 58cdf0e10cSrcweir 59cdf0e10cSrcweir RangeSelectionHelper::~RangeSelectionHelper() 60cdf0e10cSrcweir {} 61cdf0e10cSrcweir 62cdf0e10cSrcweir bool RangeSelectionHelper::hasRangeSelection() 63cdf0e10cSrcweir { 64cdf0e10cSrcweir return getRangeSelection().is(); 65cdf0e10cSrcweir } 66cdf0e10cSrcweir 67cdf0e10cSrcweir Reference< sheet::XRangeSelection > RangeSelectionHelper::getRangeSelection() 68cdf0e10cSrcweir { 69cdf0e10cSrcweir if( !m_xRangeSelection.is() && 70cdf0e10cSrcweir m_xChartDocument.is() ) 71cdf0e10cSrcweir { 72cdf0e10cSrcweir try 73cdf0e10cSrcweir { 74cdf0e10cSrcweir Reference< chart2::data::XDataProvider > xDataProvider( m_xChartDocument->getDataProvider()); 75cdf0e10cSrcweir if( xDataProvider.is()) 76cdf0e10cSrcweir m_xRangeSelection.set( xDataProvider->getRangeSelection()); 77cdf0e10cSrcweir } 78cdf0e10cSrcweir catch( uno::Exception & ex ) 79cdf0e10cSrcweir { 80cdf0e10cSrcweir ASSERT_EXCEPTION( ex ); 81cdf0e10cSrcweir 82cdf0e10cSrcweir m_xRangeSelection.clear(); 83cdf0e10cSrcweir } 84cdf0e10cSrcweir } 85cdf0e10cSrcweir 86cdf0e10cSrcweir return m_xRangeSelection; 87cdf0e10cSrcweir } 88cdf0e10cSrcweir 89cdf0e10cSrcweir void RangeSelectionHelper::raiseRangeSelectionDocument() 90cdf0e10cSrcweir { 91cdf0e10cSrcweir Reference< sheet::XRangeSelection > xRangeSel( getRangeSelection()); 92cdf0e10cSrcweir if( xRangeSel.is()) 93cdf0e10cSrcweir { 94cdf0e10cSrcweir try 95cdf0e10cSrcweir { 96cdf0e10cSrcweir // bring document to front 97cdf0e10cSrcweir Reference< frame::XController > xCtrl( xRangeSel, uno::UNO_QUERY ); 98cdf0e10cSrcweir if( xCtrl.is()) 99cdf0e10cSrcweir { 100cdf0e10cSrcweir Reference< frame::XFrame > xFrame( xCtrl->getFrame()); 101cdf0e10cSrcweir if( xFrame.is()) 102cdf0e10cSrcweir { 103cdf0e10cSrcweir Reference< awt::XTopWindow > xWin( xFrame->getContainerWindow(), 104cdf0e10cSrcweir uno::UNO_QUERY_THROW ); 105cdf0e10cSrcweir xWin->toFront(); 106cdf0e10cSrcweir } 107cdf0e10cSrcweir } 108cdf0e10cSrcweir } 109cdf0e10cSrcweir catch( uno::Exception & ex ) 110cdf0e10cSrcweir { 111cdf0e10cSrcweir ASSERT_EXCEPTION( ex ); 112cdf0e10cSrcweir } 113cdf0e10cSrcweir } 114cdf0e10cSrcweir } 115cdf0e10cSrcweir 116cdf0e10cSrcweir bool RangeSelectionHelper::chooseRange( 117cdf0e10cSrcweir const OUString & aCurrentRange, 118cdf0e10cSrcweir const OUString & aUIString, 119cdf0e10cSrcweir RangeSelectionListenerParent & rListenerParent ) 120cdf0e10cSrcweir { 121cdf0e10cSrcweir ControllerLockGuard aGuard( Reference< frame::XModel >(m_xChartDocument, uno::UNO_QUERY ) ); 122cdf0e10cSrcweir 123cdf0e10cSrcweir bool bResult = true; 124cdf0e10cSrcweir raiseRangeSelectionDocument(); 125cdf0e10cSrcweir 126cdf0e10cSrcweir try 127cdf0e10cSrcweir { 128cdf0e10cSrcweir Reference< sheet::XRangeSelection > xRangeSel( getRangeSelection()); 129cdf0e10cSrcweir if( xRangeSel.is()) 130cdf0e10cSrcweir { 131cdf0e10cSrcweir Sequence< beans::PropertyValue > aArgs( 4 ); 132cdf0e10cSrcweir aArgs[0] = beans::PropertyValue( 133cdf0e10cSrcweir C2U("InitialValue"), -1, uno::makeAny( aCurrentRange ), 134cdf0e10cSrcweir beans::PropertyState_DIRECT_VALUE ); 135cdf0e10cSrcweir aArgs[1] = beans::PropertyValue( 136cdf0e10cSrcweir C2U("Title"), -1, 137cdf0e10cSrcweir uno::makeAny( aUIString ), 138cdf0e10cSrcweir beans::PropertyState_DIRECT_VALUE ); 139cdf0e10cSrcweir aArgs[2] = beans::PropertyValue( 140cdf0e10cSrcweir C2U("CloseOnMouseRelease"), -1, uno::makeAny( true ), 141cdf0e10cSrcweir beans::PropertyState_DIRECT_VALUE ); 142cdf0e10cSrcweir aArgs[3] = beans::PropertyValue( 143cdf0e10cSrcweir C2U("MultiSelectionMode"), -1, uno::makeAny( true ), 144cdf0e10cSrcweir beans::PropertyState_DIRECT_VALUE ); 145cdf0e10cSrcweir 146cdf0e10cSrcweir if( m_xRangeSelectionListener.is() ) 147cdf0e10cSrcweir stopRangeListening(); 148cdf0e10cSrcweir m_xRangeSelectionListener.set( Reference< sheet::XRangeSelectionListener >( 149cdf0e10cSrcweir new RangeSelectionListener( rListenerParent, aCurrentRange, Reference< frame::XModel >(m_xChartDocument, uno::UNO_QUERY ) ))); 150cdf0e10cSrcweir 151cdf0e10cSrcweir xRangeSel->addRangeSelectionListener( m_xRangeSelectionListener ); 152cdf0e10cSrcweir xRangeSel->startRangeSelection( aArgs ); 153cdf0e10cSrcweir } 154cdf0e10cSrcweir } 155cdf0e10cSrcweir catch( uno::Exception & ex ) 156cdf0e10cSrcweir { 157cdf0e10cSrcweir bResult = false; 158cdf0e10cSrcweir ASSERT_EXCEPTION( ex ); 159cdf0e10cSrcweir } 160cdf0e10cSrcweir 161cdf0e10cSrcweir return bResult; 162cdf0e10cSrcweir } 163cdf0e10cSrcweir 164cdf0e10cSrcweir void RangeSelectionHelper::stopRangeListening( bool bRemoveListener /* = true */ ) 165cdf0e10cSrcweir { 166cdf0e10cSrcweir if( bRemoveListener && 167cdf0e10cSrcweir m_xRangeSelectionListener.is() && 168cdf0e10cSrcweir m_xRangeSelection.is() ) 169cdf0e10cSrcweir { 170cdf0e10cSrcweir m_xRangeSelection->removeRangeSelectionListener( m_xRangeSelectionListener ); 171cdf0e10cSrcweir } 172cdf0e10cSrcweir 173cdf0e10cSrcweir m_xRangeSelectionListener = 0; 174cdf0e10cSrcweir } 175cdf0e10cSrcweir 176cdf0e10cSrcweir bool RangeSelectionHelper::verifyCellRange( const OUString & rRangeStr ) 177cdf0e10cSrcweir { 178cdf0e10cSrcweir Reference< chart2::data::XDataProvider > xDataProvider( m_xChartDocument->getDataProvider()); 179cdf0e10cSrcweir if( ! xDataProvider.is()) 180cdf0e10cSrcweir return false; 181cdf0e10cSrcweir 182cdf0e10cSrcweir return xDataProvider->createDataSequenceByRangeRepresentationPossible( rRangeStr ); 183cdf0e10cSrcweir } 184cdf0e10cSrcweir 185cdf0e10cSrcweir bool RangeSelectionHelper::verifyArguments( const Sequence< beans::PropertyValue > & rArguments ) 186cdf0e10cSrcweir { 187cdf0e10cSrcweir Reference< chart2::data::XDataProvider > xDataProvider( m_xChartDocument->getDataProvider()); 188cdf0e10cSrcweir if( ! xDataProvider.is()) 189cdf0e10cSrcweir return false; 190cdf0e10cSrcweir 191cdf0e10cSrcweir return xDataProvider->createDataSourcePossible( rArguments ); 192cdf0e10cSrcweir } 193cdf0e10cSrcweir 194cdf0e10cSrcweir } // namespace chart 195