Lines Matching refs:uno
211 uno::Any lcl_makeRange( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< un… in lcl_makeRange()
213 uno::Reference< table::XCellRange > xCellRange( aAny, uno::UNO_QUERY_THROW ); in lcl_makeRange()
214 …return uno::makeAny( uno::Reference< excel::XRange >( new ScVbaRange( xParent, xContext, xCellRang… in lcl_makeRange()
217 uno::Reference< excel::XRange > lcl_makeXRangeFromSheetCellRanges( const uno::Reference< XHelperInt… in lcl_makeXRangeFromSheetCellRanges()
219 uno::Reference< excel::XRange > xRange; in lcl_makeXRangeFromSheetCellRanges()
220 uno::Sequence< table::CellRangeAddress > sAddresses = xLocSheetCellRanges->getRangeAddresses(); in lcl_makeXRangeFromSheetCellRanges()
234 uno::Reference< table::XCellRange > xTmpRange( new ScCellRangeObj( pDoc, *aCellRanges.First() ) ); in lcl_makeXRangeFromSheetCellRanges()
239 …uno::Reference< sheet::XSheetCellRangeContainer > xRanges( new ScCellRangesObj( pDoc, aCellRanges … in lcl_makeXRangeFromSheetCellRanges()
246 ScCellRangesBase* ScVbaRange::getCellRangesBase() throw ( uno::RuntimeException ) in getCellRangesBase()
252 …throw uno::RuntimeException( rtl::OUString::createFromAscii("General Error creating range - Unknow… in getCellRangesBase()
255 ScCellRangeObj* ScVbaRange::getCellRangeObj() throw ( uno::RuntimeException ) in getCellRangeObj()
260 ScCellRangesObj* ScVbaRange::getCellRangesObj() throw ( uno::RuntimeException ) in getCellRangesObj()
265 SfxItemSet* ScVbaRange::getCurrentDataSet( ) throw ( uno::RuntimeException ) in getCurrentDataSet()
269 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Can't access Itemset for… in getCurrentDataSet()
279 … uno::Reference< script::vba::XVBAEventProcessor > xVBAEvents = pDoc->GetVbaEventProcessor(); in fireChangeEvent()
282 uno::Sequence< uno::Any > aArgs( 1 ); in fireChangeEvent()
283 aArgs[ 0 ] <<= uno::Reference< excel::XRange >( this ); in fireChangeEvent()
286 catch( uno::Exception& ) in fireChangeEvent()
295 uno::Reference< XHelperInterface > m_xParent;
296 uno::Reference< table::XCellRange > m_xRange;
297 uno::Reference< uno::XComponentContext > mxContext;
301 …uno::Reference< XHelperInterface >& xParent, const uno::Reference< css::uno::XComponentContext >& … in SingleRangeEnumeration()
302 virtual ::sal_Bool SAL_CALL hasMoreElements( ) throw (uno::RuntimeException) { return bHasMore; } in hasMoreElements()
303 …virtual uno::Any SAL_CALL nextElement( ) throw (container::NoSuchElementException, lang::WrappedT… in nextElement()
308 return uno::makeAny( m_xRange ); in nextElement()
319 uno::Reference< XHelperInterface > mxParent;
320 uno::Reference< table::XCellRange > m_xRange;
321 uno::Reference< uno::XComponentContext > mxContext;
324 …eIndexAccess( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XCompo… in SingleRangeIndexAccess()
326 virtual ::sal_Int32 SAL_CALL getCount() throw (::uno::RuntimeException) { return 1; } in getCount()
327 …virtual uno::Any SAL_CALL getByIndex( ::sal_Int32 Index ) throw (lang::IndexOutOfBoundsException, … in getByIndex()
331 return uno::makeAny( m_xRange ); in getByIndex()
334 …virtual uno::Type SAL_CALL getElementType() throw (uno::RuntimeException){ return table::XCellRang… in getElementType()
336 virtual ::sal_Bool SAL_CALL hasElements() throw (uno::RuntimeException) { return sal_True; } in hasElements()
338 …virtual uno::Reference< container::XEnumeration > SAL_CALL createEnumeration() throw (uno::Runtime… in createEnumeration()
350 …uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XComponentContext >& xCont… in RangesEnumerationImpl()
351 …virtual uno::Any SAL_CALL nextElement( ) throw (container::NoSuchElementException, lang::WrappedT… in nextElement()
363 …baRangeAreas( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XCompo… in ScVbaRangeAreas()
366 …virtual uno::Reference< container::XEnumeration > SAL_CALL createEnumeration() throw (uno::Runtime…
369 …virtual uno::Type SAL_CALL getElementType() throw (uno::RuntimeException){ return excel::XRange::s… in getElementType()
371 virtual uno::Any createCollectionObject( const uno::Any& aSource );
375 …virtual uno::Sequence< rtl::OUString > getServiceNames() { return uno::Sequence< rtl::OUString >()… in getServiceNames()
379 uno::Reference< container::XEnumeration > SAL_CALL
380 ScVbaRangeAreas::createEnumeration() throw (uno::RuntimeException) in createEnumeration()
382 …uno::Reference< container::XEnumerationAccess > xEnumAccess( m_xIndexAccess, uno::UNO_QUERY_THROW … in createEnumeration()
386 uno::Any
387 ScVbaRangeAreas::createCollectionObject( const uno::Any& aSource ) in createCollectionObject()
394 getDocShellFromIf( const uno::Reference< uno::XInterface >& xIf ) throw ( uno::RuntimeException ) in getDocShellFromIf()
398 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access underly… in getDocShellFromIf()
403 getDocShellFromRange( const uno::Reference< table::XCellRange >& xRange ) throw ( uno::RuntimeExcep… in getDocShellFromRange()
406 uno::Reference< uno::XInterface > xIf( xRange ); in getDocShellFromRange()
411 getDocShellFromRanges( const uno::Reference< sheet::XSheetCellRangeContainer >& xRanges ) throw ( u… in getDocShellFromRanges()
414 uno::Reference< uno::XInterface > xIf( xRanges ); in getDocShellFromRanges()
418 uno::Reference< frame::XModel > getModelFromXIf( const uno::Reference< uno::XInterface >& xIf ) thr… in getModelFromXIf()
424 uno::Reference< frame::XModel > getModelFromRange( const uno::Reference< table::XCellRange >& xRang… in getModelFromRange()
427 uno::Reference< uno::XInterface > xIf( xRange ); in getModelFromRange()
432 getDocumentFromRange( const uno::Reference< table::XCellRange >& xRange ) in getDocumentFromRange()
436 …uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access underlying do… in getDocumentFromRange()
443 ScVbaRange::getScDocument() throw (uno::RuntimeException) in getScDocument()
447 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in getScDocument()
448 uno::Reference< table::XCellRange > xRange( xIndex->getByIndex( 0 ), uno::UNO_QUERY_THROW ); in getScDocument()
455 ScVbaRange::getScDocShell() throw (uno::RuntimeException) in getScDocShell()
459 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in getScDocShell()
460 uno::Reference< table::XCellRange > xRange( xIndex->getByIndex( 0 ), uno::UNO_QUERY_THROW ); in getScDocShell()
466 /*static*/ ScVbaRange* ScVbaRange::getImplementation( const uno::Reference< excel::XRange >& rxRang… in getImplementation()
472 uno::Reference< frame::XModel > ScVbaRange::getUnoModel() throw (uno::RuntimeException) in getUnoModel()
476 throw uno::RuntimeException(); in getUnoModel()
479 /*static*/ uno::Reference< frame::XModel > ScVbaRange::getUnoModel( const uno::Reference< excel::XR… in getUnoModel()
483 throw uno::RuntimeException(); in getUnoModel()
486 const ScRangeList& ScVbaRange::getScRangeList() throw (uno::RuntimeException) in getScRangeList()
490 …throw uno::RuntimeException( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Cannot obtain UNO rang… in getScRangeList()
493 …st ScRangeList& ScVbaRange::getScRangeList( const uno::Reference< excel::XRange >& rxRange ) throw… in getScRangeList()
497 …throw uno::RuntimeException( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Cannot obtain VBA rang… in getScRangeList()
503 uno::Reference< util::XNumberFormatsSupplier > mxSupplier;
504 uno::Reference< beans::XPropertySet > mxRangeProps;
505 uno::Reference< util::XNumberFormats > mxFormats;
507 NumFormatHelper( const uno::Reference< table::XCellRange >& xRange ) in NumFormatHelper()
509 mxSupplier.set( getModelFromRange( xRange ), uno::UNO_QUERY_THROW ); in NumFormatHelper()
510 mxRangeProps.set( xRange, uno::UNO_QUERY_THROW); in NumFormatHelper()
513 uno::Reference< beans::XPropertySet > getNumberProps() in getNumberProps()
516 …uno::Any aValue = mxRangeProps->getPropertyValue(rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Numbe… in getNumberProps()
521 return uno::Reference< beans::XPropertySet > (); in getNumberProps()
544 uno::Reference< uno::XInterface > xIf( mxRangeProps, uno::UNO_QUERY_THROW ); in getNumberFormatString()
558 uno::Reference< beans::XPropertySet > xNumberProps( getNumberProps(), uno::UNO_QUERY_THROW ); in getNumberFormatString()
560 …uno::Any aString = xNumberProps->getPropertyValue(rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Form… in getNumberFormatString()
567 uno::Reference< beans::XPropertySet > xNumberProps = getNumberProps(); in getNumberFormat()
580 uno::Reference< beans::XPropertySet > xNumProps = getNumberProps(); in setNumberFormat()
586 …mxRangeProps->setPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("NumberFormat") ), uno:… in setNumberFormat()
592 uno::Reference< beans::XPropertySet > xNumberProps = getNumberProps(); in setNumberFormat()
595 uno::Reference<util::XNumberFormatTypes> xTypes( mxFormats, uno::UNO_QUERY ); in setNumberFormat()
599 …opertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("NumberFormat") ), uno::makeAny( nNewIndex… in setNumberFormat()
626 uno::Reference< uno::XComponentContext > mxContext;
627 uno::Reference< excel::XRange > mxRange;
632 …ColumnsRowEnumeration( const uno::Reference< uno::XComponentContext >& xContext, const uno::Refere… in ColumnsRowEnumeration()
636 …virtual ::sal_Bool SAL_CALL hasMoreElements() throw (::uno::RuntimeException){ return mCurElem < m… in hasMoreElements()
638 …virtual uno::Any SAL_CALL nextElement() throw (container::NoSuchElementException, lang::WrappedTar… in nextElement()
643 return uno::makeAny( mxRange->Item( uno::makeAny( vbaIndex ), uno::Any() ) ); in nextElement()
649 uno::WeakReference< XHelperInterface > mxParent;
650 uno::Reference< uno::XComponentContext > mxContext;
651 uno::Reference< XCollection > m_xAreas;
655 uno::Reference< table::XCellRange > getArea( sal_Int32 nVBAIndex ) throw ( uno::RuntimeException ) in getArea()
658 throw uno::RuntimeException(); in getArea()
659 …uno::Reference< excel::XRange > xRange( m_xAreas->Item( uno::makeAny(nVBAIndex), uno::Any() ), uno… in getArea()
660 …uno::Reference< table::XCellRange > xCellRange( ScVbaRange::getCellRange( xRange ), uno::UNO_QUERY… in getArea()
666 uno::Reference< table::XCellRange > xRange = getArea( nVBAIndex ); in populateArea()
667 uno::Reference< table::XColumnRowRange > xColumnRowRange(xRange, uno::UNO_QUERY_THROW ); in populateArea()
677 …sEnumeration( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XCompo… in CellsEnumeration()
686 …virtual ::sal_Bool SAL_CALL hasMoreElements() throw (::uno::RuntimeException){ return m_it != m_Ce… in hasMoreElements()
688 …virtual uno::Any SAL_CALL nextElement() throw (container::NoSuchElementException, lang::WrappedTar… in nextElement()
694 uno::Reference< table::XCellRange > xRangeArea = getArea( aPos.m_nArea ); in nextElement()
695 …uno::Reference< table::XCellRange > xCellRange( xRangeArea->getCellByPosition( aPos.m_nCol, aPos.… in nextElement()
696 …return uno::makeAny( uno::Reference< excel::XRange >( new ScVbaRange( mxParent, mxContext, xCellRa… in nextElement()
722 uno::Any maValue;
723 uno::TypeClass mTypeClass;
725 CellValueSetter( const uno::Any& aValue );
726 virtual bool processValue( const uno::Any& aValue, const uno::Reference< table::XCell >& xCell );
727 virtual void visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xCell );
731 CellValueSetter::CellValueSetter( const uno::Any& aValue ): maValue( aValue ), mTypeClass( aValue.g… in CellValueSetter()
734 CellValueSetter::visitNode( sal_Int32 /*i*/, sal_Int32 /*j*/, const uno::Reference< table::XCell >&… in visitNode()
740 CellValueSetter::processValue( const uno::Any& aValue, const uno::Reference< table::XCell >& xCell ) in processValue()
746 case uno::TypeClass_BOOLEAN: in processValue()
751 uno::Reference< table::XCellRange > xRange( xCell, uno::UNO_QUERY_THROW ); in processValue()
761 case uno::TypeClass_STRING: in processValue()
776 uno::Reference< text::XTextRange > xTextRange( xCell, uno::UNO_QUERY_THROW ); in processValue()
809 uno::Any maValue;
810 uno::TypeClass mTypeClass;
813 virtual void visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xCell );
814 virtual void processValue( sal_Int32 x, sal_Int32 y, const uno::Any& aValue );
815 const uno::Any& getValue() const { return maValue; } in getValue()
820 CellValueGetter::processValue( sal_Int32 /*x*/, sal_Int32 /*y*/, const uno::Any& aValue ) in processValue()
824 void CellValueGetter::visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xC… in visitNode()
826 uno::Any aValue; in visitNode()
840 uno::Reference< beans::XPropertySet > xProp( xCell, uno::UNO_QUERY_THROW ); in visitNode()
848 uno::Reference< text::XTextRange > xTextRange(xCell, ::uno::UNO_QUERY_THROW); in visitNode()
857 uno::Reference< table::XCellRange > xRange( xCell, uno::UNO_QUERY_THROW ); in visitNode()
860 aValue = uno::makeAny( ( xCell->getValue() != 0.0 ) ); in visitNode()
862 aValue = uno::makeAny( bridge::oleautomation::Date( xCell->getValue() ) ); in visitNode()
869 uno::Reference< text::XTextRange > xTextRange(xCell, ::uno::UNO_QUERY_THROW); in visitNode()
881 …CellFormulaValueSetter( const uno::Any& aValue, ScDocument* pDoc, formula::FormulaGrammar::Grammar… in CellFormulaValueSetter()
883 bool processValue( const uno::Any& aValue, const uno::Reference< table::XCell >& xCell ) in processValue()
894 uno::Reference< uno::XInterface > xIf( xCell, uno::UNO_QUERY_THROW ); in processValue()
931 virtual void visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xCell ) in visitNode()
933 uno::Any aValue; in visitNode()
937 uno::Reference< uno::XInterface > xIf( xCell, uno::UNO_QUERY_THROW ); in visitNode()
963 uno::Any maValue;
965 virtual void processValue( sal_Int32 x, sal_Int32 y, const uno::Any& aValue ) in processValue()
967 …uno::Sequence< uno::Sequence< uno::Any > >& aMatrix = *( uno::Sequence< uno::Sequence< uno::Any > … in processValue()
974 uno::Sequence< uno::Sequence< uno::Any > > aMatrix; in Dim2ArrayValueGetter()
980 void visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xCell ) in visitNode()
986 const uno::Any& getValue() const { return maValue; } in getValue()
994 uno::Sequence< uno::Any > aMatrix;
998 …Dim1ArrayValueSetter( const uno::Any& aValue, ValueSetter& rCellValueSetter ):mCellValueSetter( rC… in Dim1ArrayValueSetter()
1003 virtual void visitNode( sal_Int32 /*x*/, sal_Int32 y, const uno::Reference< table::XCell >& xCell ) in visitNode()
1008 mCellValueSetter.processValue( uno::makeAny( sNA ), xCell ); in visitNode()
1016 uno::Sequence< uno::Sequence< uno::Any > > aMatrix;
1021 …Dim2ArrayValueSetter( const uno::Any& aValue, ValueSetter& rCellValueSetter ) : mCellValueSetter( … in Dim2ArrayValueSetter()
1028 virtual void visitNode( sal_Int32 x, sal_Int32 y, const uno::Reference< table::XCell >& xCell ) in visitNode()
1033 mCellValueSetter.processValue( uno::makeAny( sNA ), xCell ); in visitNode()
1041 virtual void process( const uno::Reference< excel::XRange >& xRange ) = 0;
1046 const uno::Any& m_aVal;
1048 RangeValueProcessor( const uno::Any& rVal ):m_aVal( rVal ) {} in RangeValueProcessor()
1049 virtual void process( const uno::Reference< excel::XRange >& xRange ) in process()
1057 const uno::Any& m_aVal;
1059 RangeFormulaProcessor( const uno::Any& rVal ):m_aVal( rVal ) {} in RangeFormulaProcessor()
1060 virtual void process( const uno::Reference< excel::XRange >& xRange ) in process()
1071 virtual void process( const uno::Reference< excel::XRange >& xRange ) in process()
1080 uno::Reference< XCollection > m_Areas;
1082 AreasVisitor( const uno::Reference< XCollection >& rAreas ):m_Areas( rAreas ){} in AreasVisitor()
1091 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in visit()
1100 uno::Reference< table::XCellRange > m_xCellRange;
1103 …RangeHelper( const uno::Reference< table::XCellRange >& xCellRange ) throw (uno::RuntimeException)… in RangeHelper()
1106 throw uno::RuntimeException(); in RangeHelper()
1108 RangeHelper( const uno::Any aCellRange ) throw (uno::RuntimeException) in RangeHelper()
1110 m_xCellRange.set( aCellRange, uno::UNO_QUERY_THROW ); in RangeHelper()
1112 uno::Reference< sheet::XSheetCellRange > getSheetCellRange() throw (uno::RuntimeException) in getSheetCellRange()
1114 return uno::Reference< sheet::XSheetCellRange >(m_xCellRange, uno::UNO_QUERY_THROW); in getSheetCellRange()
1116 uno::Reference< sheet::XSpreadsheet > getSpreadSheet() throw (uno::RuntimeException) in getSpreadSheet()
1121 uno::Reference< table::XCellRange > getCellRangeFromSheet() throw (uno::RuntimeException) in getCellRangeFromSheet()
1123 return uno::Reference< table::XCellRange >(getSpreadSheet(), uno::UNO_QUERY_THROW ); in getCellRangeFromSheet()
1126 …uno::Reference< sheet::XCellRangeAddressable > getCellRangeAddressable() throw (uno::RuntimeExcep… in getCellRangeAddressable()
1128 return uno::Reference< sheet::XCellRangeAddressable >(m_xCellRange, ::uno::UNO_QUERY_THROW); in getCellRangeAddressable()
1132 uno::Reference< sheet::XSheetCellCursor > getSheetCellCursor() throw ( uno::RuntimeException ) in getSheetCellCursor()
1134 …return uno::Reference< sheet::XSheetCellCursor >( getSpreadSheet()->createCursorByRange( getSheet… in getSheetCellCursor()
1137 …static uno::Reference< excel::XRange > createRangeFromRange( const uno::Reference< XHelperInterfac… in createRangeFromRange()
1138 …const uno::Reference< table::XCellRange >& xRange, const uno::Reference< sheet::XCellRangeAddressa… in createRangeFromRange()
1141 return uno::Reference< excel::XRange >( new ScVbaRange( xParent, xContext, in createRangeFromRange()
1171 …ar::AddressConvention aConv = formula::FormulaGrammar::CONV_XL_A1 ) throw ( uno::RuntimeException ) in getScRangeListForAddress()
1174 uno::Reference< beans::XPropertySet > xProps( pDocSh->GetModel(), uno::UNO_QUERY_THROW ); in getScRangeListForAddress()
1175 …uno::Reference< container::XNameAccess > xNameAccess( xProps->getPropertyValue( rtl::OUString( RTL… in getScRangeListForAddress()
1199 …uno::Reference< sheet::XNamedRange > xNamed( xNameAccess->getByName( sAddress ), uno::UNO_QUERY_TH… in getScRangeListForAddress()
1227 …uno::Reference< uno::XComponentContext >& xContext, const rtl::OUString& sName, ScDocShell* pDocSh… in getRangeForName()
1233 throw uno::RuntimeException(); in getRangeForName()
1237 uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( pDocSh, *aCellRanges.First() ) ); in getRangeForName()
1238 uno::Reference< XHelperInterface > xFixThisParent = excel::getUnoSheetModuleObj( xRange ); in getRangeForName()
1241 …uno::Reference< sheet::XSheetCellRangeContainer > xRanges( new ScCellRangesObj( pDocSh, aCellRange… in getRangeForName()
1243 uno::Reference< XHelperInterface > xFixThisParent = excel::getUnoSheetModuleObj( xRanges ); in getRangeForName()
1252 …table::CellRangeAddress lclGetRangeAddress( const uno::Reference< RangeType >& rxCellRange ) throw… in lclGetRangeAddress()
1254 …return uno::Reference< sheet::XCellRangeAddressable >( rxCellRange, uno::UNO_QUERY_THROW )->getRan… in lclGetRangeAddress()
1257 void lclClearRange( const uno::Reference< table::XCellRange >& rxCellRange ) throw (uno::RuntimeExc… in lclClearRange()
1261 uno::Reference< sheet::XSheetOperation > xSheetOperation( rxCellRange, uno::UNO_QUERY_THROW ); in lclClearRange()
1265 uno::Reference< sheet::XSheetCellRange > lclExpandToMerged( const uno::Reference< table::XCellRange… in lclExpandToMerged()
1267 uno::Reference< sheet::XSheetCellRange > xNewCellRange( rxCellRange, uno::UNO_QUERY_THROW ); in lclExpandToMerged()
1268 …uno::Reference< sheet::XSpreadsheet > xSheet( xNewCellRange->getSpreadsheet(), uno::UNO_SET_THROW … in lclExpandToMerged()
1275 …uno::Reference< sheet::XSheetCellCursor > xCursor( xSheet->createCursorByRange( xNewCellRange ), u… in lclExpandToMerged()
1277 xNewCellRange.set( xCursor, uno::UNO_QUERY_THROW ); in lclExpandToMerged()
1284 uno::Reference< sheet::XSheetCellRangeContainer > lclExpandToMerged( const uno::Reference< sheet::X… in lclExpandToMerged()
1287 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Missing cell ranges obje… in lclExpandToMerged()
1290 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Missing cell ranges obje… in lclExpandToMerged()
1295 …uno::Reference< table::XCellRange > xRange( rxCellRanges->getByIndex( nIndex ), uno::UNO_QUERY_THR… in lclExpandToMerged()
1304 void lclExpandAndMerge( const uno::Reference< table::XCellRange >& rxCellRange, bool bMerge ) throw… in lclExpandAndMerge()
1306 …uno::Reference< util::XMergeable > xMerge( lclExpandToMerged( rxCellRange, true ), uno::UNO_QUERY_… in lclExpandAndMerge()
1326 util::TriState lclGetMergedState( const uno::Reference< table::XCellRange >& rxCellRange ) throw (u… in lclGetMergedState()
1333 …uno::Reference< table::XCellRange > xTopLeft( rxCellRange->getCellRangeByPosition( 0, 0, 0, 0 ), u… in lclGetMergedState()
1334 …uno::Reference< sheet::XSheetCellRange > xExpanded( lclExpandToMerged( xTopLeft, false ), uno::UNO… in lclGetMergedState()
1355 css::uno::Reference< excel::XRange >
1357 const uno::Reference< uno::XComponentContext >& xContext, const rtl::OUString& sRangeName, in getRangeObjectForName()
1358 …ScDocShell* pDocSh, formula::FormulaGrammar::AddressConvention eConv ) throw ( uno::RuntimeExcepti… in getRangeObjectForName()
1365 … const uno::Any& aParam, ScDocShell* pDocSh, formula::FormulaGrammar::AddressConvention aConv = f… in getCellRangeAddressForVBARange()
1367 uno::Reference< table::XCellRange > xRangeParam; in getCellRangeAddressForVBARange()
1370 case uno::TypeClass_STRING: in getCellRangeAddressForVBARange()
1386 case uno::TypeClass_INTERFACE: in getCellRangeAddressForVBARange()
1388 uno::Reference< excel::XRange > xRange; in getCellRangeAddressForVBARange()
1395 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can't extact CellRangeAdd… in getCellRangeAddressForVBARange()
1400 uno::Reference< XCollection >
1401 …uno::Reference< excel::XRange >& xParentRange, const uno::Reference<uno::XComponentContext>& xCont… in lcl_setupBorders()
1403 uno::Reference< XHelperInterface > xParent( xParentRange, uno::UNO_QUERY_THROW ); in lcl_setupBorders()
1406 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access documen… in lcl_setupBorders()
1408 uno::Reference< XCollection > borders( new ScVbaBorders( xParent, xContext, xRange, aPalette ) ); in lcl_setupBorders()
1412 void lcl_NotifyRangeChanges( const uno::Reference< frame::XModel >& xModel, ScCellRangesBase* pUnoR… in lcl_NotifyRangeChanges()
1425 ScVbaRange::ScVbaRange( uno::Sequence< uno::Any> const & args, in ScVbaRange()
1426 …uno::Reference< uno::XComponentContext> const & xContext ) throw ( lang::IllegalArgumentException… in ScVbaRange()
1428 mxRange.set( mxPropertySet, uno::UNO_QUERY ); in ScVbaRange()
1429 mxRanges.set( mxPropertySet, uno::UNO_QUERY ); in ScVbaRange()
1430 uno::Reference< container::XIndexAccess > xIndex; in ScVbaRange()
1437 xIndex.set( mxRanges, uno::UNO_QUERY_THROW ); in ScVbaRange()
1442 …::ScVbaRange( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XCompo… in ScVbaRange()
1443 : ScVbaRange_BASE( xParent, xContext, uno::Reference< beans::XPropertySet >( xRange, uno::UNO_QUERY… in ScVbaRange()
1448 …:OUString( RTL_CONSTASCII_USTRINGPARAM( "context is not set " ) ), uno::Reference< uno::XInterface… in ScVbaRange()
1450 …l::OUString( RTL_CONSTASCII_USTRINGPARAM( "range is not set " ) ), uno::Reference< uno::XInterface… in ScVbaRange()
1452 …uno::Reference< container::XIndexAccess > xIndex( new SingleRangeIndexAccess( mxParent, mxContext,… in ScVbaRange()
1457 …::ScVbaRange( const uno::Reference< XHelperInterface >& xParent, const uno::Reference< uno::XCompo… in ScVbaRange()
1458 …ontext, uno::Reference< beans::XPropertySet >( xRanges, uno::UNO_QUERY_THROW ), getModelFromXIf( u… in ScVbaRange()
1461 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in ScVbaRange()
1470 uno::Reference< XCollection >& ScVbaRange::getBorders() in getBorders()
1474 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in getBorders()
1475 …orders = lcl_setupBorders( this, mxContext, uno::Reference< table::XCellRange >( xRange->getCellRa… in getBorders()
1490 uno::Reference< table::XCell > xCell( mxRange->getCellByPosition( j, i ), uno::UNO_QUERY_THROW ); in visitArray()
1499 uno::Any
1500 ScVbaRange::getValue( ValueGetter& valueGetter) throw (uno::RuntimeException) in getValue()
1502 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, uno::UNO_QUERY_THROW ); in getValue()
1514 return uno::makeAny( script::ArrayWrapper( sal_False, arrayGetter.getValue() ) ); in getValue()
1517 uno::Any SAL_CALL
1518 ScVbaRange::getValue() throw (uno::RuntimeException) in getValue()
1526 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getValue()
1537 ScVbaRange::setValue( const uno::Any& aValue, ValueSetter& valueSetter, bool bFireEvent ) throw (un… in setValue()
1539 uno::TypeClass aClass = aValue.getValueTypeClass(); in setValue()
1540 if ( aClass == uno::TypeClass_SEQUENCE ) in setValue()
1542 uno::Reference< script::XTypeConverter > xConverter = getTypeConverter( mxContext ); in setValue()
1543 uno::Any aConverted; in setValue()
1550 aConverted = xConverter->convertTo( aValue, getCppuType((uno::Sequence< uno::Any >*)0) ); in setValue()
1556 …aConverted = xConverter->convertTo( aValue, getCppuType((uno::Sequence< uno::Sequence< uno::Any > … in setValue()
1561 catch ( uno::Exception& e ) in setValue()
1576 ScVbaRange::setValue( const uno::Any &aValue ) throw (uno::RuntimeException) in setValue()
1593 ScVbaRange::Clear() throw (uno::RuntimeException) in Clear()
1604 ScVbaRange::ClearContents( sal_Int32 nFlags, bool bFireEvent ) throw (uno::RuntimeException) in ClearContents()
1615 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in ClearContents()
1626 uno::Reference< sheet::XSheetOperation > xSheetOperation(mxRange, uno::UNO_QUERY_THROW); in ClearContents()
1632 ScVbaRange::ClearComments() throw (uno::RuntimeException) in ClearComments()
1638 ScVbaRange::ClearContents() throw (uno::RuntimeException) in ClearContents()
1646 ScVbaRange::ClearFormats() throw (uno::RuntimeException) in ClearFormats()
1657 …baRange::setFormulaValue( const uno::Any& rFormula, formula::FormulaGrammar::Grammar eGram, bool b… in setFormulaValue()
1673 uno::Any
1674 ScVbaRange::getFormulaValue( formula::FormulaGrammar::Grammar eGram ) throw (uno::RuntimeException) in getFormulaValue()
1682 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getFormulaValue()
1691 ScVbaRange::setFormula(const uno::Any &rFormula ) throw (uno::RuntimeException) in setFormula()
1697 uno::Any
1698 ScVbaRange::getFormulaR1C1() throw (::com::sun::star::uno::RuntimeException) in getFormulaR1C1()
1704 ScVbaRange::setFormulaR1C1(const uno::Any& rFormula ) throw (uno::RuntimeException) in setFormulaR1C1()
1709 uno::Any
1710 ScVbaRange::getFormula() throw (::com::sun::star::uno::RuntimeException) in getFormula()
1716 ScVbaRange::getCount() throw (uno::RuntimeException) in getCount()
1728 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, uno::UNO_QUERY_THROW ); in getCount()
1740 ScVbaRange::getRow() throw (uno::RuntimeException) in getRow()
1748 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getRow()
1751 …uno::Reference< sheet::XCellAddressable > xCellAddressable(mxRange->getCellByPosition(0, 0), uno::… in getRow()
1756 ScVbaRange::getColumn() throw (uno::RuntimeException) in getColumn()
1764 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getColumn()
1767 …uno::Reference< sheet::XCellAddressable > xCellAddressable(mxRange->getCellByPosition(0, 0), uno::… in getColumn()
1771 uno::Any
1772 ScVbaRange::HasFormula() throw (uno::RuntimeException) in HasFormula()
1777 uno::Any aResult = aNULL(); in HasFormula()
1780 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in HasFormula()
1792 uno::Reference< uno::XInterface > xIf( mxRange, uno::UNO_QUERY_THROW ); in HasFormula()
1796 …uno::Reference<uno::XInterface> xRanges( pThisRanges->queryFormulaCells( ( sheet::FormulaResult::… in HasFormula()
1800 return uno::makeAny(sal_False); in HasFormula()
1809 return uno::makeAny( sal_True ); in HasFormula()
1812 … sheet::FillDateMode nFillDateMode, double fStep, double fEndValue ) throw( uno::RuntimeException ) in fillSeries()
1817 uno::Reference< XCollection > xCollection( m_Areas, uno::UNO_QUERY_THROW ); in fillSeries()
1820 …uno::Reference< excel::XRange > xRange( xCollection->Item( uno::makeAny( index ), uno::Any() ), un… in fillSeries()
1828 uno::Reference< sheet::XCellSeries > xCellSeries(mxRange, uno::UNO_QUERY_THROW ); in fillSeries()
1836 ScVbaRange::FillLeft() throw (uno::RuntimeException) in FillLeft()
1843 ScVbaRange::FillRight() throw (uno::RuntimeException) in FillRight()
1850 ScVbaRange::FillUp() throw (uno::RuntimeException) in FillUp()
1857 ScVbaRange::FillDown() throw (uno::RuntimeException) in FillDown()
1864 ScVbaRange::getText() throw (uno::RuntimeException) in getText()
1872 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getText()
1875 …uno::Reference< text::XTextRange > xTextRange(mxRange->getCellByPosition(0,0), uno::UNO_QUERY_THRO… in getText()
1879 uno::Reference< excel::XRange >
1880 ScVbaRange::Offset( const ::uno::Any &nRowOff, const uno::Any &nColOff ) throw (uno::RuntimeExcepti… in Offset()
1907 …uno::Reference< sheet::XSheetCellRangeContainer > xRanges( new ScCellRangesObj( pUnoRangesBase->Ge… in Offset()
1911 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( pUnoRangesBase->GetDocShell(), *aC… in Offset()
1915 uno::Reference< excel::XRange >
1916 ScVbaRange::CurrentRegion() throw (uno::RuntimeException) in CurrentRegion()
1924 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in CurrentRegion()
1929 uno::Reference< sheet::XSheetCellCursor > xSheetCellCursor = in CurrentRegion()
1932 …uno::Reference< sheet::XCellRangeAddressable > xCellRangeAddressable(xSheetCellCursor, uno::UNO_QU… in CurrentRegion()
1936 uno::Reference< excel::XRange >
1937 ScVbaRange::CurrentArray() throw (uno::RuntimeException) in CurrentArray()
1945 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in CurrentArray()
1949 uno::Reference< sheet::XSheetCellCursor > xSheetCellCursor = in CurrentArray()
1952 …uno::Reference< sheet::XCellRangeAddressable > xCellRangeAddressable(xSheetCellCursor, uno::UNO_QU… in CurrentArray()
1956 uno::Any
1957 ScVbaRange::getFormulaArray() throw (uno::RuntimeException) in getFormulaArray()
1965 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in getFormulaArray()
1969 uno::Reference< sheet::XCellRangeFormula> xCellRangeFormula( mxRange, uno::UNO_QUERY_THROW ); in getFormulaArray()
1970 uno::Reference< script::XTypeConverter > xConverter = getTypeConverter( mxContext ); in getFormulaArray()
1971 uno::Any aMatrix; in getFormulaArray()
1972 … = xConverter->convertTo( uno::makeAny( xCellRangeFormula->getFormulaArray() ) , getCppuType((uno:… in getFormulaArray()
1977 ScVbaRange::setFormulaArray(const uno::Any& rFormula) throw (uno::RuntimeException) in setFormulaArray()
1985 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in setFormulaArray()
1995 ScVbaRange::Characters(const uno::Any& Start, const uno::Any& Length) throw (uno::RuntimeException) in Characters()
2003 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in Characters()
2009 uno::Reference< text::XTextRange > xTextRange(mxRange, ::uno::UNO_QUERY_THROW ); in Characters()
2021 …uno::Any& RowAbsolute, const uno::Any& ColumnAbsolute, const uno::Any& ReferenceStyle, const uno::… in Address()
2027 uno::Reference< XCollection > xCollection( m_Areas, uno::UNO_QUERY_THROW ); in Address()
2028 uno::Any aExternalCopy = External; in Address()
2031 …uno::Reference< excel::XRange > xRange( xCollection->Item( uno::makeAny( index ), uno::Any() ), un… in Address()
2038 aExternalCopy = uno::makeAny(sal_False); in Address()
2097 uno::Reference < excel::XFont >
2098 ScVbaRange::Font() throw ( script::BasicErrorException, uno::RuntimeException) in Font()
2100 uno::Reference< beans::XPropertySet > xProps(mxRange, ::uno::UNO_QUERY ); in Font()
2103 xProps.set(mxRange, ::uno::UNO_QUERY ); in Font()
2105 xProps.set(mxRanges, ::uno::UNO_QUERY ); in Font()
2107 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access documen… in Font()
2115 catch( uno::Exception& ) in Font()
2121 uno::Reference< excel::XRange >
2122 ScVbaRange::Cells( const uno::Any &nRowIndex, const uno::Any &nColumnIndex ) throw(uno::RuntimeExce… in Cells()
2130 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in Cells()
2140 uno::Reference< excel::XRange >
2141 ScVbaRange::CellsHelper( const uno::Reference< ov::XHelperInterface >& xParent, in CellsHelper()
2142 const uno::Reference< uno::XComponentContext >& xContext, in CellsHelper()
2143 const uno::Reference< css::table::XCellRange >& xRange, in CellsHelper()
2144 … const uno::Any &nRowIndex, const uno::Any &nColumnIndex ) throw(uno::RuntimeException) in CellsHelper()
2157 uno::Reference< script::XTypeConverter > xConverter = getTypeConverter( xContext ); in CellsHelper()
2158 uno::Any aConverted; in CellsHelper()
2164 catch( uno::Exception& ) {} // silence any errors in CellsHelper()
2168 uno::Reference< script::XTypeConverter > xConverter = getTypeConverter( xContext ); in CellsHelper()
2169 uno::Any aConverted; in CellsHelper()
2175 catch( uno::Exception& ) {} // silence any errors in CellsHelper()
2180 uno::Reference< table::XCellRange > xSheetRange = thisRange.getCellRangeFromSheet(); in CellsHelper()
2183 return uno::Reference< excel::XRange >( new ScVbaRange( xParent, xContext, xRange ) ); in CellsHelper()
2188 uno::Reference< table::XColumnRowRange > xColumnRowRange(xRange, ::uno::UNO_QUERY_THROW); in CellsHelper()
2205 ScVbaRange::Select() throw (uno::RuntimeException) in Select()
2209 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access underly… in Select()
2213 uno::Reference< frame::XModel > xModel( pShell->GetModel(), uno::UNO_QUERY_THROW ); in Select()
2214 …uno::Reference< view::XSelectionSupplier > xSelection( xModel->getCurrentController(), uno::UNO_QU… in Select()
2216 xSelection->select( uno::Any( lclExpandToMerged( mxRanges, true ) ) ); in Select()
2218 xSelection->select( uno::Any( lclExpandToMerged( mxRange, true ) ) ); in Select()
2223 …uno::Reference< frame::XController > xController( xModel->getCurrentController(), uno::UNO_QUERY_T… in Select()
2224 uno::Reference< frame::XFrame > xFrame( xController->getFrame(), uno::UNO_QUERY_THROW ); in Select()
2225 uno::Reference< awt::XWindow > xWin( xFrame->getContainerWindow(), uno::UNO_QUERY_THROW ); in Select()
2228 catch( uno::Exception& ) in Select()
2242 void setCursor( const SCCOL& nCol, const SCROW& nRow, const uno::Reference< frame::XModel >& xMode… in setCursor()
2255 ScVbaRange::Activate() throw (uno::RuntimeException) in Activate()
2258 uno::Reference< table::XCellRange > xCellRange; in Activate()
2261 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in Activate()
2262 xCellRange.set( xIndex->getByIndex( 0 ), uno::UNO_QUERY_THROW ); in Activate()
2265 xCellRange.set( mxRange, uno::UNO_QUERY_THROW ); in Activate()
2268 …uno::Reference< sheet::XCellRangeAddressable > xThisRangeAddress = thisRange.getCellRangeAddressab… in Activate()
2270 uno::Reference< frame::XModel > xModel; in Activate()
2277 throw uno::RuntimeException(); in Activate()
2280 …uno::Reference< sheet::XCellRangeAddressable > xRange( xModel->getCurrentSelection(), ::uno::UNO_Q… in Activate()
2282 …uno::Reference< sheet::XSheetCellRanges > xRanges( xModel->getCurrentSelection(), ::uno::UNO_QUERY… in Activate()
2286 uno::Sequence< table::CellRangeAddress > nAddrs = xRanges->getRangeAddresses(); in Activate()
2314 uno::Reference< excel::XRange >
2315 ScVbaRange::Rows(const uno::Any& aIndex ) throw (uno::RuntimeException) in Rows()
2347 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Illegal param" ) ), uno::… in Rows()
2350 …throw uno::RuntimeException( rtl::OUString::createFromAscii("Internal failure, illegal param"), un… in Rows()
2352 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( pUnoRangesBase->GetDocShell(), aRa… in Rows()
2361 uno::Reference< excel::XRange >
2362 ScVbaRange::Columns(const uno::Any& aIndex ) throw (uno::RuntimeException) in Columns()
2394 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Illegal param" ) ), uno::… in Columns()
2397 …throw uno::RuntimeException( rtl::OUString::createFromAscii("Internal failure, illegal param"), un… in Columns()
2400 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( pUnoRangesBase->GetDocShell(), aRa… in Columns()
2405 ScVbaRange::setMergeCells( const uno::Any& aIsMerged ) throw (script::BasicErrorException, uno::Run… in setMergeCells()
2417 …uno::Reference< sheet::XCellRangeAddressable > xRangeAddr( mxRanges->getByIndex( nIndex ), uno::UN… in setMergeCells()
2428 …uno::Reference< table::XCellRange > xRange( mxRanges->getByIndex( nIndex ), uno::UNO_QUERY_THROW ); in setMergeCells()
2438 uno::Any
2439 ScVbaRange::getMergeCells() throw (script::BasicErrorException, uno::RuntimeException) in getMergeCells()
2446 …uno::Reference< table::XCellRange > xRange( mxRanges->getByIndex( nIndex ), uno::UNO_QUERY_THROW ); in getMergeCells()
2455 return uno::Any( false ); in getMergeCells()
2461 case util::TriState_YES: return uno::Any( true ); in getMergeCells()
2462 case util::TriState_NO: return uno::Any( false ); in getMergeCells()
2468 ScVbaRange::Copy(const ::uno::Any& Destination) throw (uno::RuntimeException) in Copy()
2471 …hrow uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("That command cannot be use… in Copy()
2474 uno::Reference< excel::XRange > xRange( Destination, uno::UNO_QUERY_THROW ); in Copy()
2475 uno::Any aRange = xRange->getCellRange(); in Copy()
2476 uno::Reference< table::XCellRange > xCellRange; in Copy()
2478 uno::Reference< sheet::XSheetCellRange > xSheetCellRange(xCellRange, ::uno::UNO_QUERY_THROW); in Copy()
2479 uno::Reference< sheet::XSpreadsheet > xSheet = xSheetCellRange->getSpreadsheet(); in Copy()
2480 uno::Reference< table::XCellRange > xDest( xSheet, uno::UNO_QUERY_THROW ); in Copy()
2481 uno::Reference< sheet::XCellRangeMovement > xMover( xSheet, uno::UNO_QUERY_THROW); in Copy()
2482 uno::Reference< sheet::XCellAddressable > xDestination( xDest->getCellByPosition( in Copy()
2483 xRange->getColumn()-1,xRange->getRow()-1), uno::UNO_QUERY_THROW ); in Copy()
2484 uno::Reference< sheet::XCellRangeAddressable > xSource( mxRange, uno::UNO_QUERY); in Copy()
2489 uno::Reference< frame::XModel > xModel = getModelFromRange( mxRange ); in Copy()
2496 ScVbaRange::Cut(const ::uno::Any& Destination) throw (uno::RuntimeException) in Cut()
2499 …hrow uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("That command cannot be use… in Cut()
2502 uno::Reference< excel::XRange > xRange( Destination, uno::UNO_QUERY_THROW ); in Cut()
2503 uno::Reference< table::XCellRange > xCellRange( xRange->getCellRange(), uno::UNO_QUERY_THROW ); in Cut()
2504 uno::Reference< sheet::XSheetCellRange > xSheetCellRange(xCellRange, ::uno::UNO_QUERY_THROW ); in Cut()
2505 uno::Reference< sheet::XSpreadsheet > xSheet = xSheetCellRange->getSpreadsheet(); in Cut()
2506 uno::Reference< table::XCellRange > xDest( xSheet, uno::UNO_QUERY_THROW ); in Cut()
2507 uno::Reference< sheet::XCellRangeMovement > xMover( xSheet, uno::UNO_QUERY_THROW); in Cut()
2508 uno::Reference< sheet::XCellAddressable > xDestination( xDest->getCellByPosition( in Cut()
2509 xRange->getColumn()-1,xRange->getRow()-1), uno::UNO_QUERY); in Cut()
2510 uno::Reference< sheet::XCellRangeAddressable > xSource( mxRange, uno::UNO_QUERY); in Cut()
2514 uno::Reference< frame::XModel > xModel = getModelFromRange( mxRange ); in Cut()
2521 ScVbaRange::setNumberFormat( const uno::Any& aFormat ) throw ( script::BasicErrorException, uno::Ru… in setNumberFormat()
2530 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in setNumberFormat()
2539 uno::Any
2540 ScVbaRange::getNumberFormat() throw ( script::BasicErrorException, uno::RuntimeException) in getNumberFormat()
2546 uno::Any aResult = aNULL(); in getNumberFormat()
2549 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in getNumberFormat()
2564 return uno::makeAny( sFormat ); in getNumberFormat()
2568 uno::Reference< excel::XRange >
2569 ScVbaRange::Resize( const uno::Any &RowSize, const uno::Any &ColumnSize ) throw (uno::RuntimeExcept… in Resize()
2573 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, ::uno::UNO_QUERY_THROW); in Resize()
2574 uno::Reference< sheet::XSheetCellRange > xSheetRange(mxRange, ::uno::UNO_QUERY_THROW); in Resize()
2575 …uno::Reference< sheet::XSheetCellCursor > xCursor( xSheetRange->getSpreadsheet()->createCursorByRa… in Resize()
2583 …uno::Reference< sheet::XCellRangeAddressable > xCellRangeAddressable(xCursor, ::uno::UNO_QUERY_THR… in Resize()
2584 …uno::Reference< table::XCellRange > xRange( xSheetRange->getSpreadsheet(), ::uno::UNO_QUERY_THROW … in Resize()
2593 ScVbaRange::setWrapText( const uno::Any& aIsWrapped ) throw (script::BasicErrorException, uno::Runt… in setWrapText()
2598 uno::Any aResult; in setWrapText()
2601 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in setWrapText()
2607 uno::Reference< beans::XPropertySet > xProps(mxRange, ::uno::UNO_QUERY_THROW ); in setWrapText()
2609 …xProps->setPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "IsTextWrapped" ) ), uno::An… in setWrapText()
2612 uno::Any
2613 ScVbaRange::getWrapText() throw (script::BasicErrorException, uno::RuntimeException) in getWrapText()
2618 uno::Any aResult; in getWrapText()
2621 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in getWrapText()
2636 uno::Reference< beans::XPropertySet > xProps(mxRange, ::uno::UNO_QUERY_THROW ); in getWrapText()
2637 …uno::Any aValue = xProps->getPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "IsTextWra… in getWrapText()
2641 uno::Reference< excel::XInterior > ScVbaRange::Interior( ) throw ( script::BasicErrorException, uno… in Interior()
2643 uno::Reference< beans::XPropertySet > xProps( mxRange, uno::UNO_QUERY_THROW ); in Interior()
2646 uno::Reference< excel::XRange >
2647 ScVbaRange::Range( const uno::Any &Cell1, const uno::Any &Cell2 ) throw (uno::RuntimeException) in Range()
2651 uno::Reference< excel::XRange >
2652 ScVbaRange::Range( const uno::Any &Cell1, const uno::Any &Cell2, bool bForceUseInpuRangeTab ) throw… in Range()
2655 uno::Reference< table::XCellRange > xCellRange = mxRange; in Range()
2659 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in Range()
2660 xCellRange.set( xIndex->getByIndex( 0 ), uno::UNO_QUERY_THROW ); in Range()
2666 uno::Reference< table::XCellRange > xRanges = thisRange.getCellRangeFromSheet(); in Range()
2667 uno::Reference< sheet::XCellRangeAddressable > xAddressable( xRanges, uno::UNO_QUERY_THROW ); in Range()
2669 uno::Reference< table::XCellRange > xReferrer = in Range()
2674 xAddressable.set( xReferrer, uno::UNO_QUERY_THROW ); in Range()
2677 throw uno::RuntimeException( in Range()
2679 uno::Reference< XInterface >() ); in Range()
2715 throw uno::RuntimeException(); in Range()
2726 throw uno::RuntimeException(); in Range()
2755 uno::Any SAL_CALL ScVbaRange::getCellRange( ) throw (uno::RuntimeException) in getCellRange()
2757 uno::Any aAny; in getCellRange()
2765 /*static*/ uno::Any ScVbaRange::getCellRange( const uno::Reference< excel::XRange >& rxRange ) thro… in getCellRange()
2769 throw uno::RuntimeException(); in getCellRange()
2826 …cial( const uno::Any& Paste, const uno::Any& Operation, const uno::Any& SkipBlanks, const uno::Any… in PasteSpecial()
2829 …hrow uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("That command cannot be use… in PasteSpecial()
2832 …uno::Reference< frame::XModel > xModel( ( pShell ? pShell->GetModel() : NULL ), uno::UNO_QUERY_THR… in PasteSpecial()
2833 …uno::Reference< view::XSelectionSupplier > xSelection( xModel->getCurrentController(), uno::UNO_QU… in PasteSpecial()
2835 uno::Reference< uno::XInterface > xSel( xModel->getCurrentSelection() ); in PasteSpecial()
2837 xSelection->select( uno::makeAny( mxRange ) ); in PasteSpecial()
2857 xSelection->select( uno::makeAny( xSel ) ); in PasteSpecial()
2860 uno::Reference< excel::XRange >
2861 ScVbaRange::getEntireColumnOrRow( bool bColumn ) throw (uno::RuntimeException) in getEntireColumnOrRow()
2882 …uno::Reference< sheet::XSheetCellRangeContainer > xRanges( new ScCellRangesObj( pUnoRangesBase->Ge… in getEntireColumnOrRow()
2886 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( pUnoRangesBase->GetDocShell(), *aC… in getEntireColumnOrRow()
2890 uno::Reference< excel::XRange > SAL_CALL
2891 ScVbaRange::getEntireRow() throw (uno::RuntimeException) in getEntireRow()
2896 uno::Reference< excel::XRange > SAL_CALL
2897 ScVbaRange::getEntireColumn() throw (uno::RuntimeException) in getEntireColumn()
2902 uno::Reference< excel::XComment > SAL_CALL
2903 ScVbaRange::AddComment( const uno::Any& Text ) throw (uno::RuntimeException) in AddComment()
2907 throw uno::RuntimeException(); in AddComment()
2912 throw uno::RuntimeException(); in AddComment()
2919 uno::Reference< sheet::XSheetCellRange > xCellRange( mxRange, uno::UNO_QUERY_THROW ); in AddComment()
2920 …uno::Reference< sheet::XSheetAnnotationsSupplier > xAnnosSupp( xCellRange->getSpreadsheet(), uno::… in AddComment()
2921 …uno::Reference< sheet::XSheetAnnotations > xAnnos( xAnnosSupp->getAnnotations(), uno::UNO_SET_THRO… in AddComment()
2926 uno::Reference< excel::XComment > SAL_CALL
2927 ScVbaRange::getComment() throw (uno::RuntimeException) in getComment()
2931 …uno::Reference< excel::XComment > xComment( new ScVbaComment( this, mxContext, getUnoModel(), mxRa… in getComment()
2932 if ( !xComment->Text( uno::Any(), uno::Any(), uno::Any() ).getLength() ) in getComment()
2938 uno::Reference< beans::XPropertySet >
2939 getRowOrColumnProps( const uno::Reference< table::XCellRange >& xCellRange, bool bRows ) throw ( un… in getRowOrColumnProps()
2941 uno::Reference< table::XColumnRowRange > xColRow( xCellRange, uno::UNO_QUERY_THROW ); in getRowOrColumnProps()
2942 uno::Reference< beans::XPropertySet > xProps; in getRowOrColumnProps()
2944 xProps.set( xColRow->getRows(), uno::UNO_QUERY_THROW ); in getRowOrColumnProps()
2946 xProps.set( xColRow->getColumns(), uno::UNO_QUERY_THROW ); in getRowOrColumnProps()
2950 uno::Any SAL_CALL
2951 ScVbaRange::getHidden() throw (uno::RuntimeException) in getHidden()
2957 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(sal_Int32(1)), uno::Any() ), u… in getHidden()
2963 uno::Reference< beans::XPropertySet > xProps = getRowOrColumnProps( mxRange, mbIsRows ); in getHidden()
2965 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to get IsVisible … in getHidden()
2967 catch( uno::Exception& e ) in getHidden()
2969 throw uno::RuntimeException( e.Message, uno::Reference< uno::XInterface >() ); in getHidden()
2971 return uno::makeAny( !bIsVisible ); in getHidden()
2975 ScVbaRange::setHidden( const uno::Any& _hidden ) throw (uno::RuntimeException) in setHidden()
2982 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in setHidden()
2991 uno::Reference< beans::XPropertySet > xProps = getRowOrColumnProps( mxRange, mbIsRows ); in setHidden()
2992 xProps->setPropertyValue( ISVISIBLE, uno::Any( !bHidden ) ); in setHidden()
2994 catch( uno::Exception& e ) in setHidden()
2996 throw uno::RuntimeException( e.Message, uno::Reference< uno::XInterface >() ); in setHidden()
3001 …uno::Any& LookAt, const uno::Any& SearchOrder, const uno::Any& MatchCase, const uno::Any& MatchByt… in Replace()
3007 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( index ), uno::Any() ), uno::U… in Replace()
3015 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, missing p… in Replace()
3026 uno::Reference< util::XReplaceable > xReplace( mxRange, uno::UNO_QUERY ); in Replace()
3029 uno::Reference< util::XReplaceDescriptor > xDescriptor = in Replace()
3033 …yValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHREGEXP ) ), uno::makeAny( sal_True … in Replace()
3045 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Replace()
3049 …tyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHWORDS ) ), uno::makeAny( bSearchWo… in Replace()
3061 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Replace()
3064 …tyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHBYROW ) ), uno::makeAny( bSearchBy… in Replace()
3070 …rtyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHCASE ) ), uno::makeAny( bMatchCas… in Replace()
3077 uno::Reference< util::XSearchDescriptor > xSearch( xDescriptor, uno::UNO_QUERY ); in Replace()
3079 uno::Reference< container::XIndexAccess > xIndexAccess = xReplace->findAll( xSearch ); in Replace()
3093 uno::Reference< excel::XRange > SAL_CALL
3094 …uno::Any& What, const uno::Any& After, const uno::Any& LookIn, const uno::Any& LookAt, const uno::… in Find()
3105 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Find, missing para… in Find()
3116 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Find, missing para… in Find()
3126 uno::Reference< util::XSearchable > xSearch( mxRange, uno::UNO_QUERY ); in Find()
3129 uno::Reference< util::XSearchDescriptor > xDescriptor = xSearch->createSearchDescriptor(); in Find()
3131 …opertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHREGEXP ) ), uno::Any( true ) ); in Find()
3133 uno::Reference< excel::XRange > xAfterRange; in Find()
3134 uno::Reference< table::XCellRange > xStartCell; in Find()
3139 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("After must be a single ce… in Find()
3140 …uno::Reference< excel::XRange > xCell( Cells( uno::makeAny( xAfterRange->getRow() ), uno::makeAny(… in Find()
3142 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("After must be in range." … in Find()
3143 xStartCell.set( xAfterRange->getCellRange(), uno::UNO_QUERY_THROW ); in Find()
3165 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Find()
3168 …xDescriptor->setPropertyValue( rtl::OUString::createFromAscii( "SearchType" ), uno::makeAny( nSear… in Find()
3182 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Find()
3184 …tyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHWORDS ) ), uno::makeAny( bSearchWo… in Find()
3197 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Find()
3200 …tyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHBYROW ) ), uno::makeAny( bSearchBy… in Find()
3215 …hrow uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal va… in Find()
3217 …or->setPropertyValue( rtl::OUString::createFromAscii( "SearchBackwards" ), uno::makeAny( bSearchBa… in Find()
3227 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Range::Replace, illegal v… in Find()
3229 …rtyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( SC_UNO_SRCHCASE ) ), uno::makeAny( bMatchCas… in Find()
3237 …uno::Reference< uno::XInterface > xInterface = xStartCell.is() ? xSearch->findNext( xStartCell, xD… in Find()
3238 uno::Reference< table::XCellRange > xCellRange( xInterface, uno::UNO_QUERY ); in Find()
3241 … uno::Reference< excel::XRange > xResultRange = new ScVbaRange( mxParent, mxContext, xCellRange ); in Find()
3251 return uno::Reference< excel::XRange >(); in Find()
3254 uno::Reference< table::XCellRange > processKey( const uno::Any& Key, uno::Reference< uno::XCompone… in processKey()
3256 uno::Reference< excel::XRange > xKeyRange; in processKey()
3259 xKeyRange.set( Key, uno::UNO_QUERY_THROW ); in processKey()
3267 …throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Range::Sort no docshell to… in processKey()
3271 …throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Range::Sort illegal type v… in processKey()
3272 uno::Reference< table::XCellRange > xKey; in processKey()
3273 xKey.set( xKeyRange->getCellRange(), uno::UNO_QUERY_THROW ); in processKey()
3278 sal_Int32 findSortPropertyIndex( const uno::Sequence< beans::PropertyValue >& props, in findSortPropertyIndex()
3279 const rtl::OUString& sPropName ) throw( uno::RuntimeException ) in findSortPropertyIndex()
3289 …throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Range::Sort unknown sort p… in findSortPropertyIndex()
3294 void updateTableSortField( const uno::Reference< table::XCellRange >& xParentRange, in updateTableSortField()
3295 const uno::Reference< table::XCellRange >& xColRowKey, sal_Int16 nOrder, in updateTableSortField()
3296 …table::TableSortField& aTableField, sal_Bool bIsSortColumn, sal_Bool bMatchCase ) throw ( uno::Run… in updateTableSortField()
3325 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Illegal Key param" ) ), … in updateTableSortField()
3331 …uno::Any& Key1, const uno::Any& Order1, const uno::Any& Key2, const uno::Any& /*Type*/, const uno:… in Sort()
3335 …hrow uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("That command cannot be use… in Sort()
3343 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access documen… in Sort()
3360 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, uno::UNO_QUERY_THROW ); in Sort()
3476 uno::Reference< table::XCellRange > xKey1; in Sort()
3477 uno::Reference< table::XCellRange > xKey2; in Sort()
3478 uno::Reference< table::XCellRange > xKey3; in Sort()
3482 …throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Range::Sort needs a key1 p… in Sort()
3489 uno::Reference< util::XSortable > xSort( mxRange, uno::UNO_QUERY_THROW ); in Sort()
3490 uno::Sequence< beans::PropertyValue > sortDescriptor = xSort->createSortDescriptor(); in Sort()
3493 uno::Sequence< table::TableSortField > sTableFields(1); in Sort()
3523 uno::Reference< excel::XRange > SAL_CALL
3524 ScVbaRange::End( ::sal_Int32 Direction ) throw (uno::RuntimeException) in End()
3528 uno::Reference< excel::XRange > xRange( getArea( 0 ), uno::UNO_QUERY_THROW ); in End()
3542 uno::Any aDft; in End()
3543 uno::Reference< excel::XApplication > xApplication( Application(), uno::UNO_QUERY_THROW ); in End()
3547 Cells( uno::makeAny( (sal_Int32) 1 ), uno::makeAny( (sal_Int32) 1 ) )->Select(); in End()
3549 uno::Reference< frame::XModel > xModel = getModelFromRange( mxRange ); in End()
3578 …throw uno::RuntimeException( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( ": Invalid ColumnIndex"… in End()
3590 uno::Any aVoid; in End()
3592 …uno::Reference< excel::XRange > xOldActiveCell( xApplication->getActiveSheet()->Range( uno::makeAn… in End()
3595 uno::Reference< excel::XRange > resultCell; in End()
3597 …resultCell.set( xApplication->getActiveSheet()->Range( uno::makeAny( sMoved ), aVoid ), uno::UNO_Q… in End()
3607 uno::Reference< sheet::XCellRangeAddressable > xAddressable( mxRange, uno::UNO_QUERY ); in isSingleCellRange()
3616 uno::Reference< excel::XCharacters > SAL_CALL
3617 ScVbaRange::characters( const uno::Any& Start, const uno::Any& Length ) throw (uno::RuntimeExceptio… in characters()
3620 …row uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can't create Characters pro… in characters()
3621 …uno::Reference< text::XSimpleText > xSimple(mxRange->getCellByPosition(0,0) , uno::UNO_QUERY_THROW… in characters()
3624 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Failed to access documen… in characters()
3631 ScVbaRange::Delete( const uno::Any& Shift ) throw (uno::RuntimeException) in Delete()
3638 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in Delete()
3659 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM ("Illegal parameter ") ), … in Delete()
3672 …uno::Reference< sheet::XCellRangeMovement > xCellRangeMove( thisRange.getSpreadSheet(), uno::UNO_Q… in Delete()
3679 ScVbaRange::hasElements() throw (uno::RuntimeException) in hasElements()
3681 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, uno::UNO_QUERY ); in hasElements()
3690 uno::Reference< container::XEnumeration > SAL_CALL
3691 ScVbaRange::createEnumeration() throw (uno::RuntimeException) in createEnumeration()
3695 uno::Reference< table::XColumnRowRange > xColumnRowRange(mxRange, uno::UNO_QUERY ); in createEnumeration()
3696 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in createEnumeration()
3709 ScVbaRange::getDefaultMethodName( ) throw (uno::RuntimeException) in getDefaultMethodName()
3718 ScVbaRange::getCalcColWidth( const table::CellRangeAddress& rAddress) throw (uno::RuntimeException) in getCalcColWidth()
3728 ScVbaRange::getCalcRowHeight( const table::CellRangeAddress& rAddress ) throw (uno::RuntimeExceptio… in getCalcRowHeight()
3750 uno::Any SAL_CALL
3751 ScVbaRange::getColumnWidth() throw (uno::RuntimeException) in getColumnWidth()
3756 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in getColumnWidth()
3764 uno::Reference< frame::XModel > xModel = pShell->GetModel(); in getColumnWidth()
3785 return uno::makeAny( nColWidth ); in getColumnWidth()
3789 ScVbaRange::setColumnWidth( const uno::Any& _columnwidth ) throw (uno::RuntimeException) in setColumnWidth()
3796 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(index) ), uno::Any(… in setColumnWidth()
3824 uno::Any SAL_CALL
3825 ScVbaRange::getWidth() throw (uno::RuntimeException) in getWidth()
3829 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in getWidth()
3832 uno::Reference< table::XColumnRowRange > xColRowRange( mxRange, uno::UNO_QUERY_THROW ); in getWidth()
3833 …uno::Reference< container::XIndexAccess > xIndexAccess( xColRowRange->getColumns(), uno::UNO_QUERY… in getWidth()
3838 …uno::Reference< sheet::XCellRangeAddressable > xAddressable( xIndexAccess->getByIndex( index ), un… in getWidth()
3842 return uno::makeAny( nWidth ); in getWidth()
3845 uno::Any SAL_CALL
3846 ScVbaRange::Areas( const uno::Any& item) throw (uno::RuntimeException) in Areas()
3849 return uno::makeAny( m_Areas ); in Areas()
3850 return m_Areas->Item( item, uno::Any() ); in Areas()
3853 uno::Reference< excel::XRange >
3854 ScVbaRange::getArea( sal_Int32 nIndex ) throw( css::uno::RuntimeException ) in getArea()
3857 …throw uno::RuntimeException( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("No areas available")), uno… in getArea()
3858 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( ++nIndex ), uno::Any() ), uno… in getArea()
3862 uno::Any
3863 ScVbaRange::Borders( const uno::Any& item ) throw( script::BasicErrorException, uno::RuntimeExcepti… in Borders()
3866 return uno::makeAny( getBorders() ); in Borders()
3867 return getBorders()->Item( item, uno::Any() ); in Borders()
3870 uno::Any SAL_CALL
3871 ScVbaRange::BorderAround( const css::uno::Any& LineStyle, const css::uno::Any& Weight, in BorderAround()
3872 … const css::uno::Any& ColorIndex, const css::uno::Any& Color ) throw (css::uno::RuntimeException) in BorderAround()
3886 …uno::Reference< excel::XBorder > xBorder( m_Borders->Item( uno::makeAny( nLineType ), uno::Any() )… in BorderAround()
3911 return uno::makeAny( sal_False ); in BorderAround()
3914 return uno::makeAny( sal_True ); in BorderAround()
3917 uno::Any SAL_CALL
3918 ScVbaRange::getRowHeight() throw (uno::RuntimeException) in getRowHeight()
3923 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in getRowHeight()
3953 return uno::makeAny( nHeight ); in getRowHeight()
3957 ScVbaRange::setRowHeight( const uno::Any& _rowheight) throw (uno::RuntimeException) in setRowHeight()
3964 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(index) ), uno::Any(… in setRowHeight()
3986 uno::Any SAL_CALL
3987 ScVbaRange::getPageBreak() throw (uno::RuntimeException) in getPageBreak()
4000 uno::Reference< frame::XModel > xModel = pShell->GetModel(); in getPageBreak()
4019 return uno::makeAny( nPageBreak ); in getPageBreak()
4023 ScVbaRange::setPageBreak( const uno::Any& _pagebreak) throw (uno::RuntimeException) in setPageBreak()
4041 uno::Reference< frame::XModel > xModel = pShell->GetModel(); in setPageBreak()
4053 uno::Any SAL_CALL
4054 ScVbaRange::getHeight() throw (uno::RuntimeException) in getHeight()
4058 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(1) ), uno::Any() ),… in getHeight()
4062 uno::Reference< table::XColumnRowRange > xColRowRange( mxRange, uno::UNO_QUERY_THROW ); in getHeight()
4063 …uno::Reference< container::XIndexAccess > xIndexAccess( xColRowRange->getRows(), uno::UNO_QUERY_TH… in getHeight()
4068 …uno::Reference< sheet::XCellRangeAddressable > xAddressable( xIndexAccess->getByIndex( index ), un… in getHeight()
4071 return uno::makeAny( nHeight ); in getHeight()
4075 ScVbaRange::getPosition() throw ( uno::RuntimeException ) in getPosition()
4078 uno::Reference< beans::XPropertySet > xProps; in getPosition()
4080 xProps.set( mxRange, uno::UNO_QUERY_THROW ); in getPosition()
4082 xProps.set( mxRanges, uno::UNO_QUERY_THROW ); in getPosition()
4086 uno::Any SAL_CALL
4087 ScVbaRange::getLeft() throw (uno::RuntimeException) in getLeft()
4093 return uno::makeAny( lcl_hmmToPoints( aPoint.X ) ); in getLeft()
4097 uno::Any SAL_CALL
4098 ScVbaRange::getTop() throw (uno::RuntimeException) in getTop()
4104 return uno::makeAny( lcl_hmmToPoints( aPoint.Y ) ); in getTop()
4107 uno::Reference< excel::XWorksheet >
4108 ScVbaRange::getWorksheet() throw (uno::RuntimeException) in getWorksheet()
4112 uno::Reference< excel::XWorksheet > xSheet( getParent(), uno::UNO_QUERY ); in getWorksheet()
4115 uno::Reference< table::XCellRange > xRange = mxRange; in getWorksheet()
4119 uno::Reference< container::XIndexAccess > xIndex( mxRanges, uno::UNO_QUERY_THROW ); in getWorksheet()
4120 xRange.set( xIndex->getByIndex( 0 ), uno::UNO_QUERY_THROW ); in getWorksheet()
4125 …xSheet.set( new ScVbaWorksheet( uno::Reference< XHelperInterface >(), mxContext,rHelper.getSpreadS… in getWorksheet()
4132 uno::Reference< excel::XRange >
4133 …nRange( const uno::Reference< uno::XComponentContext >& xContext, const css::uno::Any &Cell1, cons… in ApplicationRange()
4155 …uno::Reference< beans::XPropertySet > xPropSet( getCurrentExcelDoc(xContext), uno::UNO_QUERY_THROW… in ApplicationRange()
4157 …uno::Reference< container::XNameAccess > xNamed( xPropSet->getPropertyValue( sNamedRanges ), uno::… in ApplicationRange()
4158 uno::Reference< sheet::XCellRangeReferrer > xReferrer; in ApplicationRange()
4161 xReferrer.set ( xNamed->getByName( sRangeName ), uno::UNO_QUERY ); in ApplicationRange()
4163 catch( uno::Exception& /*e*/ ) in ApplicationRange()
4169 uno::Reference< table::XCellRange > xRange = xReferrer->getReferredCells(); in ApplicationRange()
4172 …uno::Reference< excel::XRange > xVbRange = new ScVbaRange( excel::getUnoSheetModuleObj( xRange ),… in ApplicationRange()
4177 …uno::Reference< sheet::XSpreadsheetView > xView( getCurrentExcelDoc(xContext)->getCurrentControlle… in ApplicationRange()
4178 uno::Reference< table::XCellRange > xSheetRange( xView->getActiveSheet(), uno::UNO_QUERY_THROW ); in ApplicationRange()
4180 uno::Reference< excel::XRange > xVbSheetRange( pRange ); in ApplicationRange()
4184 uno::Reference< sheet::XDatabaseRanges >
4185 lcl_GetDataBaseRanges( ScDocShell* pShell ) throw ( uno::RuntimeException ) in lcl_GetDataBaseRanges()
4187 uno::Reference< frame::XModel > xModel; in lcl_GetDataBaseRanges()
4189 xModel.set( pShell->GetModel(), uno::UNO_QUERY_THROW ); in lcl_GetDataBaseRanges()
4190 uno::Reference< beans::XPropertySet > xModelProps( xModel, uno::UNO_QUERY_THROW ); in lcl_GetDataBaseRanges()
4191 …uno::Reference< sheet::XDatabaseRanges > xDBRanges( xModelProps->getPropertyValue( rtl::OUString( … in lcl_GetDataBaseRanges()
4196 uno::Reference< sheet::XDatabaseRange >
4199 …uno::Reference< container::XIndexAccess > xIndexAccess( lcl_GetDataBaseRanges( pShell ), uno::UNO_… in lcl_GetAutoFiltRange()
4200 uno::Reference< sheet::XDatabaseRange > xDataBaseRange; in lcl_GetAutoFiltRange()
4204 …uno::Reference< sheet::XDatabaseRange > xDBRange( xIndexAccess->getByIndex( index ), uno::UNO_QUER… in lcl_GetAutoFiltRange()
4205 uno::Reference< container::XNamed > xNamed( xDBRange, uno::UNO_QUERY_THROW ); in lcl_GetAutoFiltRange()
4216 uno::Reference< beans::XPropertySet > xProps( xDBRange, uno::UNO_QUERY_THROW ); in lcl_GetAutoFiltRange()
4303 void lcl_setTableFieldsFromCriteria( rtl::OUString& sCriteria1, uno::Reference< beans::XPropertySet… in lcl_setTableFieldsFromCriteria()
4331 …e( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "UseRegularExpressions" ) ), uno::Any( sal_True ) ); in lcl_setTableFieldsFromCriteria()
4346 …e( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "UseRegularExpressions" ) ), uno::Any( sal_True ) ); in lcl_setTableFieldsFromCriteria()
4391 …const uno::Any& Field, const uno::Any& Criteria1, const uno::Any& Operator, const uno::Any& Criter… in AutoFilter()
4400 …uno::Reference< sheet::XDatabaseRange > xDataBaseRange = lcl_GetAutoFiltRange( pShell, nSheet, sAu… in AutoFilter()
4404 uno::Reference< table::XCellRange > xFilterRange; in AutoFilter()
4408 …throw uno::RuntimeException( STR_ERRORMESSAGE_APPLIESTOSINGLERANGEONLY, uno::Reference< uno::XInte… in AutoFilter()
4414 uno::Reference< excel::XRange > xCurrent( CurrentRegion() ); in AutoFilter()
4419 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can't create AutoFilter")… in AutoFilter()
4447 uno::Reference< sheet::XDatabaseRanges > xDBRanges = lcl_GetDataBaseRanges( pShell ); in AutoFilter()
4456 xDataBaseRange.set( xDBRanges->getByName( sGenName ), uno::UNO_QUERY_THROW ); in AutoFilter()
4459 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Failed to find the autofi… in AutoFilter()
4461 uno::Reference< beans::XPropertySet > xDBRangeProps( xDataBaseRange, uno::UNO_QUERY_THROW ); in AutoFilter()
4463 …xDBRangeProps->setPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("AutoFilter") ), uno::… in AutoFilter()
4465 …uno::Reference< beans::XPropertySet > xFiltProps( xDataBaseRange->getFilterDescriptor(), uno::UNO_… in AutoFilter()
4466 …xFiltProps->setPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("ContainsHeader") ), uno:… in AutoFilter()
4492 throw uno::RuntimeException(); in AutoFilter()
4499 uno::Reference< sheet::XSheetFilterDescriptor2 > xDesc( in AutoFilter()
4500 xDataBaseRange->getFilterDescriptor(), uno::UNO_QUERY ); in AutoFilter()
4503 uno::Sequence< sheet::TableFilterField2 > sTabFilts; in AutoFilter()
4504 uno::Reference< beans::XPropertySet > xDescProps( xDesc, uno::UNO_QUERY_THROW ); in AutoFilter()
4559 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("UnknownOption") ), uno::R… in AutoFilter()
4580 uno::Reference< beans::XPropertySet > xProps; in AutoFilter()
4610 uno::Reference< beans::XPropertySet > xDBRangeProps( xDataBaseRange, uno::UNO_QUERY_THROW ); in AutoFilter()
4623 uno::Reference< sheet::XSheetFilterDescriptor2 > xSheetFilterDescriptor( in AutoFilter()
4624 xDataBaseRange->getFilterDescriptor(), uno::UNO_QUERY ); in AutoFilter()
4626 xSheetFilterDescriptor->setFilterFields2( uno::Sequence< sheet::TableFilterField2 >() ); in AutoFilter()
4628 …xDBRangeProps->setPropertyValue( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("AutoFilter") ), uno::… in AutoFilter()
4634 ScVbaRange::Insert( const uno::Any& Shift, const uno::Any& /* CopyOrigin */ ) throw (uno::RuntimeEx… in Insert()
4656 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM ("Illegal parameter ") ), … in Insert()
4668 …uno::Reference< sheet::XCellRangeMovement > xCellRangeMove( thisRange.getSpreadSheet(), uno::UNO_Q… in Insert()
4678 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( getDocShellFromRange( mxRange ) , … in Insert()
4679 …uno::Reference< excel::XRange > xVbaRange( new ScVbaRange( mxParent, mxContext, xRange, mbIsRows, … in Insert()
4680 xVbaRange->PasteSpecial( uno::Any(), uno::Any(), uno::Any(), uno::Any() ); in Insert()
4685 ScVbaRange::Autofit() throw (uno::RuntimeException) in Autofit()
4692 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32(index) ), uno::Any(… in Autofit()
4733 ScVbaRange::TextToColumns( const css::uno::Any& Destination, const css::uno::Any& DataType, const c… in TextToColumns()
4734 …const css::uno::Any& ConsecutinveDelimiter, const css::uno::Any& Tab, const css::uno::Any& Semicol… in TextToColumns()
4735 …const css::uno::Any& Space, const css::uno::Any& Other, const css::uno::Any& OtherChar, const css:… in TextToColumns()
4736 …onst css::uno::Any& DecimalSeparator, const css::uno::Any& ThousandsSeparator, const css::uno::Any… in TextToColumns()
4738 uno::Reference< excel::XRange > xRange; in TextToColumns()
4742 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "Destination parameter should be a ra… in TextToColumns()
4743 uno::Reference< uno::XInterface >() ); in TextToColumns()
4757 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "DataType parameter should be a short… in TextToColumns()
4758 uno::Reference< uno::XInterface >() ); in TextToColumns()
4767 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "TextQualifier parameter should be a … in TextToColumns()
4768 uno::Reference< uno::XInterface >() ); in TextToColumns()
4776 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "ConsecutinveDelimiter parameter shou… in TextToColumns()
4777 uno::Reference< uno::XInterface >() ); in TextToColumns()
4785 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "Tab parameter should be a boolean" ), in TextToColumns()
4786 uno::Reference< uno::XInterface >() ); in TextToColumns()
4794 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "Semicolon parameter should be a bool… in TextToColumns()
4795 uno::Reference< uno::XInterface >() ); in TextToColumns()
4802 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "Comma parameter should be a boolean"… in TextToColumns()
4803 uno::Reference< uno::XInterface >() ); in TextToColumns()
4810 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "Space parameter should be a boolean"… in TextToColumns()
4811 uno::Reference< uno::XInterface >() ); in TextToColumns()
4822 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "OtherChar parameter should be a Stri… in TextToColumns()
4823 uno::Reference< uno::XInterface >() ); in TextToColumns()
4827 … throw uno::RuntimeException( rtl::OUString::createFromAscii( "Other parameter should be a True" ), in TextToColumns()
4828 uno::Reference< uno::XInterface >() ); in TextToColumns()
4836 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "DecimalSeparator parameter should be… in TextToColumns()
4837 uno::Reference< uno::XInterface >() ); in TextToColumns()
4844 …throw uno::RuntimeException( rtl::OUString::createFromAscii( "ThousandsSeparator parameter should … in TextToColumns()
4845 uno::Reference< uno::XInterface >() ); in TextToColumns()
4851 uno::Any SAL_CALL
4852 ScVbaRange::Hyperlinks( const uno::Any& aIndex ) throw (uno::RuntimeException) in Hyperlinks()
4859 uno::Reference< excel::XWorksheet > xWorksheet( getParent(), uno::UNO_QUERY_THROW ); in Hyperlinks()
4860 …uno::Reference< excel::XHyperlinks > xSheetHlinks( xWorksheet->Hyperlinks( uno::Any() ), uno::UNO_… in Hyperlinks()
4863 …hrow uno::RuntimeException( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Cannot obtain hyperlink… in Hyperlinks()
4868 return xHlinks->Item( aIndex, uno::Any() ); in Hyperlinks()
4869 return uno::Any( uno::Reference< excel::XHyperlinks >( xHlinks.get() ) ); in Hyperlinks()
4872 css::uno::Reference< excel::XValidation > SAL_CALL
4873 ScVbaRange::getValidation() throw (css::uno::RuntimeException) in getValidation()
4882 sal_Unicode lclGetPrefixChar( const uno::Reference< table::XCell >& rxCell ) throw (uno::RuntimeExc… in lclGetPrefixChar()
4895 sal_Unicode lclGetPrefixChar( const uno::Reference< table::XCellRange >& rxRange ) throw (uno::Runt… in lclGetPrefixChar()
4911 …uno::Reference< table::XCell > xCell( rxRange->getCellByPosition( nCol, nRow ), uno::UNO_SET_THROW… in lclGetPrefixChar()
4922 sal_Unicode lclGetPrefixChar( const uno::Reference< sheet::XSheetCellRangeContainer >& rxRanges ) t… in lclGetPrefixChar()
4925 uno::Reference< container::XEnumerationAccess > xRangesEA( rxRanges, uno::UNO_QUERY_THROW ); in lclGetPrefixChar()
4926 …uno::Reference< container::XEnumeration > xRangesEnum( xRangesEA->createEnumeration(), uno::UNO_SE… in lclGetPrefixChar()
4929 … uno::Reference< table::XCellRange > xRange( xRangesEnum->nextElement(), uno::UNO_QUERY_THROW ); in lclGetPrefixChar()
4939 inline uno::Any lclGetPrefixVariant( sal_Unicode cPrefixChar ) in lclGetPrefixVariant()
4941 return uno::Any( (cPrefixChar == 0) ? ::rtl::OUString() : ::rtl::OUString( cPrefixChar ) ); in lclGetPrefixVariant()
4946 uno::Any SAL_CALL ScVbaRange::getPrefixCharacter() throw (uno::RuntimeException) in getPrefixCharacter()
4968 …throw uno::RuntimeException( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Unexpected empty Range… in getPrefixCharacter()
4971 uno::Any ScVbaRange::getShowDetail() throw ( css::uno::RuntimeException) in getShowDetail()
4977 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can not get Range.ShowDet… in getShowDetail()
4982 uno::Reference< sheet::XSheetCellCursor > xSheetCellCursor = helper.getSheetCellCursor(); in getShowDetail()
4984 …uno::Reference< sheet::XCellRangeAddressable > xCellRangeAddressable(xSheetCellCursor, uno::UNO_QU… in getShowDetail()
5003 return uno::makeAny( bShowDetail ); in getShowDetail()
5009 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can not set Range.ShowDet… in getShowDetail()
5014 void ScVbaRange::setShowDetail(const uno::Any& aShowDetail) throw ( css::uno::RuntimeException) in setShowDetail()
5020 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can not set Range.ShowDet… in setShowDetail()
5025 uno::Reference< sheet::XSheetCellCursor > xSheetCellCursor = helper.getSheetCellCursor(); in setShowDetail()
5027 …uno::Reference< sheet::XCellRangeAddressable > xCellRangeAddressable(xSheetCellCursor, uno::UNO_QU… in setShowDetail()
5037 …uno::Reference< sheet::XSheetOutline > xSheetOutline( helper.getSpreadSheet(), uno::UNO_QUERY_THRO… in setShowDetail()
5045 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("Can not set Range.ShowDet… in setShowDetail()
5049 uno::Reference< excel::XRange > SAL_CALL
5050 ScVbaRange::MergeArea() throw (script::BasicErrorException, uno::RuntimeException) in MergeArea()
5052 …uno::Reference< sheet::XSheetCellRange > xMergeShellCellRange(mxRange->getCellRangeByPosition(0,0,… in MergeArea()
5053 …uno::Reference< sheet::XSheetCellCursor > xMergeSheetCursor(xMergeShellCellRange->getSpreadsheet()… in MergeArea()
5057 …uno::Reference<sheet::XCellRangeAddressable> xMergeCellAddress(xMergeSheetCursor, uno::UNO_QUERY_T… in MergeArea()
5070 … uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( getScDocShell() , refRange ) ); in MergeArea()
5079 …uno::Any& From, const uno::Any& To, const uno::Any& Copies, const uno::Any& Preview, const uno::An… in PrintOut()
5084 uno::Sequence< table::CellRangeAddress > printAreas( nItems ); in PrintOut()
5085 uno::Reference< sheet::XPrintAreas > xPrintAreas; in PrintOut()
5088 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in PrintOut()
5097 xPrintAreas.set( thisRange.getSpreadSheet(), uno::UNO_QUERY_THROW ); in PrintOut()
5106 uno::Reference< frame::XModel > xModel = pShell->GetModel(); in PrintOut()
5113 ScVbaRange::AutoFill( const uno::Reference< excel::XRange >& Destination, const uno::Any& Type ) t… in AutoFill()
5115 uno::Reference< excel::XRange > xDest( Destination, uno::UNO_QUERY_THROW ); in AutoFill()
5220 …throw uno::RuntimeException( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "xlFillFormat not support… in AutoFill()
5238 ScVbaRange::GoalSeek( const uno::Any& Goal, const uno::Reference< excel::XRange >& ChangingCell ) t… in GoalSeek()
5245 uno::Reference< sheet::XGoalSeek > xGoalSeek( pDocShell->GetModel(), uno::UNO_QUERY_THROW ); in GoalSeek()
5254 ChangingCell->setValue( uno::makeAny( res.Result ) ); in GoalSeek()
5268 ScVbaRange::Calculate( ) throw (script::BasicErrorException, uno::RuntimeException) in Calculate()
5273 uno::Reference< excel::XRange > SAL_CALL
5274 ScVbaRange::Item( const uno::Any& row, const uno::Any& column ) throw (script::BasicErrorException,… in Item()
5280 uno::Reference< excel::XRange > xRange; in Item()
5291 ScVbaRange::AutoOutline( ) throw (script::BasicErrorException, uno::RuntimeException) in AutoOutline()
5307 …uno::Reference< sheet::XSheetOutline > xSheetOutline( thisRange.getSpreadSheet(), uno::UNO_QUERY_T… in AutoOutline()
5315 ScVbaRange:: ClearOutline( ) throw (script::BasicErrorException, uno::RuntimeException) in ClearOutline()
5322 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in ClearOutline()
5329 …uno::Reference< sheet::XSheetOutline > xSheetOutline( thisRange.getSpreadSheet(), uno::UNO_QUERY_T… in ClearOutline()
5334 ScVbaRange::groupUnGroup( bool bUnGroup ) throw ( script::BasicErrorException, uno::RuntimeExceptio… in groupUnGroup()
5343 …uno::Reference< sheet::XSheetOutline > xSheetOutline( thisRange.getSpreadSheet(), uno::UNO_QUERY_T… in groupUnGroup()
5351 ScVbaRange::Group( ) throw (script::BasicErrorException, uno::RuntimeException) in Group()
5356 ScVbaRange::Ungroup( ) throw (script::BasicErrorException, uno::RuntimeException) in Ungroup()
5361 …d lcl_mergeCellsOfRange( const uno::Reference< table::XCellRange >& xCellRange, sal_Bool _bMerge =… in lcl_mergeCellsOfRange()
5363 uno::Reference< util::XMergeable > xMergeable( xCellRange, uno::UNO_QUERY_THROW ); in lcl_mergeCellsOfRange()
5367 ScVbaRange::Merge( const uno::Any& Across ) throw (script::BasicErrorException, uno::RuntimeExcepti… in Merge()
5374 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in Merge()
5379 uno::Reference< table::XCellRange > oCellRange; in Merge()
5386 uno::Reference< excel::XRange > oRangeRowsImpl = Rows( uno::Any() ); in Merge()
5390 … oRangeRowsImpl->Cells( uno::makeAny( i ), uno::Any() )->Merge( uno::makeAny( sal_False ) ); in Merge()
5396 ScVbaRange::UnMerge( ) throw (script::BasicErrorException, uno::RuntimeException) in UnMerge()
5403 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in UnMerge()
5411 uno::Any SAL_CALL
5412 ScVbaRange::getStyle() throw (uno::RuntimeException) in getStyle()
5416 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32( 1 ) ), uno::Any() … in getStyle()
5419 uno::Reference< beans::XPropertySet > xProps( mxRange, uno::UNO_QUERY_THROW ); in getStyle()
5423 uno::Reference< frame::XModel > xModel( pShell->GetModel() ); in getStyle()
5424 uno::Reference< excel::XStyle > xStyle = new ScVbaStyle( this, mxContext, sStyleName, xModel ); in getStyle()
5425 return uno::makeAny( xStyle ); in getStyle()
5428 ScVbaRange::setStyle( const uno::Any& _style ) throw (uno::RuntimeException) in setStyle()
5432 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32( 1 ) ), uno::Any() … in setStyle()
5436 uno::Reference< beans::XPropertySet > xProps( mxRange, uno::UNO_QUERY_THROW ); in setStyle()
5437 uno::Reference< excel::XStyle > xStyle; in setStyle()
5439 xProps->setPropertyValue(CELLSTYLE, uno::makeAny(xStyle->getName())); in setStyle()
5442 uno::Reference< excel::XRange >
5466 uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( getScDocShell() , refRange ) ); in PreviousNext()
5471 uno::Reference< excel::XRange > SAL_CALL
5472 ScVbaRange::Next() throw (script::BasicErrorException, uno::RuntimeException) in Next()
5476 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32( 1 ) ), uno::Any() … in Next()
5482 uno::Reference< excel::XRange > SAL_CALL
5483 ScVbaRange::Previous() throw (script::BasicErrorException, uno::RuntimeException) in Previous()
5487 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny( sal_Int32( 1 ) ), uno::Any() … in Previous()
5493 uno::Reference< excel::XRange > SAL_CALL
5494 ScVbaRange::SpecialCells( const uno::Any& _oType, const uno::Any& _oValue) throw ( script::BasicErr… in SpecialCells()
5524 …uno::Reference< excel::XRange > xRange( m_Areas->Item( uno::makeAny(index), uno::Any() ), uno::UNO… in SpecialCells()
5532 …uno::Reference< excel::XRange > xTmpRange( m_Areas->Item( uno::makeAny( nArea ), uno::Any() ), uno… in SpecialCells()
5550 …uno::Reference< table::XCellRange > xRange( new ScCellRangeObj( getScDocShell(), *aCellRanges.Firs… in SpecialCells()
5553 …uno::Reference< sheet::XSheetCellRangeContainer > xRanges( new ScCellRangesObj( getScDocShell(), a… in SpecialCells()
5559 uno::Reference< excel::XRange > xUsedRange = getWorksheet()->getUsedRange(); in SpecialCells()
5574 sal_Int32 lcl_getFormulaResultFlags(const uno::Any& aType) throw ( script::BasicErrorException ) in lcl_getFormulaResultFlags()
5601 uno::Reference< excel::XRange >
5602 ScVbaRange::SpecialCellsImpl( sal_Int32 nType, const uno::Any& _oValue) throw ( script::BasicErrorE… in SpecialCellsImpl()
5604 uno::Reference< excel::XRange > xRange; in SpecialCellsImpl()
5607 uno::Reference< sheet::XCellRangesQuery > xQuery( mxRange, uno::UNO_QUERY_THROW ); in SpecialCellsImpl()
5608 uno::Reference< excel::XRange > oLocRangeImpl; in SpecialCellsImpl()
5609 uno::Reference< sheet::XSheetCellRanges > xLocSheetCellRanges; in SpecialCellsImpl()
5636 xRange = Cells( uno::makeAny( getCount() ), uno::Any() ); in SpecialCellsImpl()
5649 catch (uno::Exception& ) in SpecialCellsImpl()
5657 ScVbaRange::RemoveSubtotal( ) throw (script::BasicErrorException, uno::RuntimeException) in RemoveSubtotal()
5659 uno::Reference< sheet::XSubTotalCalculatable > xSub( mxRange, uno::UNO_QUERY_THROW ); in RemoveSubtotal()
5664 …uno::Sequence< ::sal_Int32 >& _nTotalList, const uno::Any& aReplace, const uno::Any& PageBreaks, c… in Subtotal()
5673 uno::Reference< sheet::XSubTotalCalculatable> xSub(mxRange, uno::UNO_QUERY_THROW ); in Subtotal()
5674 uno::Reference< sheet::XSubTotalDescriptor > xSubDesc = xSub->createSubTotalDescriptor(sal_True); in Subtotal()
5675 uno::Reference< beans::XPropertySet > xSubDescPropertySet( xSubDesc, uno::UNO_QUERY_THROW ); in Subtotal()
5676 xSubDescPropertySet->setPropertyValue(INSERTPAGEBREAKS, uno::makeAny( bAddPageBreaks)); in Subtotal()
5678 uno::Sequence< sheet::SubTotalColumn > aColumns( nLen ); in Subtotal()
5728 catch (uno::Exception& ) in Subtotal()
5741 uno::Sequence< rtl::OUString >
5744 static uno::Sequence< rtl::OUString > aServiceNames; in getServiceNames()