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

--- Comment #13 from [email protected] ---
(In reply to m.a.riosv from comment #11)
> It is not a bug

So it's a feature ;-)

>, LibreOffice it's very strict about numbers as text, only
> direct references are treated as numbers, text numbers in ranges a never
> converted.

Thank you for that clarification.

> There are some options in Menu/Tools/Options/LibreOffice Calc/Formula -
> Detailed calculation settings.

Indeed, to have the same behavior, you have to check "treat as 0" in
"conversion from text to numbers" (see attached calc screenshot).

Thanks to all.

-- 
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

Reply via email to