[Libreoffice-bugs] [Bug 59309] One cell containing text in a string of addends causes calc to return #VALUE!.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=59309

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #7 from Eike Rathke <erack at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200923/9058e2bc/attachment.htm>