xref: /trunk/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