[Libreoffice-bugs] [Bug 135103] Decimal precision fail in addition

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Michael Warner <michael.warner.ut+libreoffice at gmail.com> ---
(In reply to Javier from comment #4)

So, a few points here. 

The first is that I would like to bring to your attention this page:
https://www.libreoffice.org/community/get-involved/

Which begins with this:
>  Welcome! LibreOffice is developed by a friendly community,

Statements like :

> If your boss see this, probably he doubt about yours skills.

Are something I might expect on twitter or youtube, but not really in line with
what I would expect from a "friendly community".

Second is:
> 
> The other problem, every conditional must be formated before each
> calculation, like
> 
> =IF( ROUND( (<cell with 31000.99> - <cell with 32000.12>;2) = ROUND( <cell
> with -999.13>;2); "OK"; "FAIL" ) );
> 

I was just talking about formatting for display. Proper rounding in comparisons
of floating points is a whole other topic, also worthy of addressing, but not
something I choose to argue about here.

> That's a very heavy issue, a lot of time, memory, CPU resource, bugs, etc.

Fair enough, and things that we as developers must worry about. But irrelevant
to users who don't know (or care) about the details of floating point
representation in computers and just want the spreadsheet to add up numbers and
show the result the way they learned it in elementary school.

Third point is that you are the person who filed the original bug. I was trying
to help by brainstorming a possible solution to what I thought was the problem
you were reporting. But your response is confusing to me because it seems like
you are arguing against fixing the bug you filed. That doesn't make sense, so I
think there is some context or detail to this whole situation that I am not
aware of or not picking up on here.

-- 
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/20200726/9599aad9/attachment.htm>