1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_xmloff.hxx"
26*b1cdbd2cSJim Jagielski #include "formcellbinding.hxx"
27*b1cdbd2cSJim Jagielski #include <com/sun/star/form/binding/XBindableValue.hpp>
28*b1cdbd2cSJim Jagielski #include <com/sun/star/form/binding/XListEntrySink.hpp>
29*b1cdbd2cSJim Jagielski #include <com/sun/star/form/XGridColumnFactory.hpp>
30*b1cdbd2cSJim Jagielski #include <com/sun/star/frame/XModel.hpp>
31*b1cdbd2cSJim Jagielski #include <com/sun/star/container/XChild.hpp>
32*b1cdbd2cSJim Jagielski #include <com/sun/star/container/XNamed.hpp>
33*b1cdbd2cSJim Jagielski #include <com/sun/star/drawing/XDrawPageSupplier.hpp>
34*b1cdbd2cSJim Jagielski #include <com/sun/star/table/XCellRange.hpp>
35*b1cdbd2cSJim Jagielski #include <com/sun/star/form/XFormsSupplier.hpp>
36*b1cdbd2cSJim Jagielski #include <com/sun/star/form/XForm.hpp>
37*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/XServiceInfo.hpp>
38*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/XMultiServiceFactory.hpp>
39*b1cdbd2cSJim Jagielski #include <com/sun/star/beans/NamedValue.hpp>
40*b1cdbd2cSJim Jagielski #include "strings.hxx"
41*b1cdbd2cSJim Jagielski #include <osl/diagnose.h>
42*b1cdbd2cSJim Jagielski #include <rtl/logfile.hxx>
43*b1cdbd2cSJim Jagielski
44*b1cdbd2cSJim Jagielski #include <functional>
45*b1cdbd2cSJim Jagielski #include <algorithm>
46*b1cdbd2cSJim Jagielski
47*b1cdbd2cSJim Jagielski //............................................................................
48*b1cdbd2cSJim Jagielski namespace xmloff
49*b1cdbd2cSJim Jagielski {
50*b1cdbd2cSJim Jagielski //............................................................................
51*b1cdbd2cSJim Jagielski
52*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
53*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans;
54*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::frame;
55*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sheet;
56*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container;
57*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::drawing;
58*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::table;
59*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::form;
60*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
61*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::form::binding;
62*b1cdbd2cSJim Jagielski
63*b1cdbd2cSJim Jagielski namespace
64*b1cdbd2cSJim Jagielski {
65*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Reference;
66*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::XInterface;
67*b1cdbd2cSJim Jagielski using ::com::sun::star::container::XChild;
68*b1cdbd2cSJim Jagielski using ::com::sun::star::frame::XModel;
69*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::UNO_QUERY;
70*b1cdbd2cSJim Jagielski
71*b1cdbd2cSJim Jagielski //....................................................................
72*b1cdbd2cSJim Jagielski template< class TYPE >
getTypedModelNode(const Reference<XInterface> & _rxModelNode)73*b1cdbd2cSJim Jagielski Reference< TYPE > getTypedModelNode( const Reference< XInterface >& _rxModelNode )
74*b1cdbd2cSJim Jagielski {
75*b1cdbd2cSJim Jagielski Reference< TYPE > xTypedNode( _rxModelNode, UNO_QUERY );
76*b1cdbd2cSJim Jagielski if ( xTypedNode.is() )
77*b1cdbd2cSJim Jagielski return xTypedNode;
78*b1cdbd2cSJim Jagielski else
79*b1cdbd2cSJim Jagielski {
80*b1cdbd2cSJim Jagielski Reference< XChild > xChild( _rxModelNode, UNO_QUERY );
81*b1cdbd2cSJim Jagielski if ( xChild.is() )
82*b1cdbd2cSJim Jagielski return getTypedModelNode< TYPE >( xChild->getParent() );
83*b1cdbd2cSJim Jagielski else
84*b1cdbd2cSJim Jagielski return NULL;
85*b1cdbd2cSJim Jagielski }
86*b1cdbd2cSJim Jagielski }
87*b1cdbd2cSJim Jagielski
88*b1cdbd2cSJim Jagielski //....................................................................
getDocument(const Reference<XInterface> & _rxModelNode)89*b1cdbd2cSJim Jagielski Reference< XModel > getDocument( const Reference< XInterface >& _rxModelNode )
90*b1cdbd2cSJim Jagielski {
91*b1cdbd2cSJim Jagielski return getTypedModelNode< XModel >( _rxModelNode );
92*b1cdbd2cSJim Jagielski }
93*b1cdbd2cSJim Jagielski
94*b1cdbd2cSJim Jagielski //....................................................................
95*b1cdbd2cSJim Jagielski struct StringCompare : public ::std::unary_function< ::rtl::OUString, bool >
96*b1cdbd2cSJim Jagielski {
97*b1cdbd2cSJim Jagielski private:
98*b1cdbd2cSJim Jagielski const ::rtl::OUString m_sReference;
99*b1cdbd2cSJim Jagielski
100*b1cdbd2cSJim Jagielski public:
StringComparexmloff::__anonc172e0e00111::StringCompare101*b1cdbd2cSJim Jagielski StringCompare( const ::rtl::OUString& _rReference ) : m_sReference( _rReference ) { }
102*b1cdbd2cSJim Jagielski
operator ()xmloff::__anonc172e0e00111::StringCompare103*b1cdbd2cSJim Jagielski inline bool operator()( const ::rtl::OUString& _rCompare )
104*b1cdbd2cSJim Jagielski {
105*b1cdbd2cSJim Jagielski return ( _rCompare == m_sReference );
106*b1cdbd2cSJim Jagielski }
107*b1cdbd2cSJim Jagielski };
108*b1cdbd2cSJim Jagielski }
109*b1cdbd2cSJim Jagielski
110*b1cdbd2cSJim Jagielski //========================================================================
111*b1cdbd2cSJim Jagielski //= FormCellBindingHelper
112*b1cdbd2cSJim Jagielski //========================================================================
113*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
FormCellBindingHelper(const Reference<XPropertySet> & _rxControlModel,const Reference<XModel> & _rxDocument)114*b1cdbd2cSJim Jagielski FormCellBindingHelper::FormCellBindingHelper( const Reference< XPropertySet >& _rxControlModel, const Reference< XModel >& _rxDocument )
115*b1cdbd2cSJim Jagielski :m_xControlModel( _rxControlModel )
116*b1cdbd2cSJim Jagielski ,m_xDocument( _rxDocument, UNO_QUERY )
117*b1cdbd2cSJim Jagielski {
118*b1cdbd2cSJim Jagielski OSL_ENSURE( m_xControlModel.is(), "FormCellBindingHelper::FormCellBindingHelper: invalid control model!" );
119*b1cdbd2cSJim Jagielski
120*b1cdbd2cSJim Jagielski if ( !m_xDocument.is() )
121*b1cdbd2cSJim Jagielski m_xDocument = m_xDocument.query( getDocument( m_xControlModel ) );
122*b1cdbd2cSJim Jagielski OSL_ENSURE( m_xDocument.is(), "FormCellBindingHelper::FormCellBindingHelper: Did not find the spreadsheet document!" );
123*b1cdbd2cSJim Jagielski }
124*b1cdbd2cSJim Jagielski
125*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
livesInSpreadsheetDocument(const Reference<XPropertySet> & _rxControlModel)126*b1cdbd2cSJim Jagielski sal_Bool FormCellBindingHelper::livesInSpreadsheetDocument( const Reference< XPropertySet >& _rxControlModel )
127*b1cdbd2cSJim Jagielski {
128*b1cdbd2cSJim Jagielski Reference< XSpreadsheetDocument > xDocument( getDocument( _rxControlModel ), UNO_QUERY );
129*b1cdbd2cSJim Jagielski return xDocument.is();
130*b1cdbd2cSJim Jagielski }
131*b1cdbd2cSJim Jagielski
132*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
convertStringAddress(const::rtl::OUString & _rAddressDescription,CellAddress & _rAddress,sal_Int16) const133*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::convertStringAddress( const ::rtl::OUString& _rAddressDescription, CellAddress& /* [out] */ _rAddress, sal_Int16 /*_nAssumeSheet*/ ) const
134*b1cdbd2cSJim Jagielski {
135*b1cdbd2cSJim Jagielski Any aAddress;
136*b1cdbd2cSJim Jagielski return doConvertAddressRepresentations(
137*b1cdbd2cSJim Jagielski PROPERTY_FILE_REPRESENTATION,
138*b1cdbd2cSJim Jagielski makeAny( _rAddressDescription ),
139*b1cdbd2cSJim Jagielski PROPERTY_ADDRESS,
140*b1cdbd2cSJim Jagielski aAddress,
141*b1cdbd2cSJim Jagielski false
142*b1cdbd2cSJim Jagielski )
143*b1cdbd2cSJim Jagielski && ( aAddress >>= _rAddress );
144*b1cdbd2cSJim Jagielski }
145*b1cdbd2cSJim Jagielski
146*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
convertStringAddress(const::rtl::OUString & _rAddressDescription,CellRangeAddress & _rAddress) const147*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::convertStringAddress( const ::rtl::OUString& _rAddressDescription,
148*b1cdbd2cSJim Jagielski CellRangeAddress& /* [out] */ _rAddress ) const
149*b1cdbd2cSJim Jagielski {
150*b1cdbd2cSJim Jagielski Any aAddress;
151*b1cdbd2cSJim Jagielski return doConvertAddressRepresentations(
152*b1cdbd2cSJim Jagielski PROPERTY_FILE_REPRESENTATION,
153*b1cdbd2cSJim Jagielski makeAny( _rAddressDescription ),
154*b1cdbd2cSJim Jagielski PROPERTY_ADDRESS,
155*b1cdbd2cSJim Jagielski aAddress,
156*b1cdbd2cSJim Jagielski true
157*b1cdbd2cSJim Jagielski )
158*b1cdbd2cSJim Jagielski && ( aAddress >>= _rAddress );
159*b1cdbd2cSJim Jagielski }
160*b1cdbd2cSJim Jagielski
161*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
createCellBindingFromStringAddress(const::rtl::OUString & _rAddress,bool _bUseIntegerBinding) const162*b1cdbd2cSJim Jagielski Reference< XValueBinding > FormCellBindingHelper::createCellBindingFromStringAddress( const ::rtl::OUString& _rAddress, bool _bUseIntegerBinding ) const
163*b1cdbd2cSJim Jagielski {
164*b1cdbd2cSJim Jagielski Reference< XValueBinding > xBinding;
165*b1cdbd2cSJim Jagielski if ( !m_xDocument.is() )
166*b1cdbd2cSJim Jagielski // very bad ...
167*b1cdbd2cSJim Jagielski return xBinding;
168*b1cdbd2cSJim Jagielski
169*b1cdbd2cSJim Jagielski // get the UNO representation of the address
170*b1cdbd2cSJim Jagielski CellAddress aAddress;
171*b1cdbd2cSJim Jagielski if ( !_rAddress.getLength() || !convertStringAddress( _rAddress, aAddress ) )
172*b1cdbd2cSJim Jagielski return xBinding;
173*b1cdbd2cSJim Jagielski
174*b1cdbd2cSJim Jagielski xBinding = xBinding.query( createDocumentDependentInstance(
175*b1cdbd2cSJim Jagielski _bUseIntegerBinding ? SERVICE_LISTINDEXCELLBINDING : SERVICE_CELLVALUEBINDING,
176*b1cdbd2cSJim Jagielski PROPERTY_BOUND_CELL,
177*b1cdbd2cSJim Jagielski makeAny( aAddress )
178*b1cdbd2cSJim Jagielski ) );
179*b1cdbd2cSJim Jagielski
180*b1cdbd2cSJim Jagielski return xBinding;
181*b1cdbd2cSJim Jagielski }
182*b1cdbd2cSJim Jagielski
183*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
createCellListSourceFromStringAddress(const::rtl::OUString & _rAddress) const184*b1cdbd2cSJim Jagielski Reference< XListEntrySource > FormCellBindingHelper::createCellListSourceFromStringAddress( const ::rtl::OUString& _rAddress ) const
185*b1cdbd2cSJim Jagielski {
186*b1cdbd2cSJim Jagielski Reference< XListEntrySource > xSource;
187*b1cdbd2cSJim Jagielski
188*b1cdbd2cSJim Jagielski CellRangeAddress aRangeAddress;
189*b1cdbd2cSJim Jagielski if ( !convertStringAddress( _rAddress, aRangeAddress ) )
190*b1cdbd2cSJim Jagielski return xSource;
191*b1cdbd2cSJim Jagielski
192*b1cdbd2cSJim Jagielski // create a range object for this address
193*b1cdbd2cSJim Jagielski xSource = xSource.query( createDocumentDependentInstance(
194*b1cdbd2cSJim Jagielski SERVICE_CELLRANGELISTSOURCE,
195*b1cdbd2cSJim Jagielski PROPERTY_LIST_CELL_RANGE,
196*b1cdbd2cSJim Jagielski makeAny( aRangeAddress )
197*b1cdbd2cSJim Jagielski ) );
198*b1cdbd2cSJim Jagielski
199*b1cdbd2cSJim Jagielski return xSource;
200*b1cdbd2cSJim Jagielski }
201*b1cdbd2cSJim Jagielski
202*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getStringAddressFromCellBinding(const Reference<XValueBinding> & _rxBinding) const203*b1cdbd2cSJim Jagielski ::rtl::OUString FormCellBindingHelper::getStringAddressFromCellBinding( const Reference< XValueBinding >& _rxBinding ) const
204*b1cdbd2cSJim Jagielski {
205*b1cdbd2cSJim Jagielski OSL_PRECOND( !_rxBinding.is() || isCellBinding( _rxBinding ), "FormCellBindingHelper::getStringAddressFromCellBinding: this is no cell binding!" );
206*b1cdbd2cSJim Jagielski
207*b1cdbd2cSJim Jagielski ::rtl::OUString sAddress;
208*b1cdbd2cSJim Jagielski try
209*b1cdbd2cSJim Jagielski {
210*b1cdbd2cSJim Jagielski Reference< XPropertySet > xBindingProps( _rxBinding, UNO_QUERY );
211*b1cdbd2cSJim Jagielski OSL_ENSURE( xBindingProps.is() || !_rxBinding.is(), "FormCellBindingHelper::getStringAddressFromCellBinding: no property set for the binding!" );
212*b1cdbd2cSJim Jagielski if ( xBindingProps.is() )
213*b1cdbd2cSJim Jagielski {
214*b1cdbd2cSJim Jagielski CellAddress aAddress;
215*b1cdbd2cSJim Jagielski xBindingProps->getPropertyValue( PROPERTY_BOUND_CELL ) >>= aAddress;
216*b1cdbd2cSJim Jagielski
217*b1cdbd2cSJim Jagielski Any aStringAddress;
218*b1cdbd2cSJim Jagielski doConvertAddressRepresentations( PROPERTY_ADDRESS, makeAny( aAddress ),
219*b1cdbd2cSJim Jagielski PROPERTY_FILE_REPRESENTATION, aStringAddress, false );
220*b1cdbd2cSJim Jagielski
221*b1cdbd2cSJim Jagielski aStringAddress >>= sAddress;
222*b1cdbd2cSJim Jagielski }
223*b1cdbd2cSJim Jagielski }
224*b1cdbd2cSJim Jagielski catch( const Exception& )
225*b1cdbd2cSJim Jagielski {
226*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "FormCellBindingHelper::getStringAddressFromCellBinding: caught an exception!" );
227*b1cdbd2cSJim Jagielski }
228*b1cdbd2cSJim Jagielski
229*b1cdbd2cSJim Jagielski return sAddress;
230*b1cdbd2cSJim Jagielski }
231*b1cdbd2cSJim Jagielski
232*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getStringAddressFromCellListSource(const Reference<XListEntrySource> & _rxSource) const233*b1cdbd2cSJim Jagielski ::rtl::OUString FormCellBindingHelper::getStringAddressFromCellListSource( const Reference< XListEntrySource >& _rxSource ) const
234*b1cdbd2cSJim Jagielski {
235*b1cdbd2cSJim Jagielski OSL_PRECOND( !_rxSource.is() || isCellRangeListSource( _rxSource ), "FormCellBindingHelper::getStringAddressFromCellListSource: this is no cell list source!" );
236*b1cdbd2cSJim Jagielski
237*b1cdbd2cSJim Jagielski ::rtl::OUString sAddress;
238*b1cdbd2cSJim Jagielski try
239*b1cdbd2cSJim Jagielski {
240*b1cdbd2cSJim Jagielski Reference< XPropertySet > xSourceProps( _rxSource, UNO_QUERY );
241*b1cdbd2cSJim Jagielski OSL_ENSURE( xSourceProps.is() || !_rxSource.is(), "FormCellBindingHelper::getStringAddressFromCellListSource: no property set for the list source!" );
242*b1cdbd2cSJim Jagielski if ( xSourceProps.is() )
243*b1cdbd2cSJim Jagielski {
244*b1cdbd2cSJim Jagielski CellRangeAddress aRangeAddress;
245*b1cdbd2cSJim Jagielski xSourceProps->getPropertyValue( PROPERTY_LIST_CELL_RANGE ) >>= aRangeAddress;
246*b1cdbd2cSJim Jagielski
247*b1cdbd2cSJim Jagielski Any aStringAddress;
248*b1cdbd2cSJim Jagielski doConvertAddressRepresentations( PROPERTY_ADDRESS, makeAny( aRangeAddress ),
249*b1cdbd2cSJim Jagielski PROPERTY_FILE_REPRESENTATION, aStringAddress, true );
250*b1cdbd2cSJim Jagielski aStringAddress >>= sAddress;
251*b1cdbd2cSJim Jagielski }
252*b1cdbd2cSJim Jagielski }
253*b1cdbd2cSJim Jagielski catch( const Exception& )
254*b1cdbd2cSJim Jagielski {
255*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "FormCellBindingHelper::getStringAddressFromCellListSource: caught an exception!" );
256*b1cdbd2cSJim Jagielski }
257*b1cdbd2cSJim Jagielski
258*b1cdbd2cSJim Jagielski return sAddress;
259*b1cdbd2cSJim Jagielski }
260*b1cdbd2cSJim Jagielski
261*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isSpreadsheetDocumentWhichSupplies(const Reference<XSpreadsheetDocument> & _rxDocument,const::rtl::OUString & _rService)262*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isSpreadsheetDocumentWhichSupplies( const Reference< XSpreadsheetDocument >& _rxDocument, const ::rtl::OUString& _rService ) SAL_THROW(())
263*b1cdbd2cSJim Jagielski {
264*b1cdbd2cSJim Jagielski bool bYesItIs = false;
265*b1cdbd2cSJim Jagielski
266*b1cdbd2cSJim Jagielski try
267*b1cdbd2cSJim Jagielski {
268*b1cdbd2cSJim Jagielski Reference< XServiceInfo > xSI( _rxDocument, UNO_QUERY );
269*b1cdbd2cSJim Jagielski if ( xSI.is() && xSI->supportsService( SERVICE_SPREADSHEET_DOCUMENT ) )
270*b1cdbd2cSJim Jagielski {
271*b1cdbd2cSJim Jagielski Reference< XMultiServiceFactory > xDocumentFactory( _rxDocument, UNO_QUERY );
272*b1cdbd2cSJim Jagielski OSL_ENSURE( xDocumentFactory.is(), "FormCellBindingHelper::isSpreadsheetDocumentWhichSupplies: spreadsheet document, but no factory?" );
273*b1cdbd2cSJim Jagielski
274*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > aAvailableServices;
275*b1cdbd2cSJim Jagielski if ( xDocumentFactory.is() )
276*b1cdbd2cSJim Jagielski aAvailableServices = xDocumentFactory->getAvailableServiceNames( );
277*b1cdbd2cSJim Jagielski
278*b1cdbd2cSJim Jagielski const ::rtl::OUString* pFound = ::std::find_if(
279*b1cdbd2cSJim Jagielski aAvailableServices.getConstArray(),
280*b1cdbd2cSJim Jagielski aAvailableServices.getConstArray() + aAvailableServices.getLength(),
281*b1cdbd2cSJim Jagielski StringCompare( _rService )
282*b1cdbd2cSJim Jagielski );
283*b1cdbd2cSJim Jagielski if ( pFound - aAvailableServices.getConstArray() < aAvailableServices.getLength() )
284*b1cdbd2cSJim Jagielski {
285*b1cdbd2cSJim Jagielski bYesItIs = true;
286*b1cdbd2cSJim Jagielski }
287*b1cdbd2cSJim Jagielski }
288*b1cdbd2cSJim Jagielski }
289*b1cdbd2cSJim Jagielski catch( const Exception& )
290*b1cdbd2cSJim Jagielski {
291*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "FormCellBindingHelper::isSpreadsheetDocumentWhichSupplies: caught an exception!" );
292*b1cdbd2cSJim Jagielski }
293*b1cdbd2cSJim Jagielski
294*b1cdbd2cSJim Jagielski return bYesItIs;
295*b1cdbd2cSJim Jagielski }
296*b1cdbd2cSJim Jagielski
297*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isSpreadsheetDocumentWhichSupplies(const::rtl::OUString & _rService) const298*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isSpreadsheetDocumentWhichSupplies( const ::rtl::OUString& _rService ) const SAL_THROW(())
299*b1cdbd2cSJim Jagielski {
300*b1cdbd2cSJim Jagielski return isSpreadsheetDocumentWhichSupplies( m_xDocument, _rService );
301*b1cdbd2cSJim Jagielski }
302*b1cdbd2cSJim Jagielski
303*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isListCellRangeAllowed(const Reference<XModel> & _rxDocument)304*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isListCellRangeAllowed( const Reference< XModel >& _rxDocument )
305*b1cdbd2cSJim Jagielski {
306*b1cdbd2cSJim Jagielski return isSpreadsheetDocumentWhichSupplies(
307*b1cdbd2cSJim Jagielski Reference< XSpreadsheetDocument >( _rxDocument, UNO_QUERY ),
308*b1cdbd2cSJim Jagielski SERVICE_CELLRANGELISTSOURCE
309*b1cdbd2cSJim Jagielski );
310*b1cdbd2cSJim Jagielski }
311*b1cdbd2cSJim Jagielski
312*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isListCellRangeAllowed() const313*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isListCellRangeAllowed( ) const
314*b1cdbd2cSJim Jagielski {
315*b1cdbd2cSJim Jagielski bool bAllow( false );
316*b1cdbd2cSJim Jagielski
317*b1cdbd2cSJim Jagielski Reference< XListEntrySink > xSink( m_xControlModel, UNO_QUERY );
318*b1cdbd2cSJim Jagielski if ( xSink.is() )
319*b1cdbd2cSJim Jagielski {
320*b1cdbd2cSJim Jagielski bAllow = isSpreadsheetDocumentWhichSupplies( SERVICE_CELLRANGELISTSOURCE );
321*b1cdbd2cSJim Jagielski }
322*b1cdbd2cSJim Jagielski
323*b1cdbd2cSJim Jagielski return bAllow;
324*b1cdbd2cSJim Jagielski }
325*b1cdbd2cSJim Jagielski
326*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isCellBindingAllowed() const327*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isCellBindingAllowed( ) const
328*b1cdbd2cSJim Jagielski {
329*b1cdbd2cSJim Jagielski bool bAllow( false );
330*b1cdbd2cSJim Jagielski
331*b1cdbd2cSJim Jagielski Reference< XBindableValue > xBindable( m_xControlModel, UNO_QUERY );
332*b1cdbd2cSJim Jagielski if ( xBindable.is() )
333*b1cdbd2cSJim Jagielski {
334*b1cdbd2cSJim Jagielski // the control can potentially be bound to an external value
335*b1cdbd2cSJim Jagielski // Does it live within a Calc document, and is able to supply CellBindings?
336*b1cdbd2cSJim Jagielski bAllow = isSpreadsheetDocumentWhichSupplies( SERVICE_CELLVALUEBINDING );
337*b1cdbd2cSJim Jagielski }
338*b1cdbd2cSJim Jagielski
339*b1cdbd2cSJim Jagielski return bAllow;
340*b1cdbd2cSJim Jagielski }
341*b1cdbd2cSJim Jagielski
342*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isCellBindingAllowed(const Reference<XModel> & _rxDocument)343*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isCellBindingAllowed( const Reference< XModel >& _rxDocument )
344*b1cdbd2cSJim Jagielski {
345*b1cdbd2cSJim Jagielski return isSpreadsheetDocumentWhichSupplies(
346*b1cdbd2cSJim Jagielski Reference< XSpreadsheetDocument >( _rxDocument, UNO_QUERY ),
347*b1cdbd2cSJim Jagielski SERVICE_CELLVALUEBINDING
348*b1cdbd2cSJim Jagielski );
349*b1cdbd2cSJim Jagielski }
350*b1cdbd2cSJim Jagielski
351*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isCellBinding(const Reference<XValueBinding> & _rxBinding) const352*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isCellBinding( const Reference< XValueBinding >& _rxBinding ) const
353*b1cdbd2cSJim Jagielski {
354*b1cdbd2cSJim Jagielski return doesComponentSupport( _rxBinding.get(), SERVICE_CELLVALUEBINDING );
355*b1cdbd2cSJim Jagielski }
356*b1cdbd2cSJim Jagielski
357*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isCellIntegerBinding(const Reference<XValueBinding> & _rxBinding) const358*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isCellIntegerBinding( const Reference< XValueBinding >& _rxBinding ) const
359*b1cdbd2cSJim Jagielski {
360*b1cdbd2cSJim Jagielski return doesComponentSupport( _rxBinding.get(), SERVICE_LISTINDEXCELLBINDING );
361*b1cdbd2cSJim Jagielski }
362*b1cdbd2cSJim Jagielski
363*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
isCellRangeListSource(const Reference<XListEntrySource> & _rxSource) const364*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::isCellRangeListSource( const Reference< XListEntrySource >& _rxSource ) const
365*b1cdbd2cSJim Jagielski {
366*b1cdbd2cSJim Jagielski return doesComponentSupport( _rxSource.get(), SERVICE_CELLRANGELISTSOURCE );
367*b1cdbd2cSJim Jagielski }
368*b1cdbd2cSJim Jagielski
369*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
doesComponentSupport(const Reference<XInterface> & _rxComponent,const::rtl::OUString & _rService) const370*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::doesComponentSupport( const Reference< XInterface >& _rxComponent, const ::rtl::OUString& _rService ) const
371*b1cdbd2cSJim Jagielski {
372*b1cdbd2cSJim Jagielski bool bDoes = false;
373*b1cdbd2cSJim Jagielski Reference< XServiceInfo > xSI( _rxComponent, UNO_QUERY );
374*b1cdbd2cSJim Jagielski bDoes = xSI.is() && xSI->supportsService( _rService );
375*b1cdbd2cSJim Jagielski return bDoes;
376*b1cdbd2cSJim Jagielski }
377*b1cdbd2cSJim Jagielski
378*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getCurrentBinding() const379*b1cdbd2cSJim Jagielski Reference< XValueBinding > FormCellBindingHelper::getCurrentBinding( ) const
380*b1cdbd2cSJim Jagielski {
381*b1cdbd2cSJim Jagielski Reference< XValueBinding > xBinding;
382*b1cdbd2cSJim Jagielski Reference< XBindableValue > xBindable( m_xControlModel, UNO_QUERY );
383*b1cdbd2cSJim Jagielski if ( xBindable.is() )
384*b1cdbd2cSJim Jagielski xBinding = xBindable->getValueBinding();
385*b1cdbd2cSJim Jagielski return xBinding;
386*b1cdbd2cSJim Jagielski }
387*b1cdbd2cSJim Jagielski
388*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
getCurrentListSource() const389*b1cdbd2cSJim Jagielski Reference< XListEntrySource > FormCellBindingHelper::getCurrentListSource( ) const
390*b1cdbd2cSJim Jagielski {
391*b1cdbd2cSJim Jagielski Reference< XListEntrySource > xSource;
392*b1cdbd2cSJim Jagielski Reference< XListEntrySink > xSink( m_xControlModel, UNO_QUERY );
393*b1cdbd2cSJim Jagielski if ( xSink.is() )
394*b1cdbd2cSJim Jagielski xSource = xSink->getListEntrySource();
395*b1cdbd2cSJim Jagielski return xSource;
396*b1cdbd2cSJim Jagielski }
397*b1cdbd2cSJim Jagielski
398*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
setBinding(const Reference<XValueBinding> & _rxBinding)399*b1cdbd2cSJim Jagielski void FormCellBindingHelper::setBinding( const Reference< XValueBinding >& _rxBinding )
400*b1cdbd2cSJim Jagielski {
401*b1cdbd2cSJim Jagielski Reference< XBindableValue > xBindable( m_xControlModel, UNO_QUERY );
402*b1cdbd2cSJim Jagielski OSL_PRECOND( xBindable.is(), "FormCellBindingHelper::setBinding: the object is not bindable!" );
403*b1cdbd2cSJim Jagielski if ( xBindable.is() )
404*b1cdbd2cSJim Jagielski xBindable->setValueBinding( _rxBinding );
405*b1cdbd2cSJim Jagielski }
406*b1cdbd2cSJim Jagielski
407*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
setListSource(const Reference<XListEntrySource> & _rxSource)408*b1cdbd2cSJim Jagielski void FormCellBindingHelper::setListSource( const Reference< XListEntrySource >& _rxSource )
409*b1cdbd2cSJim Jagielski {
410*b1cdbd2cSJim Jagielski Reference< XListEntrySink > xSink( m_xControlModel, UNO_QUERY );
411*b1cdbd2cSJim Jagielski OSL_PRECOND( xSink.is(), "FormCellBindingHelper::setListSource: the object is no list entry sink!" );
412*b1cdbd2cSJim Jagielski if ( xSink.is() )
413*b1cdbd2cSJim Jagielski xSink->setListEntrySource( _rxSource );
414*b1cdbd2cSJim Jagielski }
415*b1cdbd2cSJim Jagielski
416*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
createDocumentDependentInstance(const::rtl::OUString & _rService,const::rtl::OUString & _rArgumentName,const Any & _rArgumentValue) const417*b1cdbd2cSJim Jagielski Reference< XInterface > FormCellBindingHelper::createDocumentDependentInstance( const ::rtl::OUString& _rService, const ::rtl::OUString& _rArgumentName,
418*b1cdbd2cSJim Jagielski const Any& _rArgumentValue ) const
419*b1cdbd2cSJim Jagielski {
420*b1cdbd2cSJim Jagielski Reference< XInterface > xReturn;
421*b1cdbd2cSJim Jagielski
422*b1cdbd2cSJim Jagielski Reference< XMultiServiceFactory > xDocumentFactory( m_xDocument, UNO_QUERY );
423*b1cdbd2cSJim Jagielski OSL_ENSURE( xDocumentFactory.is(), "FormCellBindingHelper::createDocumentDependentInstance: no document service factory!" );
424*b1cdbd2cSJim Jagielski if ( xDocumentFactory.is() )
425*b1cdbd2cSJim Jagielski {
426*b1cdbd2cSJim Jagielski try
427*b1cdbd2cSJim Jagielski {
428*b1cdbd2cSJim Jagielski if ( _rArgumentName.getLength() )
429*b1cdbd2cSJim Jagielski {
430*b1cdbd2cSJim Jagielski NamedValue aArg;
431*b1cdbd2cSJim Jagielski aArg.Name = _rArgumentName;
432*b1cdbd2cSJim Jagielski aArg.Value = _rArgumentValue;
433*b1cdbd2cSJim Jagielski
434*b1cdbd2cSJim Jagielski Sequence< Any > aArgs( 1 );
435*b1cdbd2cSJim Jagielski aArgs[ 0 ] <<= aArg;
436*b1cdbd2cSJim Jagielski
437*b1cdbd2cSJim Jagielski xReturn = xDocumentFactory->createInstanceWithArguments( _rService, aArgs );
438*b1cdbd2cSJim Jagielski }
439*b1cdbd2cSJim Jagielski else
440*b1cdbd2cSJim Jagielski {
441*b1cdbd2cSJim Jagielski xReturn = xDocumentFactory->createInstance( _rService );
442*b1cdbd2cSJim Jagielski }
443*b1cdbd2cSJim Jagielski }
444*b1cdbd2cSJim Jagielski catch ( const Exception& )
445*b1cdbd2cSJim Jagielski {
446*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "FormCellBindingHelper::createDocumentDependentInstance: could not create the binding at the document!" );
447*b1cdbd2cSJim Jagielski }
448*b1cdbd2cSJim Jagielski }
449*b1cdbd2cSJim Jagielski return xReturn;
450*b1cdbd2cSJim Jagielski }
451*b1cdbd2cSJim Jagielski
452*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
doConvertAddressRepresentations(const::rtl::OUString & _rInputProperty,const Any & _rInputValue,const::rtl::OUString & _rOutputProperty,Any & _rOutputValue,bool _bIsRange) const453*b1cdbd2cSJim Jagielski bool FormCellBindingHelper::doConvertAddressRepresentations( const ::rtl::OUString& _rInputProperty, const Any& _rInputValue,
454*b1cdbd2cSJim Jagielski const ::rtl::OUString& _rOutputProperty, Any& _rOutputValue, bool _bIsRange ) const SAL_THROW(())
455*b1cdbd2cSJim Jagielski {
456*b1cdbd2cSJim Jagielski bool bSuccess = false;
457*b1cdbd2cSJim Jagielski
458*b1cdbd2cSJim Jagielski Reference< XPropertySet > xConverter(
459*b1cdbd2cSJim Jagielski createDocumentDependentInstance(
460*b1cdbd2cSJim Jagielski _bIsRange ? SERVICE_RANGEADDRESS_CONVERSION : SERVICE_ADDRESS_CONVERSION,
461*b1cdbd2cSJim Jagielski ::rtl::OUString(),
462*b1cdbd2cSJim Jagielski Any()
463*b1cdbd2cSJim Jagielski ),
464*b1cdbd2cSJim Jagielski UNO_QUERY
465*b1cdbd2cSJim Jagielski );
466*b1cdbd2cSJim Jagielski OSL_ENSURE( xConverter.is(), "FormCellBindingHelper::doConvertAddressRepresentations: could not get a converter service!" );
467*b1cdbd2cSJim Jagielski if ( xConverter.is() )
468*b1cdbd2cSJim Jagielski {
469*b1cdbd2cSJim Jagielski try
470*b1cdbd2cSJim Jagielski {
471*b1cdbd2cSJim Jagielski xConverter->setPropertyValue( _rInputProperty, _rInputValue );
472*b1cdbd2cSJim Jagielski _rOutputValue = xConverter->getPropertyValue( _rOutputProperty );
473*b1cdbd2cSJim Jagielski bSuccess = true;
474*b1cdbd2cSJim Jagielski }
475*b1cdbd2cSJim Jagielski catch( const Exception& )
476*b1cdbd2cSJim Jagielski {
477*b1cdbd2cSJim Jagielski OSL_ENSURE( sal_False, "FormCellBindingHelper::doConvertAddressRepresentations: caught an exception!" );
478*b1cdbd2cSJim Jagielski }
479*b1cdbd2cSJim Jagielski }
480*b1cdbd2cSJim Jagielski
481*b1cdbd2cSJim Jagielski return bSuccess;
482*b1cdbd2cSJim Jagielski }
483*b1cdbd2cSJim Jagielski
484*b1cdbd2cSJim Jagielski //............................................................................
485*b1cdbd2cSJim Jagielski } // namespace xmloff
486*b1cdbd2cSJim Jagielski //............................................................................
487