<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - calc:The function SUM() does not produce the same result as the '+' operator" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133588#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - calc:The function SUM() does not produce the same result as the '+' operator" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133588">bug 133588</a> from <a class="email" href="mailto:sebastien.kramm@wanadoo.fr" title="sebastien.kramm@wanadoo.fr">sebastien.kramm@wanadoo.fr</a> <pre>(In reply to m.a.riosv from <a href="show_bug.cgi?id=133588#c11">comment #11</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>