xref: /trunk/main/sc/source/ui/vba/vbachartobject.cxx (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
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 #include "vbachart.hxx"
28*cdf0e10cSrcweir #include <com/sun/star/beans/XPropertySet.hpp>
29*cdf0e10cSrcweir #include <com/sun/star/document/XEmbeddedObjectSupplier.hpp>
30*cdf0e10cSrcweir #include <com/sun/star/container/XNamed.hpp>
31*cdf0e10cSrcweir #include <com/sun/star/script/BasicErrorException.hpp>
32*cdf0e10cSrcweir #include <basic/sberrors.hxx>
33*cdf0e10cSrcweir #include "vbachartobject.hxx"
34*cdf0e10cSrcweir #include "vbachartobjects.hxx"
35*cdf0e10cSrcweir 
36*cdf0e10cSrcweir using namespace ::com::sun::star;
37*cdf0e10cSrcweir using namespace ::ooo::vba;
38*cdf0e10cSrcweir 
39*cdf0e10cSrcweir const rtl::OUString CHART_NAME( RTL_CONSTASCII_USTRINGPARAM("Name") );
40*cdf0e10cSrcweir const rtl::OUString PERSIST_NAME( RTL_CONSTASCII_USTRINGPARAM("PersistName") );
41*cdf0e10cSrcweir 
42*cdf0e10cSrcweir ScVbaChartObject::ScVbaChartObject( const css::uno::Reference< ov::XHelperInterface >& _xParent, const css::uno::Reference< css::uno::XComponentContext >& _xContext, const css::uno::Reference< css::table::XTableChart >& _xTableChart, const css::uno::Reference< css::drawing::XDrawPageSupplier >& _xDrawPageSupplier ) : ChartObjectImpl_BASE( _xParent, _xContext ), xTableChart( _xTableChart ), xDrawPageSupplier( _xDrawPageSupplier )
43*cdf0e10cSrcweir {
44*cdf0e10cSrcweir         xDrawPage = xDrawPageSupplier->getDrawPage();
45*cdf0e10cSrcweir         xEmbeddedObjectSupplier.set( xTableChart, uno::UNO_QUERY_THROW );
46*cdf0e10cSrcweir         xNamed.set( xTableChart, uno::UNO_QUERY_THROW );
47*cdf0e10cSrcweir         sPersistName = getPersistName();
48*cdf0e10cSrcweir         xShape = setShape();
49*cdf0e10cSrcweir         setName(sPersistName);
50*cdf0e10cSrcweir         oShapeHelper.reset(new ShapeHelper(xShape));
51*cdf0e10cSrcweir }
52*cdf0e10cSrcweir 
53*cdf0e10cSrcweir rtl::OUString ScVbaChartObject::getPersistName()
54*cdf0e10cSrcweir {
55*cdf0e10cSrcweir     if ( !sPersistName.getLength() )
56*cdf0e10cSrcweir         sPersistName = xNamed->getName();
57*cdf0e10cSrcweir     return sPersistName;
58*cdf0e10cSrcweir }
59*cdf0e10cSrcweir 
60*cdf0e10cSrcweir uno::Reference< drawing::XShape >
61*cdf0e10cSrcweir ScVbaChartObject::setShape() throw ( script::BasicErrorException )
62*cdf0e10cSrcweir {
63*cdf0e10cSrcweir     try
64*cdf0e10cSrcweir     {
65*cdf0e10cSrcweir         sal_Int32 nItems = xDrawPage->getCount();
66*cdf0e10cSrcweir         for (int i = 0; i < nItems; i++)
67*cdf0e10cSrcweir         {
68*cdf0e10cSrcweir             xShape.set( xDrawPage->getByIndex(i), uno::UNO_QUERY_THROW );
69*cdf0e10cSrcweir             if (xShape->getShapeType().compareToAscii("com.sun.star.drawing.OLE2Shape") == 0 )
70*cdf0e10cSrcweir             {
71*cdf0e10cSrcweir                 uno::Reference< beans::XPropertySet > xShapePropertySet(xShape, uno::UNO_QUERY_THROW );
72*cdf0e10cSrcweir                 rtl::OUString sName;
73*cdf0e10cSrcweir                 xShapePropertySet->getPropertyValue(PERSIST_NAME ) >>=sName;
74*cdf0e10cSrcweir                 if ( sName.equals(sPersistName))
75*cdf0e10cSrcweir                 {
76*cdf0e10cSrcweir                     xNamedShape.set( xShape, uno::UNO_QUERY_THROW );
77*cdf0e10cSrcweir                     return xShape;
78*cdf0e10cSrcweir                 }
79*cdf0e10cSrcweir             }
80*cdf0e10cSrcweir         }
81*cdf0e10cSrcweir     }
82*cdf0e10cSrcweir     catch (uno::Exception& )
83*cdf0e10cSrcweir     {
84*cdf0e10cSrcweir         throw script::BasicErrorException( rtl::OUString(), uno::Reference< uno::XInterface >(), SbERR_METHOD_FAILED, rtl::OUString() );
85*cdf0e10cSrcweir     }
86*cdf0e10cSrcweir     return NULL;
87*cdf0e10cSrcweir }
88*cdf0e10cSrcweir 
89*cdf0e10cSrcweir void SAL_CALL
90*cdf0e10cSrcweir ScVbaChartObject::setName( const rtl::OUString& sName ) throw (css::uno::RuntimeException)
91*cdf0e10cSrcweir {
92*cdf0e10cSrcweir     xNamedShape->setName(sName);
93*cdf0e10cSrcweir }
94*cdf0e10cSrcweir 
95*cdf0e10cSrcweir 
96*cdf0e10cSrcweir ::rtl::OUString SAL_CALL
97*cdf0e10cSrcweir ScVbaChartObject::getName() throw (css::uno::RuntimeException)
98*cdf0e10cSrcweir {
99*cdf0e10cSrcweir     return xNamedShape->getName();
100*cdf0e10cSrcweir }
101*cdf0e10cSrcweir 
102*cdf0e10cSrcweir void SAL_CALL
103*cdf0e10cSrcweir ScVbaChartObject::Delete() throw ( css::script::BasicErrorException )
104*cdf0e10cSrcweir {
105*cdf0e10cSrcweir     // parent of this object is sheet
106*cdf0e10cSrcweir     uno::Reference< excel::XWorksheet > xParent( getParent(), uno::UNO_QUERY_THROW );
107*cdf0e10cSrcweir     uno::Reference< excel::XChartObjects > xColl( xParent->ChartObjects( uno::Any() ), uno::UNO_QUERY_THROW );
108*cdf0e10cSrcweir     ScVbaChartObjects* pChartObjectsImpl = static_cast< ScVbaChartObjects* >( xColl.get() );
109*cdf0e10cSrcweir     if (pChartObjectsImpl)
110*cdf0e10cSrcweir         pChartObjectsImpl->removeByName( getPersistName() );
111*cdf0e10cSrcweir     else
112*cdf0e10cSrcweir         throw script::BasicErrorException( rtl::OUString(), uno::Reference< uno::XInterface >(), SbERR_METHOD_FAILED, rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Parent is not ChartObjects" ) ) );
113*cdf0e10cSrcweir }
114*cdf0e10cSrcweir 
115*cdf0e10cSrcweir void
116*cdf0e10cSrcweir ScVbaChartObject::Activate() throw ( script::BasicErrorException )
117*cdf0e10cSrcweir {
118*cdf0e10cSrcweir     try
119*cdf0e10cSrcweir     {
120*cdf0e10cSrcweir         // #TODO #FIXME should be ThisWorkbook or equivelant, or in
121*cdf0e10cSrcweir         // fact probably the chart object should be created with
122*cdf0e10cSrcweir         // the XModel owner
123*cdf0e10cSrcweir         //uno::Reference< view::XSelectionSupplier > xSelectionSupplier( getXModel().getCurrentController());
124*cdf0e10cSrcweir         uno::Reference< view::XSelectionSupplier > xSelectionSupplier( getCurrentExcelDoc(mxContext)->getCurrentController(), uno::UNO_QUERY_THROW );
125*cdf0e10cSrcweir         xSelectionSupplier->select(uno::makeAny(xShape));
126*cdf0e10cSrcweir     }
127*cdf0e10cSrcweir     catch (uno::Exception& )
128*cdf0e10cSrcweir     {
129*cdf0e10cSrcweir         throw script::BasicErrorException( rtl::OUString(), uno::Reference< uno::XInterface >(), SbERR_METHOD_FAILED, rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "ChartObject Activate internal error" ) ) );
130*cdf0e10cSrcweir     }
131*cdf0e10cSrcweir }
132*cdf0e10cSrcweir 
133*cdf0e10cSrcweir uno::Reference< excel::XChart > SAL_CALL
134*cdf0e10cSrcweir ScVbaChartObject::getChart() throw (css::uno::RuntimeException)
135*cdf0e10cSrcweir {
136*cdf0e10cSrcweir     return new ScVbaChart( this, mxContext, xEmbeddedObjectSupplier->getEmbeddedObject(), xTableChart );
137*cdf0e10cSrcweir }
138*cdf0e10cSrcweir 
139*cdf0e10cSrcweir rtl::OUString&
140*cdf0e10cSrcweir ScVbaChartObject::getServiceImplName()
141*cdf0e10cSrcweir {
142*cdf0e10cSrcweir     static rtl::OUString sImplName( RTL_CONSTASCII_USTRINGPARAM("ScVbaChartObject") );
143*cdf0e10cSrcweir     return sImplName;
144*cdf0e10cSrcweir }
145*cdf0e10cSrcweir 
146*cdf0e10cSrcweir uno::Sequence< rtl::OUString >
147*cdf0e10cSrcweir ScVbaChartObject::getServiceNames()
148*cdf0e10cSrcweir {
149*cdf0e10cSrcweir     static uno::Sequence< rtl::OUString > aServiceNames;
150*cdf0e10cSrcweir     if ( aServiceNames.getLength() == 0 )
151*cdf0e10cSrcweir     {
152*cdf0e10cSrcweir         aServiceNames.realloc( 1 );
153*cdf0e10cSrcweir         aServiceNames[ 0 ] = rtl::OUString( RTL_CONSTASCII_USTRINGPARAM("ooo.vba.excel.ChartObject" ) );
154*cdf0e10cSrcweir     }
155*cdf0e10cSrcweir     return aServiceNames;
156*cdf0e10cSrcweir }
157*cdf0e10cSrcweir 
158*cdf0e10cSrcweir double
159*cdf0e10cSrcweir ScVbaChartObject::getHeight()
160*cdf0e10cSrcweir {
161*cdf0e10cSrcweir     return oShapeHelper->getHeight();
162*cdf0e10cSrcweir }
163*cdf0e10cSrcweir 
164*cdf0e10cSrcweir void
165*cdf0e10cSrcweir ScVbaChartObject::setHeight(double _fheight) throw ( script::BasicErrorException )
166*cdf0e10cSrcweir {
167*cdf0e10cSrcweir     oShapeHelper->setHeight(_fheight);
168*cdf0e10cSrcweir }
169*cdf0e10cSrcweir 
170*cdf0e10cSrcweir double
171*cdf0e10cSrcweir ScVbaChartObject::getWidth()
172*cdf0e10cSrcweir {
173*cdf0e10cSrcweir         return oShapeHelper->getWidth();
174*cdf0e10cSrcweir }
175*cdf0e10cSrcweir 
176*cdf0e10cSrcweir void
177*cdf0e10cSrcweir ScVbaChartObject::setWidth(double _fWidth) throw ( script::BasicErrorException )
178*cdf0e10cSrcweir {
179*cdf0e10cSrcweir     oShapeHelper->setWidth(_fWidth);
180*cdf0e10cSrcweir }
181*cdf0e10cSrcweir 
182*cdf0e10cSrcweir double
183*cdf0e10cSrcweir ScVbaChartObject::getLeft()
184*cdf0e10cSrcweir {
185*cdf0e10cSrcweir         return oShapeHelper->getLeft();
186*cdf0e10cSrcweir }
187*cdf0e10cSrcweir 
188*cdf0e10cSrcweir void
189*cdf0e10cSrcweir ScVbaChartObject::setLeft(double _fLeft)
190*cdf0e10cSrcweir {
191*cdf0e10cSrcweir     oShapeHelper->setLeft(_fLeft);
192*cdf0e10cSrcweir }
193*cdf0e10cSrcweir 
194*cdf0e10cSrcweir double
195*cdf0e10cSrcweir ScVbaChartObject::getTop()
196*cdf0e10cSrcweir {
197*cdf0e10cSrcweir         return oShapeHelper->getTop();
198*cdf0e10cSrcweir }
199*cdf0e10cSrcweir 
200*cdf0e10cSrcweir void
201*cdf0e10cSrcweir ScVbaChartObject::setTop(double _fTop)
202*cdf0e10cSrcweir {
203*cdf0e10cSrcweir     oShapeHelper->setTop(_fTop);
204*cdf0e10cSrcweir }
205*cdf0e10cSrcweir 
206*cdf0e10cSrcweir uno::Reference< uno::XInterface >
207*cdf0e10cSrcweir ScVbaChartObject::getUnoObject() throw (script::BasicErrorException)
208*cdf0e10cSrcweir {
209*cdf0e10cSrcweir     return uno::Reference< uno::XInterface >( xShape, uno::UNO_QUERY );
210*cdf0e10cSrcweir }
211