Hi Winfried,
On Monday, 2015-02-09 20:49:45 +0100, Eike Rathke wrote:
> We have something similar with formula::svEmptyCell, my rough guess now
> is it should be enough to treat svMissing the same as svEmptyCell in
> comparisons (ScInterpreter::Compare() and ScInterpreter::CompareMat()),
> instea
Hi Winfried,
On Thursday, 2015-02-05 12:44:56 +0100, Winfried Donkers wrote:
> >> and =IFERROR(1/0;) returns an empty cell, not an error message.
>
> >This is correct and voids my earlier proposal to propagate the ocMissing
> >token through in the final result. Actually we need to pop an ocMiss
Hi Eike,
>> and =IFERROR(1/0;) returns an empty cell, not an error message.
>This is correct and voids my earlier proposal to propagate the ocMissing token
>through in the final result. Actually we need to pop an ocMissing and push an
>ScEmptyCellToken in such case.
(To make it clear for me, =
Hi Winfried,
On Monday, 2015-02-02 13:08:54 +0100, Winfried Donkers wrote:
> >> With IFERROR and IFNA these situation should return an empty value to be
> >> compatible with Excel.
> >AFAIK also Excel does not allow a null argument for IFERROR() second
> >parameter, but I'm not sure, I'd have t
Hi Eike,
>> With IFERROR and IFNA these situation should return an empty value to be
>> compatible with Excel.
>AFAIK also Excel does not allow a null argument for IFERROR() second
>parameter, but I'm not sure, I'd have to check.
Excel replaces an empty argument with an empty value, that is to
Hi Winfried,
On Thursday, 2015-01-29 10:15:59 +0100, Winfried Donkers wrote:
> 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
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.
