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 10cdf0e10cSrcweir * 11*b3f79822SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 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. 19cdf0e10cSrcweir * 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 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 62cdf0e10cSrcweir ScServerObjectSvtListenerForwarder::ScServerObjectSvtListenerForwarder( 63cdf0e10cSrcweir ScServerObject* pObjP) 64cdf0e10cSrcweir : pObj(pObjP) 65cdf0e10cSrcweir { 66cdf0e10cSrcweir } 67cdf0e10cSrcweir 68cdf0e10cSrcweir ScServerObjectSvtListenerForwarder::~ScServerObjectSvtListenerForwarder() 69cdf0e10cSrcweir { 70cdf0e10cSrcweir //! do NOT access pObj 71cdf0e10cSrcweir } 72cdf0e10cSrcweir 73cdf0e10cSrcweir void ScServerObjectSvtListenerForwarder::Notify( SvtBroadcaster& /* rBC */, const SfxHint& rHint) 74cdf0e10cSrcweir { 75cdf0e10cSrcweir pObj->Notify( aBroadcaster, rHint); 76cdf0e10cSrcweir } 77cdf0e10cSrcweir 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 118cdf0e10cSrcweir __EXPORT ScServerObject::~ScServerObject() 119cdf0e10cSrcweir { 120cdf0e10cSrcweir Clear(); 121cdf0e10cSrcweir } 122cdf0e10cSrcweir 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 137cdf0e10cSrcweir void ScServerObject::EndListeningAll() 138cdf0e10cSrcweir { 139cdf0e10cSrcweir aForwarder.EndListeningAll(); 140cdf0e10cSrcweir SfxListener::EndListeningAll(); 141cdf0e10cSrcweir } 142cdf0e10cSrcweir 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 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