[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 #7 from Javier <javier.debian.bb.ar at gmail.com> ---
(In reply to Michael Warner from comment #5)
> (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.

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.

-- 
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/d64ce9c0/attachment.htm>