[Libreoffice-bugs] [Bug 109189] calc: calculation: statusbar, auto-sum irrit. results, different from sheet reg. rounding and ordering of operands | was: Statusbar sum and average calculation with decimal values equivalent to zero sometimes shows incorrect negative exponential value

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Statusbar sum and average   |calc: calculation:
                   |calculation with decimal    |statusbar, auto-sum irrit.
                   |values equivalent to zero   |results, different from
                   |sometimes shows incorrect   |sheet reg. rounding and
                   |negative exponential value  |ordering of operands | was:
                   |                            |Statusbar sum and average
                   |                            |calculation with decimal
                   |                            |values equivalent to zero
                   |                            |sometimes shows incorrect
                   |                            |negative exponential value

--- Comment #9 from b. <newbie-02 at gmx.de> ---
the effects are neither limited to 

'decimal values equivalent to zero' 

nor to 

'incorrect negative exponential value' 

changing subject,  

proof: 
 1,797693134862315500E+308
-1,797693134862315500E+308
 3,995840309534720000E+291
summed in a sheet results in 
 0,000000000000000000E+000 (cancellation) while the statusbar shows 
 3,995840309534720000E+291 (different ordering of operands, no cancellation), 
putting the small value above the others changes results between sheet and
statusbar, 

keying 
-2,9937604643020793E+292 in a cell shows 
-2,9937604643020800E+292 (rough rounding), keying 
 2,9937604643020800E+292 in a cell beneath and summing up results in 
 0,0000000000000000E+000 in the sheet, and 
 8,8633114604817800E+276 in the statusbar

-- 
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/20210403/8a34ade2/attachment.htm>