while creating a chart and formatting cells to fractions a couple of cells would not accept the formatting. Specifically 3/32 and 29/32 which instead of those values, puts in a "0" and "1" respectively.have tried new sheets, different cells, even user defined to no avail.
(In reply to comment #0) > while creating a chart and formatting cells to fractions a couple of cells > would not accept the formatting. Specifically 3/32 and 29/32 which instead of > those values, puts in a "0" and "1" respectively.have tried new sheets, > different cells, even user defined to no avail. Try to use the 2nd Fraction formatting "# ??/??" it will accept 2 digit fractions otherwise it calculates the fraction and is rounding it. 3/32 is less than 0.5, 29/32 is greater than .5.
(In reply to comment #1) I, too, have found 3/32 will not display correctly even when using the 2nd Fraction formatting "# ??/??". It displays as 0. I created a list of all the /32 fractions from 1 to 32 and they all display properly except for 3/32 and 29/32.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.