QuantLib › quantlib-users

Building and Installing the Libreoffice Addin

Classic

List

Threaded

7 messages Options

Ali Hassani-2

Building and Installing the Libreoffice Addin

Hello,

I am trying to build and install the Quantlib Addin for Libreoffice according
to:
http://quantlib.org/quantlibaddin/build_calc.html

Any help in using idlc, regmerge, cppumaker, compiling and installing would be
very much appreciated.

Regards,

Ali Hassani

--
Ali Hassani
Advisor to the CEO
Public Markets, Portfolio Management, and Risk
National Investment Corporation of National Bank of Kazakhstan
Office: +7 727 244 9407 | Mobile: +7 700 521 9312 | Email: [hidden email]
181 Kunayev street | Almaty | 050010 | Kazakhstan
------------------------------------------------------------------------------
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

Eric Ehlers-3

Re: Building and Installing the Libreoffice Addin

Hi Ali,

As it mentions at that page, the documentation there is for an old
build. A new build was provided in the 1.6 release and that has not
yet been documented. I will ping the author to ask if he can help. In
the meantime I suggest you download the 1.6 release files (if you have
not already), I would think it should be possible to work out the build
by looking at the make files...

Kind Regards,
Eric

On Fri, 20 Nov 2015 08:13:31 +0000
Ali Hassani <[hidden email]> wrote:

> Hello,
>
> I am trying to build and install the Quantlib Addin for Libreoffice
> according to:
> http://quantlib.org/quantlibaddin/build_calc.html
>
> Any help in using idlc, regmerge, cppumaker, compiling and installing
> would be very much appreciated.
>
> Regards,
>
> Ali Hassani
>

------------------------------------------------------------------------------
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

Eric Ehlers-3

Re: Building and Installing the Libreoffice Addin

Hi Ali,

Some additional documentation for the build has been provided, here is
the link:

https://github.com/eehlers/quantlib/blob/v1.7.x/QuantLibAddin/Addins/Calc/HOWTO.TXT

This will be included in the 1.7 release.

Kind Regards,
Eric

On Sat, 21 Nov 2015 19:18:56 +0200
Eric Ehlers <[hidden email]> wrote:

> Hi Ali,
>
> As it mentions at that page, the documentation there is for an old
> build. A new build was provided in the 1.6 release and that has not
> yet been documented. I will ping the author to ask if he can help.
> In the meantime I suggest you download the 1.6 release files (if you
> have not already), I would think it should be possible to work out
> the build by looking at the make files...
>
> Kind Regards,
> Eric
>
> On Fri, 20 Nov 2015 08:13:31 +0000
> Ali Hassani <[hidden email]> wrote:
>
> > Hello,
> >
> > I am trying to build and install the Quantlib Addin for Libreoffice
> > according to:
> > http://quantlib.org/quantlibaddin/build_calc.html
> >
> > Any help in using idlc, regmerge, cppumaker, compiling and
> > installing would be very much appreciated.
> >
> > Regards,
> >
> > Ali Hassani
> >
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> QuantLib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

Ali Hassani-2

Re: Building and Installing the Libreoffice Addin

Hello Eric,

Thank you for your help. When you said this will be included in the 1.7 release did you mean that these instructions will not work using version 1.6?

I tried following your instructions for version 1.6 and got the following error:

