Menu
▾
▴
Re: [Quantlib-dev] Calc Addin under Linux for QuantLibAddin-1.5.0
|
From: <ja...@fr...> - 2015-08-20 08:33:19
|
Hello Lars, 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) I am testing on this worksheet: QuantLibXL/StandaloneExamples/Credit/RiskyBonds.xls So far only the first too sheets. which I am uploading to https://github.com/japari/quantlib/tree/Calc_linuxmake 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. Best Pepe ----- Original Message ----- > > > > > 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: ja...@fr... > An: "Lars Callenbach" <lar...@gm...> > Cc: qua...@li... > 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 > > > ja...@fr...: > > > > 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 <lar...@gm...> 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 > > Qua...@li... > > https://lists.sourceforge.net/lists/listinfo/quantlib-dev > > |
