https://bugs.documentfoundation.org/show_bug.cgi?id=65182
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] Resolution|--- |WORKSFORME --- Comment #8 from Jean-Baptiste Faure <[email protected]> --- The inconsistency has been solved in LibreOffice 4.3. Indeed you can now choose how to handle text representing numbers in formulas. If you choose treat as zero, both formulas give the same result. To choose how text is converted to number: menu Tools > Options > LibreOffice Calc > Formula > Detailed calculation settings > Custom Closing as WorksForMe. If you think that SUM() should comply with this setting, please file a new bug report. If you think that the documentation of the SUM function should tell that it does not comply with this setting, please file a bug report proposing a short text to be added to the help. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
