https://bugs.documentfoundation.org/show_bug.cgi?id=59309
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #7 from Eike Rathke <er...@redhat.com> ---
Whether or if and how text is accepted as operands to mathematical operators
entirely depends on the settings under Tools -> Options -> Calc -> Formula,
Detailed Calculation Settings; if you check Custom settings several modes are
available for conversion from text to number. Always #VALUE! is recommended to
spot data errors early, but that's not what some other software does and not
what is used in legacy documents so not the default (yet?) but the awkward
"also locale dependent" instead.. See help
https://help.libreoffice.org/latest/en-GB/text/shared/optionen/detailedcalculation.html
> - '+' and 'SUM' should have same result,
No. By definition SUM, AVERAGE, MAX, MIN, ... and other functions accepting
cell ranges as number sequences *ignore* all text cells.
Not a bug.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
