[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 ASi changed: What|Removed |Added CC||a...@tlen.pl --- Comment #6 from ASi --- Created attachment 189119 --> https://bugs.documentfoundation.org/attachment.cgi?id=189119&action=edit Visualisation in 7.5.5.2 same in 7.5.5.2 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 --- Comment #5 from ady --- (In reply to m.a.riosv from comment #4) > In Number-General format, it shows 23,4 > changing to a format like 00,0 indeed it shows 23,40001. FWIW, testing with LO Dev 24.2 built 2023-08-22, there is no need to change the cell format. Using the default standard cell format with default column width, it shows 23.4 (or 23,4). By double-clicking the column right-side border in order to auto-expand the column's width, it shows 23.40001 (or 23,40001). Anyway, I am just reporting the behavior I see, just in case. I still tend to think this is about floating-point math, but, as I said in a prior comment, I am guessing. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 m.a.riosv changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |DUPLICATE --- Comment #4 from m.a.riosv --- In Number-General format, it shows 23,4 changing to a format like 00,0 indeed it shows 23,40001. But I think the one it out of the precision. https://wiki.documentfoundation.org/Faq/Calc/Accuracy https://ask.libreoffice.org/t/accuracy-in-libreoffice-calc/83750/2 https://ask.libreoffice.org/t/calc-rounding-general-precision-problem/64358/2 Seems we can consider this one like a duplicate of 128312, please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 128312 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 --- Comment #3 from ady --- (In reply to m.a.riosv from comment #2) > It works fine with > Version: 7.5.7.0.0+ (X86_64) / LibreOffice Community Are you sure? Have you tried expanding the width of the column? My guess is that this behavior is related to floating-point math capabilities, but I'll leave it to others with relevant knowledge of the matter to answer (with a proper reply, rather than a guess). Whether this particular subtraction is supposed to be exact, or with some inaccuracy because of floating-point math, IDK. https://wiki.documentfoundation.org/Faq/Calc/Accuracy -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- It works fine with Version: 7.5.7.0.0+ (X86_64) / LibreOffice Community Build ID: f847a74a2ceffe3938736cb5ee88f81b2160a6b7 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 156858] LibreCalc wrong subtraction of numbers 0, 0000000000001
https://bugs.documentfoundation.org/show_bug.cgi?id=156858 Buovjaga changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #1 from Buovjaga --- There has been work on this recently. Can you see this in a master build, Win-x86_64@tb77-TDF https://dev-builds.libreoffice.org/daily/master/current.html ? Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away. -- You are receiving this mail because: You are the assignee for the bug.