https://bugs.documentfoundation.org/show_bug.cgi?id=155239
--- Comment #5 from ady ---
(In reply to TBeholder from comment #4)
> > =SUM(--(F1:F4)).
> It's not an array formula
That's the point. For versions of Excel that support dynamic arrays, that _is_
an array; not in the traditional
https://bugs.documentfoundation.org/show_bug.cgi?id=155239
TBeholder changed:
What|Removed |Added
CC||turbobehol...@mail.ru
--- Comment
https://bugs.documentfoundation.org/show_bug.cgi?id=155239
--- Comment #3 from ady ---
(In reply to ady from comment #2)
Sorry, typo:
> This is why it would seem that using
> =SUM(--F1:F4)
That should be =SUM(--(F1:F4)).
--
You are receiving this mail because:
You are the assignee for the
https://bugs.documentfoundation.org/show_bug.cgi?id=155239
--- Comment #2 from ady ---
The info here is slightly inaccurate.
Excel uses the double unary as one of the ways to coerce boolean TRUE/FALSE
values into numeric values. Nothing new.
Calc doesn't need to coerce boolean values. Nothing
https://bugs.documentfoundation.org/show_bug.cgi?id=155239
Eike Rathke changed:
What|Removed |Added
Version|7.4.6.2 release |Inherited From OOo