https://bugs.documentfoundation.org/show_bug.cgi?id=155239
--- Comment #2 from ady <adylo811...@gmail.com> ---
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 new.
Calc supports the double unary just fine for traditional "legacy"
pre-dynamic-era functions, such as SUMPRODUCT().
With dynamic functions, Excel now can have functions such as SUM() supporting
"array" arguments as a non-array function, which were not supported in the same
way in the past, when you needed to introduce them as ("legacy") array formulas
with CSE.
This is why it would seem that using
=SUM(--F1:F4)
...is something that Calc does not support. Well, it is not really because of
the double unary (aka double negative), but because of the new so-called
"dynamic" arrays, functions and formulas in Excel.
I guess that, in some sense, this is one more RFE for Calc to support "dynamic"
array functions.
--
You are receiving this mail because:
You are the assignee for the bug.
