how to cope with Calc functions that have an optional argument, which is mandatory in Excel?

Winfried Donkers W.Donkers at dci-electronics.nl
Fri Jun 27 03:46:46 PDT 2014


Hi,

>Currently I am looking at fdo#40835, which mentions the problem that Excel function F.DIST has 4 required arguments and that ODF1.2 function FDIST has the same arguments, only the last argument is optional.

>Is there code that handles my case? Otherwise I may have to introduce an extra function to Calc, just because of this optional/required argument difference.

I found core/sc/source/filter/excel/xeformula.cxx that seems to do what I need in XclExpFmlaCompImpl::AppendTrailingParam(),
and /core/formula/source/core/api/token.cxx with FormulaMissingContext::AddMoreArgs().
That doesn't seem to work as it should, at least for ocGammaDist.

So I've got more digging to do.
Anyone familiar with these files and its code and willing to provide me with background information is welcome, though.

Winfried


More information about the LibreOffice mailing list