help asked for Calc jump function with empty arguments

Winfried Donkers W.Donkers at dci-electronics.nl
Thu Jan 29 01:15:59 PST 2015


Hi,

I am working on bug 88576, regarding IFERROR and IFNA not giving expected results when not all mandatory arguments are given.
On checking their behaviour in various cases, I discovered that IFERROR, IFNA and IF do not handle empty arguments as they should be.
With empty argument I mean e.g. -IFERROR(something;) of IF(statement;;argument).
With IFERROR and IFNA these situation should return an empty value to be compatible with Excel.
With IF, the behaviour is described in ODFF1.2.

My question is, where should this behaviour best be put in the code?
In class FormulaCompiler, e.g. in FormulaCompiler::Factor(), in ScInterpreter::Interpret(), in the functions themselves (ScInterpreter::ScIf() and ScInterpreter::ScIfError() or somewhere else?
And as these functions are jump functions, how best to access/modify the stack or FormulaToken?

Winfried

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20150129/0e474b33/attachment.html>


More information about the LibreOffice mailing list