2008/3/13, Coen <[EMAIL PROTECTED]>: > > Good afternoon, > > I am using version 2.3 of OpenOffice.org. My problem is : > > I'm used to use excel on my laptop. Now i've changed to openoffice. > But i'm a bit limited in my work now. > The problem is that, i used to use excel as a calculation programm, in > wich i have to put on the macro's and the insertions: Analysis Toolpak > and Analysis Toolpak - VBA > Is it possible to use the same options in openoffice calc. > With this on, i can extract information wich is tagged from the first > sheed, from other sheeds. > > I hope you can provide me with the information, so that i can use > openoffice calc in the same way as axcel. > > With best regards, > > Coen de Graaf > P. Nelis & Zoon's > Sales Manager Finland > NL: +31 624130865 > SF: +358 407071232 > > [EMAIL PROTECTED] >
Hello Coen, If you prefer, you can post your questions in Dutch, see the Dutch OpenOffice.org project at http:nl.openoffice.org Analysis Toolpak is an add-on or extension for MSExcel. I don't think it will work 'as is' with OOo Calc. Furthermore, OOo uses another macro language than Excel. You can take a look for alternatives among the extensions and templates for Calc e.g. http://ooop.svn.sourceforge.net/viewvc/ooop/trunk/extras/source/premium/templates/ http://documentation.openoffice.org/Samples_Templates/User/template/index.html http://www.smalldataproblem.org/ooextras/ http://extensions.services.openoffice.org/project http://www.o3spaces.com/ http://www.alfresco.com/ HTH -- Guy using dutch OOo 2.3 m221 on a iMac Intel DualCore Tiger and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches
