[Libreoffice-bugs] [Bug 124454] Double negation with text in array context behaves like single -

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124454

--- Comment #6 from m.a.riosv <miguelangelrv at libreoffice.org> ---
It is in relation about when LibreOffice does the conversion from text to
numbers.

Automatic conversion doesn't work with arrays because only direct references to
a cell can get the automatic conversion (with GeradF sample)
SUM(B2;B3;B4;B5;B6) works but not SUM(B2:B6), except forcing the conversion
with an expression like @GerardF comments.
Or replacing "--" by "--1*" gets the results.

Please take a look to Eike comment
https://bugs.documentfoundation.org/show_bug.cgi?id=120577#c12

IMO this is not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190401/648fe771/attachment.html>