gcc -c -fpic -fvisibility=hidden -O -I. -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc -I/home/ali/libreoffice5.0_sdk/LINUX
example.out/inc/examples -I/usr/lib/libreoffice/sdk/include -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc/CalcAddinCpp -I/
usr/lib -I/usr/lib -I/usr/lib -I/usr/lib -I -DUNX -DGCC -DLINUX -DCPPU_ENV=gcc3 -DHAVE_GCC_VISIBILITY_FEATURE -o/home/ali/libreo
ffice5.0_sdk/LINUXexample.out/slo/CalcAddinCpp/qladdin.o qladdin.cpp
qladdin.cpp:180:5: error: expected initializer before ‘SAL_THROW’
    SAL_THROW( () ) {
    ^
qladdin.cpp:185:7: error: ‘create_CalcAddins_impl’ was not declared in this scope
    { create_CalcAddins_impl, getImplementationName_CalcAddins_impl,
      ^
qladdin.cpp: In function ‘void component_getImplementationEnvironment(const sal_Char**, uno_Environment**)’:
qladdin.cpp:196:20: error: ‘CPPU_CURRENT_LANGUAGE_BINDING_NAME’ was not declared in this scope
  *ppEnvTypeName = CPPU_CURRENT_LANGUAGE_BINDING_NAME;
                   ^
Makefile.oo:226: recipe for target '/home/ali/libreoffice5.0_sdk/LINUXexample.out/slo/CalcAddinCpp/qladdin.o' failed
make: *** [/home/ali/libreoffice5.0_sdk/LINUXexample.out/slo/CalcAddinCpp/qladdin.o] Error 1

Regards,

Ali

On Monday, November 23, 2015 10:35:33 AM Eric Ehlers wrote:

> Hi Ali,

> Some additional documentation for the build has been provided, here is

> the link:

> https://github.com/eehlers/quantlib/blob/v1.7.x/QuantLibAddin/Addins/Calc/HO

> WTO.TXT

> This will be included in the 1.7 release.

> Kind Regards,

> Eric

> On Sat, 21 Nov 2015 19:18:56 +0200

> Eric Ehlers <[hidden email]> wrote:

> > Hi Ali,

> >

> > As it mentions at that page, the documentation there is for an old

> > build. A new build was provided in the 1.6 release and that has not

> > yet been documented. I will ping the author to ask if he can help.

> > In the meantime I suggest you download the 1.6 release files (if you

> > have not already), I would think it should be possible to work out

> > the build by looking at the make files...

> >

> > Kind Regards,

> > Eric

> >

> > On Fri, 20 Nov 2015 08:13:31 +0000

> >

> > Ali Hassani <[hidden email]> wrote:

> > > Hello,

> > >

> > > I am trying to build and install the Quantlib Addin for Libreoffice

> > > according to:

> > > http://quantlib.org/quantlibaddin/build_calc.html

> > >

> > > Any help in using idlc, regmerge, cppumaker, compiling and

> > > installing would be very much appreciated.

> > >

> > > Regards,

> > >

> > > Ali Hassani

> >

> > --------------------------------------------------------------------------

> > ---- _______________________________________________

> > QuantLib-users mailing list

> > [hidden email]

> > https://lists.sourceforge.net/lists/listinfo/quantlib-users

Ali Hassani

Advisor to the CEO

Public Markets, Portfolio Management, and Risk

National Investment Corporation of National Bank of Kazakhstan

Office: +7 727 244 9407 | Mobile: +7 700 521 9312 | Email: [hidden email]

181 Kunayev street | Almaty | 050010 | Kazakhstan

Eric Ehlers-3

Re: Building and Installing the Libreoffice Addin

Hi Ali,

> I tried following your instructions for version 1.6 and got the
> following error:
>
> gcc -c -fpic -fvisibility=hidden -O -I.
> -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc
> -I/home/ali/libreoffice5.0_sdk/LINUX example.out/inc/examples
> -I/usr/lib/libreoffice/sdk/include
> -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc/CalcAddinCpp -I/
> usr/lib -I/usr/lib -I/usr/lib -I/usr/lib -I -DUNX -DGCC -DLINUX
> -DCPPU_ENV=gcc3 -DHAVE_GCC_VISIBILITY_FEATURE -o/home/ali/libreo
> ffice5.0_sdk/LINUXexample.out/slo/CalcAddinCpp/qladdin.o qladdin.cpp
> qladdin.cpp:180:5: error: expected initializer before ‘SAL_THROW’
> SAL_THROW( () ) { ^ qladdin.cpp:185:7: error:
> ‘create_CalcAddins_impl’ was not declared in this scope

Please apply this patch to your copy of the source code:

https://github.com/eehlers/quantlib/commit/5854604095a026ebde81b5ac1f2b3517b2dfcf2c

> Thank you for your help. When you said this will be included in the
> 1.7 release did you mean that these instructions will not work using
> version 1.6?

No, that is not what I meant. What I meant is that that documentation
will be included in the 1.7 release, so that next time it will not be
necessary to email us and ask for it :)

Very little has changed between the 1.6 and 1.7 builds and those
instructions apply to both. Version 1.6 was built against LibreOffice
version 4.4. The error that you are getting occurs because you are
building against LibreOffice version 5.0, hopefully the above patch
will fix that.

Also a correction was just made to the documentation, please reload the
file from the same link that I gave you before:

https://github.com/eehlers/quantlib/blob/v1.7.x/QuantLibAddin/Addins/Calc/HOWTO.TXT

Kind Regards,
Eric

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

Ali Hassani-2

Re: Building and Installing the Libreoffice Addin

Thank you Eric, I have compiled it and the functions show up in Libreoffice 5.0

However, I'm having an issue using the example spreadsheets.

For example in InterestRateDerivatives.ods:

It seems that QLSETTINGSEVALUATIONDATE() returns today's date regardless of what
is inputted into QLSETTINGSSETEVALUATIONDATE()

Regards,

Ali
________________________________________
From: Eric Ehlers <[hidden email]>
Sent: Tuesday, November 24, 2015 3:02 PM
To: Ali Hassani
Cc: [hidden email]
Subject: Re: [Quantlib-users] Building and Installing the Libreoffice Addin

Hi Ali,

Eric Ehlers-3

Re: Building and Installing the Libreoffice Addin

Hi Ali,

I am very glad to hear that the build completed successfully.

I'm not sure that I can help you with the run time problem.

Are you sure that the inputs to QLSETTINGSSETEVALUATIONDATE() are
valid, and that the function completed successfully?

I would advise you to attach the gdb debugger to the LibreOffice
process.

Kind Regards,
Eric

On Tue, 24 Nov 2015 18:39:27 +0000
Ali Hassani <[hidden email]> wrote:

> Thank you Eric, I have compiled it and the functions show up in
> Libreoffice 5.0
>
> However, I'm having an issue using the example spreadsheets.
>
> For example in InterestRateDerivatives.ods:
>
> It seems that QLSETTINGSEVALUATIONDATE() returns today's date
> regardless of what is inputted into QLSETTINGSSETEVALUATIONDATE()
>
> Regards,
>
> Ali
> ________________________________________
> From: Eric Ehlers <[hidden email]>
> Sent: Tuesday, November 24, 2015 3:02 PM
> To: Ali Hassani
> Cc: [hidden email]
> Subject: Re: [Quantlib-users] Building and Installing the Libreoffice
> Addin
>
> Hi Ali,
>
> > I tried following your instructions for version 1.6 and got the
> > following error:
> >
> > gcc -c -fpic -fvisibility=hidden -O -I.
> > -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc
> > -I/home/ali/libreoffice5.0_sdk/LINUX example.out/inc/examples
> > -I/usr/lib/libreoffice/sdk/include
> > -I/home/ali/libreoffice5.0_sdk/LINUXexample.out/inc/CalcAddinCpp -I/
> > usr/lib -I/usr/lib -I/usr/lib -I/usr/lib -I -DUNX -DGCC -DLINUX
> > -DCPPU_ENV=gcc3 -DHAVE_GCC_VISIBILITY_FEATURE -o/home/ali/libreo
> > ffice5.0_sdk/LINUXexample.out/slo/CalcAddinCpp/qladdin.o qladdin.cpp
> > qladdin.cpp:180:5: error: expected initializer before ‘SAL_THROW’
> > SAL_THROW( () ) { ^ qladdin.cpp:185:7: error:
> > ‘create_CalcAddins_impl’ was not declared in this scope
>
> Please apply this patch to your copy of the source code:
>
> https://github.com/eehlers/quantlib/commit/5854604095a026ebde81b5ac1f2b3517b2dfcf2c
>
> > Thank you for your help. When you said this will be included in the
> > 1.7 release did you mean that these instructions will not work using
> > version 1.6?
>
> No, that is not what I meant. What I meant is that that documentation
> will be included in the 1.7 release, so that next time it will not be
> necessary to email us and ask for it :)
>
> Very little has changed between the 1.6 and 1.7 builds and those
> instructions apply to both. Version 1.6 was built against LibreOffice
> version 4.4. The error that you are getting occurs because you are
> building against LibreOffice version 5.0, hopefully the above patch
> will fix that.
>
> Also a correction was just made to the documentation, please reload
> the file from the same link that I gave you before:
>
> https://github.com/eehlers/quantlib/blob/v1.7.x/QuantLibAddin/Addins/Calc/HOWTO.TXT
>
> Kind Regards,
> Eric