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