[Libreoffice-bugs] [Bug 148535] Fraction formatting in Calc gives the wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=148535 Mike Kaganski changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEEDINFO|RESOLVED --- Comment #4 from Mike Kaganski --- As noted in comment 3, the documentation explains how to use the fraction feature properly; this specific case (1/10) is even mentioned there directly. Just to reiterate: defining denominator number of digits, you define the "resolution" of the resulting number visual representation. It will never exceed that resolution (by using more digits than defined in the format); and using 1-digit denominator, you can approximate *any* value (1/9 being the best approximation for 0.1, as well as for any number greater than 1/18). OTOH, numerator would add as many digits as needed to represent that approximation - that way, "?/?" would give you "19/9" for "2.1" This behaves the same way as for decimal representation like "#.#", where the whole part would expand as needed, and fractional part would never expand. Or put in other words: you must never expect to see the *exact* representation of any fractional number on screen, only some approximation according to the number format. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148535] Fraction formatting in Calc gives the wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=148535 sdc.bla...@youmail.dk changed: What|Removed |Added CC||er...@redhat.com, ||mikekagan...@hotmail.com --- Comment #3 from sdc.bla...@youmail.dk --- @Rofo - I agree the behavior is surprising. But I believe it is by design. https://help.libreoffice.org/master/en-US/text/scalc/guide/fraction_enter.html If you use Format Cell (Numbers tab) notice that you can choose different predefined formats for fraction and immediately see the result in the preview window. Notice also the "Format Code" control in the Numbers tab. This shows the number codes used to define the format. You can also make your own custom formats. See: https://help.libreoffice.org/master/en-US/text/shared/01/05020301.html (where there is a special section on fractions) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148535] Fraction formatting in Calc gives the wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=148535 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #2 from Roman Kuznetsov <79045_79...@mail.ru> --- Rofo your problem is solved by tip in Comment 1? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148535] Fraction formatting in Calc gives the wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=148535 sdc.bla...@youmail.dk changed: What|Removed |Added Summary|Fraction|Fraction formatting in Calc ||gives the wrong result CC||sdc.bla...@youmail.dk --- Comment #1 from sdc.bla...@youmail.dk --- When Denominator Places is set to "2" (using Options for Fraction in Format Cells dialog), then it appears as 1/10. Tested with 7.2.6.2 and 7.4.0.0+ -- You are receiving this mail because: You are the assignee for the bug.