xref: /AOO41X/main/sc/source/ui/docshell/servobj.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 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_sc.hxx"
30*cdf0e10cSrcweir // System - Includes -----------------------------------------------------
31*cdf0e10cSrcweir 
32*cdf0e10cSrcweir 
33*cdf0e10cSrcweir 
34*cdf0e10cSrcweir #include <sot/formats.hxx>
35*cdf0e10cSrcweir #include <sfx2/app.hxx>
36*cdf0e10cSrcweir #include <sfx2/linkmgr.hxx>
37*cdf0e10cSrcweir #include "servobj.hxx"
38*cdf0e10cSrcweir #include "docsh.hxx"
39*cdf0e10cSrcweir #include "impex.hxx"
40*cdf0e10cSrcweir #include "brdcst.hxx"
41*cdf0e10cSrcweir #include "rangenam.hxx"
42*cdf0e10cSrcweir #include "sc.hrc"				// SC_HINT_AREAS_CHANGED
43*cdf0e10cSrcweir 
44*cdf0e10cSrcweir // -----------------------------------------------------------------------
45*cdf0e10cSrcweir 
46*cdf0e10cSrcweir sal_Bool lcl_FillRangeFromName( ScRange& rRange, ScDocShell* pDocSh, const String& rName )
47*cdf0e10cSrcweir {
48*cdf0e10cSrcweir 	if (pDocSh)
49*cdf0e10cSrcweir 	{
50*cdf0e10cSrcweir 		ScDocument* pDoc = pDocSh->GetDocument();
51*cdf0e10cSrcweir 		ScRangeName* pNames = pDoc->GetRangeName();
52*cdf0e10cSrcweir 		if (pNames)
53*cdf0e10cSrcweir 		{
54*cdf0e10cSrcweir 			sal_uInt16 nPos;
55*cdf0e10cSrcweir 			if( pNames->SearchName( rName, nPos ) )
56*cdf0e10cSrcweir 			{
57*cdf0e10cSrcweir 				ScRangeData* pData = (*pNames)[ nPos ];
58*cdf0e10cSrcweir 				if ( pData->IsValidReference( rRange ) )
59*cdf0e10cSrcweir 					return sal_True;
60*cdf0e10cSrcweir 			}
61*cdf0e10cSrcweir 		}
62*cdf0e10cSrcweir 	}
63*cdf0e10cSrcweir 	return sal_False;
64*cdf0e10cSrcweir }
65*cdf0e10cSrcweir 
66*cdf0e10cSrcweir ScServerObjectSvtListenerForwarder::ScServerObjectSvtListenerForwarder(
67*cdf0e10cSrcweir         ScServerObject* pObjP)
68*cdf0e10cSrcweir     : pObj(pObjP)
69*cdf0e10cSrcweir {
70*cdf0e10cSrcweir }
71*cdf0e10cSrcweir 
72*cdf0e10cSrcweir ScServerObjectSvtListenerForwarder::~ScServerObjectSvtListenerForwarder()
73*cdf0e10cSrcweir {
74*cdf0e10cSrcweir     //! do NOT access pObj
75*cdf0e10cSrcweir }
76*cdf0e10cSrcweir 
77*cdf0e10cSrcweir void ScServerObjectSvtListenerForwarder::Notify( SvtBroadcaster& /* rBC */, const SfxHint& rHint)
78*cdf0e10cSrcweir {
79*cdf0e10cSrcweir     pObj->Notify( aBroadcaster, rHint);
80*cdf0e10cSrcweir }
81*cdf0e10cSrcweir 
82*cdf0e10cSrcweir ScServerObject::ScServerObject( ScDocShell* pShell, const String& rItem ) :
83*cdf0e10cSrcweir     aForwarder( this ),
84*cdf0e10cSrcweir 	pDocSh( pShell ),
85*cdf0e10cSrcweir 	bRefreshListener( sal_False )
86*cdf0e10cSrcweir {
87*cdf0e10cSrcweir 	//	parse item string
88*cdf0e10cSrcweir 
89*cdf0e10cSrcweir 	if ( lcl_FillRangeFromName( aRange, pDocSh, rItem ) )
90*cdf0e10cSrcweir 	{
91*cdf0e10cSrcweir 		aItemStr = rItem;				// must be parsed again on ref update
92*cdf0e10cSrcweir 	}
93*cdf0e10cSrcweir 	else
94*cdf0e10cSrcweir 	{
95*cdf0e10cSrcweir 		//	parse ref
96*cdf0e10cSrcweir 		ScDocument* pDoc = pDocSh->GetDocument();
97*cdf0e10cSrcweir 		SCTAB nTab = pDocSh->GetCurTab();
98*cdf0e10cSrcweir 		aRange.aStart.SetTab( nTab );
99*cdf0e10cSrcweir 
100*cdf0e10cSrcweir 		if ( aRange.Parse( rItem, pDoc ) & SCA_VALID )
101*cdf0e10cSrcweir 		{
102*cdf0e10cSrcweir 			// area reference
103*cdf0e10cSrcweir 		}
104*cdf0e10cSrcweir 		else if ( aRange.aStart.Parse( rItem, pDoc, pDoc->GetAddressConvention() ) & SCA_VALID )
105*cdf0e10cSrcweir 		{
106*cdf0e10cSrcweir 			// cell reference
107*cdf0e10cSrcweir 			aRange.aEnd = aRange.aStart;
108*cdf0e10cSrcweir 		}
109*cdf0e10cSrcweir 		else
110*cdf0e10cSrcweir 		{
111*cdf0e10cSrcweir 			DBG_ERROR("ScServerObject: invalid item");
112*cdf0e10cSrcweir 		}
113*cdf0e10cSrcweir 	}
114*cdf0e10cSrcweir 
115*cdf0e10cSrcweir 	pDocSh->GetDocument()->GetLinkManager()->InsertServer( this );
116*cdf0e10cSrcweir 	pDocSh->GetDocument()->StartListeningArea( aRange, &aForwarder );
117*cdf0e10cSrcweir 
118*cdf0e10cSrcweir 	StartListening(*pDocSh);		// um mitzubekommen, wenn die DocShell geloescht wird
119*cdf0e10cSrcweir 	StartListening(*SFX_APP());		// for SC_HINT_AREAS_CHANGED
120*cdf0e10cSrcweir }
121*cdf0e10cSrcweir 
122*cdf0e10cSrcweir __EXPORT ScServerObject::~ScServerObject()
123*cdf0e10cSrcweir {
124*cdf0e10cSrcweir 	Clear();
125*cdf0e10cSrcweir }
126*cdf0e10cSrcweir 
127*cdf0e10cSrcweir void ScServerObject::Clear()
128*cdf0e10cSrcweir {
129*cdf0e10cSrcweir 	if (pDocSh)
130*cdf0e10cSrcweir 	{
131*cdf0e10cSrcweir 		ScDocShell* pTemp = pDocSh;
132*cdf0e10cSrcweir 		pDocSh = NULL;
133*cdf0e10cSrcweir 
134*cdf0e10cSrcweir 		pTemp->GetDocument()->EndListeningArea( aRange, &aForwarder );
135*cdf0e10cSrcweir 		pTemp->GetDocument()->GetLinkManager()->RemoveServer( this );
136*cdf0e10cSrcweir 		EndListening(*pTemp);
137*cdf0e10cSrcweir 		EndListening(*SFX_APP());
138*cdf0e10cSrcweir 	}
139*cdf0e10cSrcweir }
140*cdf0e10cSrcweir 
141*cdf0e10cSrcweir void ScServerObject::EndListeningAll()
142*cdf0e10cSrcweir {
143*cdf0e10cSrcweir     aForwarder.EndListeningAll();
144*cdf0e10cSrcweir     SfxListener::EndListeningAll();
145*cdf0e10cSrcweir }
146*cdf0e10cSrcweir 
147*cdf0e10cSrcweir sal_Bool __EXPORT ScServerObject::GetData(
148*cdf0e10cSrcweir 		::com::sun::star::uno::Any & rData /*out param*/,
149*cdf0e10cSrcweir         const String & rMimeType, sal_Bool /* bSynchron */ )
150*cdf0e10cSrcweir {
151*cdf0e10cSrcweir 	if (!pDocSh)
152*cdf0e10cSrcweir 		return sal_False;
153*cdf0e10cSrcweir 
154*cdf0e10cSrcweir 	// named ranges may have changed -> update aRange
155*cdf0e10cSrcweir 	if ( aItemStr.Len() )
156*cdf0e10cSrcweir 	{
157*cdf0e10cSrcweir 		ScRange aNew;
158*cdf0e10cSrcweir 		if ( lcl_FillRangeFromName( aNew, pDocSh, aItemStr ) && aNew != aRange )
159*cdf0e10cSrcweir 		{
160*cdf0e10cSrcweir 			aRange = aNew;
161*cdf0e10cSrcweir 			bRefreshListener = sal_True;
162*cdf0e10cSrcweir 		}
163*cdf0e10cSrcweir 	}
164*cdf0e10cSrcweir 
165*cdf0e10cSrcweir 	if ( bRefreshListener )
166*cdf0e10cSrcweir 	{
167*cdf0e10cSrcweir 		//	refresh the listeners now (this is called from a timer)
168*cdf0e10cSrcweir 
169*cdf0e10cSrcweir 		EndListeningAll();
170*cdf0e10cSrcweir 		pDocSh->GetDocument()->StartListeningArea( aRange, &aForwarder );
171*cdf0e10cSrcweir 		StartListening(*pDocSh);
172*cdf0e10cSrcweir 		StartListening(*SFX_APP());
173*cdf0e10cSrcweir 		bRefreshListener = sal_False;
174*cdf0e10cSrcweir 	}
175*cdf0e10cSrcweir 
176*cdf0e10cSrcweir 	String aDdeTextFmt = pDocSh->GetDdeTextFmt();
177*cdf0e10cSrcweir 	ScDocument* pDoc = pDocSh->GetDocument();
178*cdf0e10cSrcweir 
179*cdf0e10cSrcweir 	if( FORMAT_STRING == SotExchange::GetFormatIdFromMimeType( rMimeType ))
180*cdf0e10cSrcweir 	{
181*cdf0e10cSrcweir 		ScImportExport aObj( pDoc, aRange );
182*cdf0e10cSrcweir 		if( aDdeTextFmt.GetChar(0) == 'F' )
183*cdf0e10cSrcweir 			aObj.SetFormulas( sal_True );
184*cdf0e10cSrcweir 		if( aDdeTextFmt.EqualsAscii( "SYLK" ) ||
185*cdf0e10cSrcweir 			aDdeTextFmt.EqualsAscii( "FSYLK" ) )
186*cdf0e10cSrcweir 		{
187*cdf0e10cSrcweir 			ByteString aByteData;
188*cdf0e10cSrcweir 			if( aObj.ExportByteString( aByteData, gsl_getSystemTextEncoding(), SOT_FORMATSTR_ID_SYLK ) )
189*cdf0e10cSrcweir 			{
190*cdf0e10cSrcweir 				rData <<= ::com::sun::star::uno::Sequence< sal_Int8 >(
191*cdf0e10cSrcweir 										(sal_Int8*)aByteData.GetBuffer(),
192*cdf0e10cSrcweir 										aByteData.Len() + 1 );
193*cdf0e10cSrcweir 				return 1;
194*cdf0e10cSrcweir 			}
195*cdf0e10cSrcweir 			return 0;
196*cdf0e10cSrcweir 		}
197*cdf0e10cSrcweir 		if( aDdeTextFmt.EqualsAscii( "CSV" ) ||
198*cdf0e10cSrcweir 			aDdeTextFmt.EqualsAscii( "FCSV" ) )
199*cdf0e10cSrcweir 			aObj.SetSeparator( ',' );
200*cdf0e10cSrcweir         aObj.SetExportTextOptions( ScExportTextOptions( ScExportTextOptions::ToSpace, ' ', false ) );
201*cdf0e10cSrcweir 		return aObj.ExportData( rMimeType, rData ) ? 1 : 0;
202*cdf0e10cSrcweir 	}
203*cdf0e10cSrcweir 
204*cdf0e10cSrcweir 	ScImportExport aObj( pDoc, aRange );
205*cdf0e10cSrcweir     aObj.SetExportTextOptions( ScExportTextOptions( ScExportTextOptions::ToSpace, ' ', false ) );
206*cdf0e10cSrcweir 	if( aObj.IsRef() )
207*cdf0e10cSrcweir 		return aObj.ExportData( rMimeType, rData ) ? 1 : 0;
208*cdf0e10cSrcweir 	return 0;
209*cdf0e10cSrcweir }
210*cdf0e10cSrcweir 
211*cdf0e10cSrcweir void __EXPORT ScServerObject::Notify( SfxBroadcaster& rBC, const SfxHint& rHint )
212*cdf0e10cSrcweir {
213*cdf0e10cSrcweir 	sal_Bool bDataChanged = sal_False;
214*cdf0e10cSrcweir 
215*cdf0e10cSrcweir 	//	DocShell can't be tested via type info, because SFX_HINT_DYING comes from the dtor
216*cdf0e10cSrcweir 	if ( &rBC == pDocSh )
217*cdf0e10cSrcweir 	{
218*cdf0e10cSrcweir 		//	from DocShell, only SFX_HINT_DYING is interesting
219*cdf0e10cSrcweir 		if ( rHint.ISA(SfxSimpleHint) && ((const SfxSimpleHint&)rHint).GetId() == SFX_HINT_DYING )
220*cdf0e10cSrcweir 		{
221*cdf0e10cSrcweir 			pDocSh = NULL;
222*cdf0e10cSrcweir 			EndListening(*SFX_APP());
223*cdf0e10cSrcweir 			//	don't access DocShell anymore for EndListening etc.
224*cdf0e10cSrcweir 		}
225*cdf0e10cSrcweir 	}
226*cdf0e10cSrcweir 	else if (rBC.ISA(SfxApplication))
227*cdf0e10cSrcweir 	{
228*cdf0e10cSrcweir 		if ( aItemStr.Len() && rHint.ISA(SfxSimpleHint) &&
229*cdf0e10cSrcweir 				((const SfxSimpleHint&)rHint).GetId() == SC_HINT_AREAS_CHANGED )
230*cdf0e10cSrcweir 		{
231*cdf0e10cSrcweir 			//	check if named range was modified
232*cdf0e10cSrcweir 			ScRange aNew;
233*cdf0e10cSrcweir 			if ( lcl_FillRangeFromName( aNew, pDocSh, aItemStr ) && aNew != aRange )
234*cdf0e10cSrcweir 				bDataChanged = sal_True;
235*cdf0e10cSrcweir 		}
236*cdf0e10cSrcweir 	}
237*cdf0e10cSrcweir 	else
238*cdf0e10cSrcweir 	{
239*cdf0e10cSrcweir 		//	must be from Area broadcasters
240*cdf0e10cSrcweir 
241*cdf0e10cSrcweir 		const ScHint* pScHint = PTR_CAST( ScHint, &rHint );
242*cdf0e10cSrcweir 		if( pScHint && (pScHint->GetId() & (SC_HINT_DATACHANGED | SC_HINT_DYING)) )
243*cdf0e10cSrcweir 			bDataChanged = sal_True;
244*cdf0e10cSrcweir 		else if (rHint.ISA(ScAreaChangedHint))		// position of broadcaster changed
245*cdf0e10cSrcweir 		{
246*cdf0e10cSrcweir 			ScRange aNewRange = ((const ScAreaChangedHint&)rHint).GetRange();
247*cdf0e10cSrcweir 			if ( aRange != aNewRange )
248*cdf0e10cSrcweir 			{
249*cdf0e10cSrcweir 				bRefreshListener = sal_True;
250*cdf0e10cSrcweir 				bDataChanged = sal_True;
251*cdf0e10cSrcweir 			}
252*cdf0e10cSrcweir 		}
253*cdf0e10cSrcweir 		else if (rHint.ISA(SfxSimpleHint))
254*cdf0e10cSrcweir 		{
255*cdf0e10cSrcweir             sal_uLong nId = ((const SfxSimpleHint&)rHint).GetId();
256*cdf0e10cSrcweir 			if (nId == SFX_HINT_DYING)
257*cdf0e10cSrcweir 			{
258*cdf0e10cSrcweir 				//	If the range is being deleted, listening must be restarted
259*cdf0e10cSrcweir 				//	after the deletion is complete (done in GetData)
260*cdf0e10cSrcweir 				bRefreshListener = sal_True;
261*cdf0e10cSrcweir 				bDataChanged = sal_True;
262*cdf0e10cSrcweir 			}
263*cdf0e10cSrcweir 		}
264*cdf0e10cSrcweir 	}
265*cdf0e10cSrcweir 
266*cdf0e10cSrcweir 	if ( bDataChanged && HasDataLinks() )
267*cdf0e10cSrcweir 		SvLinkSource::NotifyDataChanged();
268*cdf0e10cSrcweir }
269*cdf0e10cSrcweir 
270*cdf0e10cSrcweir 
271*cdf0e10cSrcweir 
272*cdf0e10cSrcweir 
273*cdf0e10cSrcweir 
274