http://quantlib.414.s1.nabble.com/Re-Calc-Addin-under-Linux-for-QuantLibAddin-1-5-0-tp16803p16822.html
Most of the differences in making worksheets run I have noticed so far are not too important: some of these might have nothing to do with the code but the way Calc works, some might be my build. I have just started to play with it so it might just be some stupid input I am entering.
-> Objects do not get automatic ids so the ones with an empty id are in error. They have to have overwrite set to true as a result; this is related to not having counters I guess.
-> Default values not assigned? Or at least empty fields need to be there separated by commas.
-> If you open the wsheet and hit F2 on a formula it might give you a "#MACRO?" message. If you go into the Function Wizard or modify an input the same formula would work. Subsequent calls within the cell work ok. F9 does not do the trick either; I am going one by one now.
-> When trying to get a TS object I get an error (tried for default and yield TS) ERROR: qlYieldTSDiscount: empty Handle cannot be dereferenced. This one of course stops everything else.
-> When creating an schedule I get an 'unrecognized type' error: see cell CreditMarket::D38 if I use a function call within the call (for the date in this case)
My LibreOffice: Version: 4.2.8.2 Build ID: 420m0(Build:2 . boost 157 gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04)
On the error messages; fine yes I see the errors. Its just the unrecognised function left. But thats not a big deal.
>
>
>
>
> Hi Pepe,
>
> I have not implemented a counter for objects id's. But I have
> activated "ohObjectSave", "ohObjectLoad" and some logging functions
> from the ObjectHandler (serialization.xml and logging.xml) - it
> works under Linux.
>
> Since the handling of the basic types is defined a lot of functions
> in xml files can be activated/checked. I have not looked for all
> addin functions (that can be activated for Calc) since I want to
> test the activated functions at first. I would like to have some
> sample spreadsheets showing their application. Maybe we can share
> the work of testing and extending the xml files for Calc?
>
>
> One remark concerning OhRangeRetrieveError: I think it is not
> necessary in the current implementation since the return type of
> addin functions is SEQ(SEQ(ANY)) [matrix of any (string, float)
> value]- in the case of exceptions the error message will be returned
> instead of the objectID/calculated results. You should see this in
> the code and in Calc.
>
> Kind regards,
> Lars
>
>
> Gesendet: Mittwoch, 19. August 2015 um 10:07 Uhr
> Von:
[hidden email]
> An: "Lars Callenbach" <
[hidden email]>
> Cc:
[hidden email]
> Betreff: Re: [Quantlib-dev] Calc Addin under Linux for
> QuantLibAddin-1.5.0
> I have started to debug/test worksheets and things sort of work.
> Something that I dont understand; is OH working? Why I can not see
> the instantiation numbering (or whatever you call it) after the
> object name? Do you see this on MacOS?
>
> Best
> Pepe
>
>
> ----- Original Message -----
> > Hello again Lars,
> > Sorry for the blackout; I was struggling with it and had not much
> > to
> > contribute with. But your last branch did help me a lot and save me
> > quite a bit of time an effort. A big thank you.
> >
> > I am building it ok on Linux and running the worksheets. I am
> > providing a pedestrian Makefile for it. I can not do it with
> > Makefile.oo as it is now. The Makefile is very basic but the idea
> > is
> > that eventually both Makefiles merge into a proper am file. It just
> > provides a dynamic linked lib and installs it. Prerequisites on the
> > environment are the same ones you mention.
> >
> > There are a couple of differences. I dont install the way you do
> > (my
> > system needs sudo for that); I use a component file and my manifest
> > file is fixed (this is the only collision I see with your make).
> > Its
> > similar to the standard add-in example in the uno sdk. Also the way
> > I generate from the idl has a few unnecessary dependences, its also
> > taken from the example.
> >
> > I am adding this into
> > github.com/japari/quantlib/tree/Calc_linuxmake
> > This is a branch that I created from the PR you sent to Eric but
> > when I uploaded to GitHub it only lets me PR to Erics fork. Can you
> > take the changes into your branch please? I prefer that rather than
> > issuing a PR to Eric.
> >
> > Is there anyone working on this on Windows?
> >
> > Best
> > Pepe
> >
> > My TODO list (comments on Makefile.linux results)
> > -Useful functions like OHrangeRetrieveError are missing.
> > -At least some functions, if not all, fail when called without all
> > arguments given; i.e. there are no default values taken in.
> > -Error codes as numbers are ugly.
> > -Consider renaming the Add-In service to "QuantLib" ? This might be
> > more tidy when looking for a function in the Calc drop down menu.
> > -Debug the Makefile dependencies; when launching the Makefile with
> > '-j' things go wrong: ...'at times'... theres no ./com/*
> > generation,
> > or too late and as a result the f's are not shown. No complains
> > about missing includes though....
> > -Trim the idl compilation; lots of stuff there not used.
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > > Hi all,
> > >
> > > Pepe, changed index.xml to remove inflation dependencies.
> > > Eric, pushed anotther version without generated files in Calc
> > > directory
> > > - do I have to start another pull request or is the old one still
> > > active
> > > and includes the last changes?
> > >
> > > Best regards,
> > > Lars
> > >
> > > Am Donnerstag, den 16.07.2015, 06:19 +0200 schrieb
> > >
[hidden email]:
> > > > Hi all,
> > > > Lars, I have tried your branch and I the AddIn compilation
> > > > fails
> > > > at
> > > > the inflation bonds registration so it looks like I need the
> > > > xml
> > > > files you mentioned. Can I have a look at them please? Can you
> > > > add
> > > > those to github?
> > > > Thank you.
> > > > Pepe
> > > >
> > > >
> > > > ----- Original Message -----
> > > > > Hi Eric,
> > > > >
> > > > > set up a pull request against 1.6.
> > > > >
> > > > > @Pepe: is something missing or does everything work fine for
> > > > > you
> > > > > (I
> > > > > have
> > > > > written some more xml files for inflation, model calibration
> > > > > etc.
> > > > > which
> > > > > are not included in this pull request)?
> > > > >
> > > > >
> > > > > Best regards,
> > > > > Lars
> > > > >
> > > > >
> > > > > Am Sonntag, den 12.07.2015, 12:57 +0300 schrieb Eric Ehlers:
> > > > > > Hi Lars,
> > > > > >
> > > > > > This is great!
> > > > > >
> > > > > > Would it be possible for you to send me a pull request for
> > > > > > this?
> > > > > > If
> > > > > > you could do it against my v1.6.x branch then I will
> > > > > > include
> > > > > > it
> > > > > > in
> > > > > > the
> > > > > > 1.6 release which I am preparing now. Otherwise if you do
> > > > > > it
> > > > > > against
> > > > > > my master then it will go in to 1.7.
> > > > > >
> > > > > > Kind Regards,
> > > > > > Eric
> > > > > >
> > > > > > On Fri, 10 Jul 2015 19:05:55 +0200
> > > > > > Lars Callenbach <
[hidden email]> wrote:
> > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I have extended the addin code for the LibreOffice calc
> > > > > > > plugin.
> > > > > > > Changes: 1) vetor return values (iteration over
> > > > > > > std::vector
> > > > > > > results)
> > > > > > > 2) return type seqseq(ANY) for all addin functions to
> > > > > > > provide
> > > > > > > addin
> > > > > > > access to exceptions (exception messages will be
> > > > > > > displayed
> > > > > > > in
> > > > > > > cells)
> > > > > > > 3) implementation of default value handling
> > > > > > > (ANY::hasValue()
> > > > > > > function)
> > > > > > > 4) works clean with dynamic libraries (and with static
> > > > > > > linking)
> > > > > > >
> > > > > > > I have changed a lot of XML config files and some python
> > > > > > > files
> > > > > > > for the
> > > > > > > calc addin and I suggest to include my changes in the
> > > > > > > official
> > > > > > > code.
> > > > > > > How shall we proceed to include these changes in the
> > > > > > > official
> > > > > > > version? Who is responsible for the maintenance of the
> > > > > > > calc
> > > > > > > code?
> > > > > > > Can
> > > > > > > I help maintaining the calc code?
> > > > > > >
> > > > > > > The generated code is available under
> > > > > > > "
https://www.callenbach.eu ".
> > > > > > >
> > > > > > >
> > > > > > > Best regards,
> > > > > > > Lars
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
> >
> > ------------------------------------------------------------------------------
> > _______________________________________________
> > QuantLib-dev mailing list
> >
[hidden email]
> >
https://lists.sourceforge.net/lists/listinfo/quantlib-dev> >