<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Double negation with text in array context behaves like single -" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124454#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Double negation with text in array context behaves like single -" href="https://bugs.documentfoundation.org/show_bug.cgi?id=124454">bug 124454</a> from <a class="email" href="mailto:3429171453@qq.com" title="Ming Hua <3429171453@qq.com>"> Ming Hua</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=124454#c6">comment #6</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>