xref: /aoo41x/main/sc/source/ui/vba/vbahyperlinks.hxx (revision cdf0e10c)
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