Bug 53680

Summary: formatting
Product: LibreOffice Reporter: billy bob <billybob1702>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium    
Version: 3.5.4 release   
Hardware: Other   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:

Description billy bob 2012-08-18 16:34:45 UTC
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.
Comment 1 Horst 2012-09-20 16:38:36 UTC
(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.
Comment 2 Heumier 2013-01-26 18:26:22 UTC
(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.