Hi,in order to write pricers portables between Windows and Linux, I am thinking of using OpenOffice Calc worksheets.And I need to write c++ based addins for interpolations, closed form, etc...There are some explanations on the OpenOffice wiki, but it is not readily applicable to math and finance.Moreover, as far as I have seen, it is quite tricky to install and build.Does anyone know how to do this? Or even better, does anyone have templates? (like visual studio solutions, makefiles, easy examples, etc...).s.g.

I think quantlibXL does calc as well as EXCEL. i've never tried it however. One of the many nice to haves for xlw that have never happened would be the ability do calc.

Yes, QuantLib also has an implementation of addins for open Calc, and it even has a Visual Studio solution.I tried it. Unfortunately, the QuantLib msvc solution is version vc7, and my msvc is vc8. It tried to convert from vc7 to vc8, but that failed. Then the building failed. I could try to create a vc8 solution by hand by looking at their vc7 solution. And maybe from that I can look around and guess how they do the building, probably with some NMake file, like in XLW. If there is noother way to find a working template out there, I may have no other choice.XLW is indeed very convenient. I am not an IT expert, but I could get it working without much trouble, and itis quite user friendly. I wish somebody could do the same thing with OpenOffice Calc. I like OpenOffice Calc interface and the concept of free and open source projects. It makes good looking graphs, can convert them easily to eps format for including in Latex, it's free, it's portable to UNIX, etc... It has a lot of advantages over Excel, but if the OpenOffice guys want to be taken seriously by professionals, especially in the Finance industry, I think they should make it more easily usable. Just installing the SDK for C++ addins is already a lot of trouble, if you're not lucky. And having no XLW-like project to make addins is quite discouraging. If it does not alreadyexist, and if somebody reads this message and wants to give it a try, I'd be happy to join the effort.

Hello,QuoteOriginally posted by: sebgurYes, QuantLib also has an implementation of addins for open Calc, and it even has a Visual Studio solution.I tried it. Unfortunately, the QuantLib msvc solution is version vc7, and my msvc is vc8. It tried to convert from vc7 to vc8, but that failed. Then the building failed.You have to build your Calc addin with the same version of the compiler that was used to build your copy of Calc:http://wiki.services.openoffice.org/wik ... gineersThe last time the QuantLibAddin Calc Windows build was updated, Visual C++ 2003 (VC7) was current, but now as you can see from the link above Calc is on Visual C++ 2008 (VC9).In the latest release of QuantLibAddin, 1.0.1, does not include the Visual C++ build. The autoconf (Mac and Linux) build is provided, and this has been migrated to the new Calc addin architecture, whereas previous releases of QuantLibAddin used the legacy Calc addin architecture.Regards,Eric

Just installed OpenOffice, very easy to use as well.Is this API the best one?http://www.openoffice.org/api/ And?Calc Mathematica 2-way link

As a starting guide, you can give a try to the (quite high-level) example code given at :http://moutou.pagesperso-orange.fr/MyUN ... 14.htmlThe tutorial starts with :"14 Add-in : adding OooCalc functionsOur purpose is to extend OpenOffice.org Calc with C++ code. Such extensions are called Add-ins and are easy to implement. Again helpers are our friend and will allow us to simplify the code. "

Quote(quite high-level) example code I agree It is certainly no 'how to' doc!I think 'technical writing' should be part of every university course. how to C# addin in Excel

Quotethe QuantLib msvc solution is version vc7are you talking about the version installed on your machine?can't you update it?