https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #6 from m.a.riosv <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs