https://bugs.documentfoundation.org/show_bug.cgi?id=97587
Bug ID: 97587
Summary: Software interpreter for SUM treats empty cells as
#VALUE!
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
(This bug report is mostly pro forma, in developer-speak, for people familiar
with the code.)
When using the software interpreter for formula groups (and not OpenCL), empty
cells are mishandled by the SUM function as implemented by ArraySumFunctor.
Empty cells are represented in the mpNumericArray as NaN values (without any
payload, i.e. not error codes). These NaN then take part in the summation
(either using SSE2 or plain C++ code), and the NaN propagates to the sum, as it
should. Until then in ScInterpreter::TreatDoubleError() and the
GetDoubleErrorValue() it calls the NaN gets translated into errNoValue, and
displayed as #VALUE!
This bug is not directly related to other serious issues in the software
interpreter, see bug #97369.
--
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
