https://bugs.documentfoundation.org/show_bug.cgi?id=98344
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #7 from Eike Rathke <[email protected]> --- This is not funky behavior, the SUM function as many other functions that take range parameters for numeric calculations processes range arguments as number sequences, ignoring all text values. This is also defined in OpenFormula (ODFF) and also what Excel does. The result of A1+A2 actually depends on the setting of "Conversion from text to numbers", under Tools->Options->Calc->Formulas "Detailed Calculation Settings", choose Custom, Details. I recommend the "Generate #VALUE! error" setting so all numeric calculation attempts with text instead of numbers generates an error to more easily detect odd cell content. -- 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
