https://bugs.documentfoundation.org/show_bug.cgi?id=98344
--- Comment #8 from kompilainenn <[email protected]> --- (In reply to Eike Rathke from comment #7) > 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. totally agree -- 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
