[Libreoffice-bugs] [Bug 126970] New: Function "SUM()" work doesn't correct if final result is zerro.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126970
           Summary: Function "SUM()" work doesn't correct if final result
                    is zerro.
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: oleksandr.ovonord at gmail.com

Description:
If use function "SUM()" and some fields have negavice values and final result
will be zerro, then field result have "-424154+E12" or similar values.

Format field where vormula is used: Category Digital, Format Standard.

Steps to Reproduce:
1.Put "-46,4" in field j8
2.Put "4904,28" in field j9
3.Put "-4857,88" in field j10
4.Put formula in field j12 "SUM(J8:J10)"


Actual Results:
3,62376795237651E-13


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: uk
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

this bug reproduce in random combinations nuber but not all

reproduced:
-20,7
40018
-39997,3

Not reproduced:
-822,39
-44,38
866,77

***
Версія: 6.0.7.3
Код збірки: 1:6.0.7-0ubuntu0.18.04.8
Потоки ЦП: 2; ОС: Linux 4.15; Вимальовування ІК: усталено; VCL: kde4; 
Локаль: uk-UA (uk_UA.UTF-8); Calc: group
***

-- 
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/20190816/acccc4f2/attachment.html>