[Libreoffice-commits] core.git: Changes to 'refs/changes/95/1195/1'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] core.git: Changes to 'refs/changes/47/1447/1'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] core.git: Changes to 'refs/changes/32/1232/1'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] core.git: Changes to 'refs/changes/32/1232/4'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] core.git: Changes to 'refs/changes/32/1232/3'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

[Libreoffice-commits] core.git: Changes to 'refs/changes/32/1232/2'

___ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Re: additional calc functions produce warnings

> Now I can see them with that obvious tip. Resource > RID_PRICING_DEFFUNCTION_NAME is empty in > scaddins/source/pricing/pricing.src Ah yes, thanks for that. I left that empty because I assumed this was optional and I didn't understand the point of it. It seemed something to do with translating f

Re: additional calc functions produce warnings

> AFAIR you recently added the pricing functions. When running calc to test my > code changes, I get lots of: > warn:legacy.osl:11918:1:/home/w.donkers/git/libo/tools/source/rc/resmgr.cxx:773: > > file:///home/w.donkers/git/libo/solver/unxlngi6/installation/opt/program/../program/resource/pricin

Re: license statement

Hi Markus, Many thanks for the commits and sorting out the warnings. Also: All of my past & future contributions to LibreOffice may be licensed under the MPL/LGPLv3+ dual license. Cheers, Tino ___ LibreOffice mailing list LibreOf

Re: random number generators for calc

> > Small problems: > > - compiler warnings from within boost > > We need to patch them out otherwise the Werror build will fail. It > seems that these warnings are also fixed upstream. This really confuses me. The warnings I'm getting are of the form ...boost/random/binomial_distribution.hpp:

Re: random number generators for calc

842a552aca885c Mon Sep 17 00:00:00 2001 From: tino Date: Thu, 6 Dec 2012 14:05:11 + Subject: [PATCH] fdo#33365 added wrapper for boost random, use that in RAND() Change-Id: Iafc524d12c76423f74dc16b42595e52fbc5a1e54 --- sc/Library_sc.mk | 1 + sc/source/core/data/global.

Re: opinions on additional calc functions

> > I've also got an example/test spreadsheet, but didn't quite know where > > to put it. > > The right solution is to extend the existing function (import) tests in > sc/qa/unit/subsequent_filters-test.cxx with the test file being in > sc/qa/unit/data/ods/functions.ods Ok, this is something I'll

Re: [PUSHED] adding calc add-in for option pricing

27;ve attached a patch to sort out the internal UNO variable/function naming issue. Cheers, Tino >From 4e61de11fb73973519d409c39ec66c84d3316f9b Mon Sep 17 00:00:00 2001 From: tino Date: Tue, 4 Dec 2012 17:26:52 + Subject: [PATCH] changed function names and variables to conform with U

Re: [PUSHED] adding calc add-in for option pricing

> >Do you mean function names like getOpt_barrier() or input variables as > >put_call or both? If it's the function names then would > >getOpt_barrier() --> getOptBarrier() be ok? > > Ah, right, some parameter names are affected, too. So yes, please > replace all identifiers containing underscore

Re: [PUSHED] adding calc add-in for option pricing

> Seeing this commit, I note that XPricingFunctions has method > identifiers starting with a lower case letter and containing > underscores. Such identifiers are reserved to the UNO > implementation. (See > . There Sorry, UNO has been to

Re: random number generators for calc

> > What about implementation in random.cxx and creating random.hxx so all > > the random stuff is in one place? > > Why do you want this abstraction? Following KISS I would just start > implementing the functions in ScInterpreter and extract commonly used > parts into an own method. If at some po

Re: opinions on additional calc functions

> > but I must be missing something? > > you are missing the wonder that is scp2 :-/ > > that is the thing which defines which files end up where in the > installation; if you don't add it there it won't be installed. Haha, brilliant thanks, that helped a lot! I've submitted my changes via gerr

[PATCH] adding calc add-in for option pricing

: newchange Gerrit-Change-Id: Ica4b621a7ae7e5ab447192ae3fe7b8911295bef2 Gerrit-PatchSet: 1 Gerrit-Project: core Gerrit-Branch: master Gerrit-Owner: Tino ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo

Re: random number generators for calc

implementation in random.cxx and creating random.hxx so all the random stuff is in one place? Tino ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: random number generators for calc

> the header is sal/inc/rtl/random.h (which is apparently a C interface). Exactly, the C++ interface is missing. Also, the source doesn't have any comments to say what algorithm is implemented etc. Do you know? > but why do we need a wrapper around boost in sal? i mean i haven't > looked at the

Re: random number generators for calc

I've had a look at what Gnumeric offers, and they've done a big job on random number generation. Comparing with what is available in boost I've separated the list into rand functions which could be quickly implemented using boost and those which can't (and would require more intelligence to impleme

added option pricing functions to scaddins

Tino has abandoned this change. Change subject: added option pricing functions to scaddins .. Patch Set 1: Abandoned new suggestion is to add the new pricing function under a separate add-in -- To view, visit https

Re: opinions on additional calc functions

ile string arguments can't. No, that's right, but that would explode the number of functions unnecessarily. If string inputs are a big problem then I'd rather go for char inputs (or even int as a last resort). Cheers, Tino ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: opinions on additional calc functions

opt_bs_delta(), opt_bs_gamma() and so have 7 instead of one function (something I won't repeat). If there are no strong objections, I'd prefer to go with char/string inputs or anything which is more intuitive for the user? Thanks, Tino ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: random number generators for calc

sqrt(-2.0*log(RAND())) * cos(2.0*M_PI*RAND()) Other distributions can be more complicated ... Tino ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice

[PATCH] added option pricing functions to scaddins

://gerrit.libreoffice.org/1195 To unsubscribe, visit https://gerrit.libreoffice.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I942fa08f9bf0e855eebd6293ad996b45ebfade57 Gerrit-PatchSet: 1 Gerrit-Project: core Gerrit-Branch: master Gerrit-Owner: Tino

Re: random number generators for calc

t's) which is then transformed to get RAND() and RANDBETWEEN(i,j). Yet both are simple uniform distributions but the user might need Normal distributed random variables and then RAND() is of little use. So a function like RANDNORMAL() which generates N(0,1) (still using boost::mt19937) rand

Re: random number generators for calc

rns out to be slightly faster than rand(). What is your opinion on implementing generators for other distributions like normal and all the ones listed under statistics (which calculate densities but don't generate)? With boost this is simple so just a matter of extending the UNO interface. Cheer

Re: random number generators for calc

on (2^24) which is worse than glibc's rand(). Cheers, Tino ./core/sal/rtl/source/random.cxx #define RTL_RANDOM_RNG(x, y, z) \ { \ (x) = 170 * ((x) % 178) - 63 * ((x) / 178); \ if ((x) < 0) (x) += 30328L; \ \ (y) = 171 * ((y

random number generators for calc

orward. We could also replace rand()/(RAND_MAX+1) in RAND() with a boost random generator (rand() under windows can be extremely poorly implemented and only have 2^16 different values or so). This would also solve this windows only bug: https://bugs.freedesktop.org/show_bug.cgi?id=33365 Opinions? Ch

opinions on additional calc functions

that is viewed here with regard to localisation? E.g. I'm currently using "p" to specify a put and "c" for a call, and "i" for in, "o" for out, and "delta" for delta (d/dS), "gamma" for gamma (d^2/dS^2), etc. I've attached a code snipped

[Libreoffice] Proofing API Performance

pe" incurs 50x more calls than needed. So if I missed some obvious option toggle or existing solution, I'd love to know. -- Tino Didriksen ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice