Calc HYPGEOMDIST: conditionally changing function opcode when saving to Excel format

Winfried Donkers W.Donkers at dci-electronics.nl
Wed Oct 5 10:28:04 UTC 2016


Hi Eike,

> > -save in Excel as HYPGEOMDIST in case of 4 arguments and HYPGEOM.DIST in
> case of 5 arguments.
> >
> 
> I think you have this in mind:
> formula/source/core/api/token.cxx
> MissingConventionOOXML::isRewriteNeeded()
> FormulaTokenArray::RewriteMissing()
> 

Thanks, that is the spot to change the function opcode.
Now I hit the second barrier:
ODFF allows 4 arguments, but Excel needs 5, so when saving to OOXML, I need to add an argument when that is not given.
I have done that before, somewhere, but predictably I forgot where.

Do you have a hint available here too? ;-)

Winfried



More information about the LibreOffice mailing list