opinions on additional calc functions

tino ttk448 at gmail.com
Thu Nov 29 10:32:26 PST 2012

> I suggest to open a new directory under scaddins/source, e.g.
> scaddins/source/pricing (or scaddins/source/financial if you plan to add
> other functionality than pricing) and create a new Add-In, for a simple
> approach how to create an Add-In see scaddins/source/datefunc

Ok, will do. I've already submitted a patch which placed everything
under scaddins/source/analysis (the one where you pointed out the
error with commit-msg). Do I need to delete this patch or can I just
leave it on gerrit?

> Btw, if Gnumeric already has them, how does it write them to ODF? We
> should do the same for interoperability.

Within content.xml it writes something like

 <table:... table:formula="of:=[.E$9]*ORG.GNUMERIC.OPT_BS([.E$8];...

> > As for parameters they are mainly of double type but some are of enum
> > type. The enums could be mapped to integers but I've a slight
> > preference for STRING inputs but not sure how 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.
> Constant string arguments to functions MUST NOT be localized. I'd rather
> use integers there, so no one can complain about unlocalized terms.
> Which also eliminates the need of cascaded if(){}else if(){}else if(){}
> ... chains with slow string comparisons and use switch case statements
> instead.

What I like about the char/string inputs is that they are descriptive.
Integers are much less intuitive to the user. Gnumeric currently
implements "p"/"c" inputs but they are strongly opposed to "delta",
"gamma", etc and move them into the function names, e.g.
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

More information about the LibreOffice mailing list