<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Decimal precision fail in addition" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135103#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Decimal precision fail in addition" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135103">bug 135103</a> from <a class="email" href="mailto:javier.debian.bb.ar@gmail.com" title="Javier <javier.debian.bb.ar@gmail.com>"> Javier</a> <pre>(In reply to Michael Warner from <a href="show_bug.cgi?id=135103#c5">comment #5</a>) > (In reply to Javier from <a href="show_bug.cgi?id=135103#c4">comment #4</a>) > > So, a few points here. > > The first is that I would like to bring to your attention this page: > <a href="https://www.libreoffice.org/community/get-involved/">https://www.libreoffice.org/community/get-involved/</a> > > 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. Thanks a LOT for your time. 3 simples fact about me: -English is not my language; sorry if I'm not clear. -I understand about "friendly community". I'm part of Debian community for more than 15 years (I'm a 55 old grandpa, that learned programming with cards an holes). -The complexity of actual programs are so far than my skills. I just only wanted to mark something. I understand floating point more than you believe, I came from the time that memory and CPU cycles was VERY expensive; everything were made with logarithms. I was using the spreadsheet for simple calculation, no more far than a single precision point number, only 2 decimal. For this reason, it was odd for me. For me, the bug is closed. In my country, we said "known problem, is not problem". Thanks again.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>