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

--- Comment #1 from ady <[email protected]> ---
I tested this in:

Version: 7.4.5.1 (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL

(Newer version and different OS)

While the result of SUM() and AVERAGE() functions for this set of values is 0
(zero) in the version I tested this, it still shows non-zero values in the
bottom-right area in the status bar.

So:

1. @Gustavo, it might be worth trying a newer version of LO, if it is possible.

2. As of LO 7.4.5, there could be some potential inconsistency, at least from
the POV of common users, between the results of functions used within cells and
those used in the quick calculations area presented in the status bar. I'm not
saying it needs to be changed, but it has to be said/acknowledged (and perhaps
documented, if it is not already? IDK).

3. FWIW see https://wiki.documentfoundation.org/Faq/Calc/Accuracy

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to