1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir #ifndef SC_VBA_HYPERLINKS_HXX 29*cdf0e10cSrcweir #define SC_VBA_HYPERLINKS_HXX 30*cdf0e10cSrcweir 31*cdf0e10cSrcweir #include <ooo/vba/excel/XHyperlinks.hpp> 32*cdf0e10cSrcweir #include <rtl/ref.hxx> 33*cdf0e10cSrcweir #include <vbahelper/vbacollectionimpl.hxx> 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir class ScRangeList; 36*cdf0e10cSrcweir 37*cdf0e10cSrcweir // ============================================================================ 38*cdf0e10cSrcweir 39*cdf0e10cSrcweir namespace detail { 40*cdf0e10cSrcweir 41*cdf0e10cSrcweir class ScVbaHlinkContainer; 42*cdf0e10cSrcweir typedef ::rtl::Reference< ScVbaHlinkContainer > ScVbaHlinkContainerRef; 43*cdf0e10cSrcweir 44*cdf0e10cSrcweir /** Base class for ScVbaHyperlinks to get an initialized ScVbaHlinkContainer 45*cdf0e10cSrcweir class member before the ScVbaHyperlinks_BASE base class will be constructed. 46*cdf0e10cSrcweir */ 47*cdf0e10cSrcweir struct ScVbaHlinkContainerMember 48*cdf0e10cSrcweir { 49*cdf0e10cSrcweir ScVbaHlinkContainerRef mxContainer; 50*cdf0e10cSrcweir 51*cdf0e10cSrcweir explicit ScVbaHlinkContainerMember( ScVbaHlinkContainer* pContainer ); 52*cdf0e10cSrcweir ~ScVbaHlinkContainerMember(); 53*cdf0e10cSrcweir }; 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir } // namespace detail 56*cdf0e10cSrcweir 57*cdf0e10cSrcweir // ============================================================================ 58*cdf0e10cSrcweir 59*cdf0e10cSrcweir class ScVbaHyperlinks; 60*cdf0e10cSrcweir typedef ::rtl::Reference< ScVbaHyperlinks > ScVbaHyperlinksRef; 61*cdf0e10cSrcweir 62*cdf0e10cSrcweir typedef CollTestImplHelper< ov::excel::XHyperlinks > ScVbaHyperlinks_BASE; 63*cdf0e10cSrcweir 64*cdf0e10cSrcweir /** Represents a collection of hyperlinks of a worksheet or of a range. 65*cdf0e10cSrcweir 66*cdf0e10cSrcweir When a Hyperlinks collection object has been constructed from a VBA 67*cdf0e10cSrcweir Worksheet object, it will always represent the current set of all 68*cdf0e10cSrcweir hyperlinks existing in the sheet. Insertion and deletion of hyperlinks will 69*cdf0e10cSrcweir be reflected by the instance. 70*cdf0e10cSrcweir 71*cdf0e10cSrcweir When a Hyperlinks collection object has been constructed from a VBA Range 72*cdf0e10cSrcweir object, it will represent the set of hyperlinks that have existed at its 73*cdf0e10cSrcweir construction time, and that are located completely inside the range(s) 74*cdf0e10cSrcweir represented by the Range object. Insertion and deletion of hyperlinks will 75*cdf0e10cSrcweir *not* be reflected by that instance. The instance will always offer all 76*cdf0e10cSrcweir hyperlinks it has been constructed with, even if they no longer exist. 77*cdf0e10cSrcweir Furthermore, the instance will not offer hyperlinks inserted later, even if 78*cdf0e10cSrcweir the instance itself has been used to insert the new hyperlinks. 79*cdf0e10cSrcweir 80*cdf0e10cSrcweir VBA code example: 81*cdf0e10cSrcweir 82*cdf0e10cSrcweir With ThisWorkbook.Worksheets(1) 83*cdf0e10cSrcweir 84*cdf0e10cSrcweir Set hlinks = .Hyperlinks ' global Hyperlinks object 85*cdf0e10cSrcweir Set myrange = .Range("A1:C3") 86*cdf0e10cSrcweir Set rangelinks1 = myrange.Hyperlinks ' hyperlinks of range A1:C3 87*cdf0e10cSrcweir 88*cdf0e10cSrcweir MsgBox hlinks.Count ' 0 89*cdf0e10cSrcweir MsgBox rangelinks1.Count ' 0 90*cdf0e10cSrcweir 91*cdf0e10cSrcweir hlinks.Add .Range("A1"), "http://example.com" 92*cdf0e10cSrcweir ' a new hyperlink has been added in cell A1 93*cdf0e10cSrcweir 94*cdf0e10cSrcweir MsgBox hlinks.Count ' 1 95*cdf0e10cSrcweir MsgBox rangelinks1.Count ' still 0! 96*cdf0e10cSrcweir Set rangelinks2 = myrange.Hyperlinks ' hyperlinks of range A1:C3 97*cdf0e10cSrcweir MsgBox rangelinks2.Count ' 1 (constructed after Add) 98*cdf0e10cSrcweir 99*cdf0e10cSrcweir rangelinks1.Add .Range("A2"), "http://example.com" 100*cdf0e10cSrcweir ' a new hyperlink has been constructed via the rangelinks1 object 101*cdf0e10cSrcweir ' but this addition has been done by the worksheet Hyperlinks object 102*cdf0e10cSrcweir 103*cdf0e10cSrcweir MsgBox hlinks.Count ' 2 104*cdf0e10cSrcweir MsgBox rangelinks1.Count ' still 0!!! 105*cdf0e10cSrcweir MsgBox rangelinks2.Count ' still 1!!! 106*cdf0e10cSrcweir MsgBox myrange.Hyperlinks.Count ' 2 (constructed after Add) 107*cdf0e10cSrcweir 108*cdf0e10cSrcweir End With 109*cdf0e10cSrcweir */ 110*cdf0e10cSrcweir class ScVbaHyperlinks : private detail::ScVbaHlinkContainerMember, public ScVbaHyperlinks_BASE 111*cdf0e10cSrcweir { 112*cdf0e10cSrcweir public: 113*cdf0e10cSrcweir explicit ScVbaHyperlinks( 114*cdf0e10cSrcweir const css::uno::Reference< ov::XHelperInterface >& rxParent, 115*cdf0e10cSrcweir const css::uno::Reference< css::uno::XComponentContext >& rxContext ) throw (css::uno::RuntimeException); 116*cdf0e10cSrcweir 117*cdf0e10cSrcweir explicit ScVbaHyperlinks( 118*cdf0e10cSrcweir const css::uno::Reference< ov::XHelperInterface >& rxParent, 119*cdf0e10cSrcweir const css::uno::Reference< css::uno::XComponentContext >& rxContext, 120*cdf0e10cSrcweir const ScVbaHyperlinksRef& rxSheetHlinks, const ScRangeList& rScRanges ) throw (css::uno::RuntimeException); 121*cdf0e10cSrcweir 122*cdf0e10cSrcweir virtual ~ScVbaHyperlinks(); 123*cdf0e10cSrcweir 124*cdf0e10cSrcweir // XHyperlinks 125*cdf0e10cSrcweir virtual css::uno::Reference< ov::excel::XHyperlink > SAL_CALL Add( 126*cdf0e10cSrcweir const css::uno::Any& rAnchor, const css::uno::Any& rAddress, const css::uno::Any& rSubAddress, 127*cdf0e10cSrcweir const css::uno::Any& rScreenTip, const css::uno::Any& rTextToDisplay ) 128*cdf0e10cSrcweir throw (css::uno::RuntimeException); 129*cdf0e10cSrcweir 130*cdf0e10cSrcweir virtual void SAL_CALL Delete() throw (css::uno::RuntimeException); 131*cdf0e10cSrcweir 132*cdf0e10cSrcweir // XEnumerationAccess 133*cdf0e10cSrcweir virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() throw (css::uno::RuntimeException); 134*cdf0e10cSrcweir 135*cdf0e10cSrcweir // XElementAccess 136*cdf0e10cSrcweir virtual css::uno::Type SAL_CALL getElementType() throw (css::uno::RuntimeException); 137*cdf0e10cSrcweir 138*cdf0e10cSrcweir // ScVbaCollectionBase 139*cdf0e10cSrcweir virtual css::uno::Any createCollectionObject( const css::uno::Any& rSource ); 140*cdf0e10cSrcweir 141*cdf0e10cSrcweir // XHelperInterface 142*cdf0e10cSrcweir VBAHELPER_DECL_XHELPERINTERFACE 143*cdf0e10cSrcweir 144*cdf0e10cSrcweir private: 145*cdf0e10cSrcweir ScVbaHyperlinksRef mxSheetHlinks; 146*cdf0e10cSrcweir }; 147*cdf0e10cSrcweir 148*cdf0e10cSrcweir // ============================================================================ 149*cdf0e10cSrcweir 150*cdf0e10cSrcweir #endif 151