[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 #7 from Ming Hua <3429171453 at qq.com> ---
(In reply to m.a.riosv from comment #6)
> 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.

The "--" thing is an explicit conversion, though, just like the "1*" is, unless
text variables have a uni-operator "-" that I'm not aware of.

"--" is actually a common way to convert texts to numbers, and is taught in a
lot of "Excel tips and tricks" kind of books.

-- 
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/20190402/3b7db250/attachment.html>