[Libreoffice-bugs] [Bug 138595] calc ROUND() precision bug

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #4 from b. <newbie-02 at gmx.de> ---

there is more than one issue here: 

1.) a file to download from an unknown provider is - no good - pls. upload to
'bugs', 'add an attachement', 

2.) a hectic fuzzy video is not a good analysis aid, 

3.) calcs 'round' functions (inc. rounddown, roundup, roundsig) indeed have
some small flaws, @erAck is working on it, see tdf#138220, tdf#138424, and
tdf#138860, 

4.) calcs calculations are not 'decimal safe' in themself, sometimes small
inaccuracies occur, sometimes they add up, sometimes they have catastrophic
blow-up's, sometimes they cause 'borderline fails', sometimes they become
visible to the user, there are some proposals for enhancement, wait if / what
will come, 

5.) users should be aware of 4.), there are some aids for correct work despite
limited precision, mainly 'round' and 'precision as shown', 

(that the original decision for 'IEEE floats' was made regarding 'performance',
and that all the benefit is lost in all this rounding users have to care for,
and doubled lost in the time they loose investigating wrong results and
'learning floating point math' is ... suboptimal), 

6.) users also have to be aware that the results shown or printed by calc are
mostly not! the values calc calculates with, but something rough 'prettyfied'
for human acceptance, e.g. most numbers are shrinked to the size of the cell,
all are limited to 15 decimal digits, if applied to the format given by the
user ... but they contain additional digits, thus 'exactly 0,50000~' may be
'0,4999~7' where the user needs special skills to access the hidden digits, 

7.) if there is additional fail in the OP's case we'd like to investigate
further acc. additional explanation and the file, pls. provide and upload, 

setting 'needinfo',

-- 
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/20201201/1ace53f6/attachment-0001.htm>