Excel user defined functions unlimited

//---------------------------------------------------------------------------
//  Excel Multivalue Formula Add-In
//  Copyright (C) <2005> <Herbert Danler>
//  Contact: danler@users.sourceforge.net
//  Project Home Page: http://excelmvf.sourceforge.net/
//
//  This program is free software; you can redistribute it and/or modify it under
//  the terms of the GNU General Public License as published by the Free Software
//  Foundation; either version 2 of the License, or (at your option) any
//  later version.
//
//  This program is distributed in the hope that it will be useful,
//  but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
//  or FITNESS FOR A PARTICULAR PURPOSE.
//  See the GNU General Public License for more details.
//
//  You should have received a copy of the GNU General Public License along with
//  this program; if not, write to the Free Software Foundation, Inc.,
//  59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
//---------------------------------------------------------------------------

/***********************************************************************
 * Module:  TExcelEventDispatcher.h
 * Author:  Herbert Danler
 * Created: Montag, 14. Juni 2004 12:44:24
 * Modified: Donnerstag, 12. August 2004 10:31:30
 * Purpose: Declaration of the class TExcelEventDispatcher
 * Comment: Diese Klasse ist f�r das Abfangen von Excel Events zust�ndig.
 *    Excel User defined functions k�nnen per Definition NUR EINEN Wert zur�ckgeben. Jeder Versuch, innerhalb eines Formelberechnungsvorganges diese Beschr�nkung zu umgehen, resultiert in COM-Fehlermeldungen.
 *    Um diese Beschr�nkung zu umgehen, muss das nachfolgende Calculate-Event von Excel abgefangen werden. Wenn Excel dieses Event anspringt, sind bereits alle Zellbeschr�nkungen aus der Formelberechnung aufgehoben und man kann Werte auch in mehrere Zellen schreiben.
 ***********************************************************************/

#if !defined(TExcelEventDispatcher_h)
#define TExcelEventDispatcher_h

class TCOMException;

#include <windows.h>
#include <utilcls.h>
#include <system.hpp>
#include "TFuncParams.h"
#include "TComHelper.h"
#include "TRequestController.h"
#include "TDataSet.h"

GUID IID_IExcel10AppEvents =
      {0x00024413,0x000,0x0000,{0xc0,0x00,0x0,0x00,0x00,0x00,0x00,0x46 } };

extern TRequestController requestController;
extern const long VALNOTAVAILABLE;

class TExcelEventDispatcher : public TEventDispatcher<TExcelEventDispatcher,&IID_IExcel10AppEvents>
{
public:
   TExcelEventDispatcher();
   ~TExcelEventDispatcher();
   void Connect(IDispatch * srv);
   void Disconnect(void);
   /* Event routine called every time the Excel Calculate Event is triggered. */
   void __fastcall Calculate(TVariant* params);
   HRESULT InvokeEvent(DISPID id, TVariant* params);
   IDispatch* getPExcelAppIDispatch(void) const;

protected:
private:
   static IDispatch * pExcelAppIDispatch;
   IConnectionPointContainer * pConnPtContainer;
   bool connected;
   static bool deleting;

};


#endif