https://bugs.documentfoundation.org/show_bug.cgi?id=109189
b. <[email protected]> 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. <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
