[Libreoffice-qa] bug 72915

Tim Lloyd tim.lloyd at gmx.com
Mon Nov 25 19:54:57 PST 2013

Hi, can someone advise pls?


The behaviour specified by fcannon is reproducible. I format a calc cell 
as a number with 3 decimal points:

If I enter whole units, 1/4, 1/2, 3/4 the display shows what I entered. 
If I enter (eg.) 1/5 the cell shows 41395.000.

If I enter 7/8 the cell shows 41493.

The funny thing is...so does excel!!

I had a look at the handbook for 3.4 which does not provide any 
examples. Should calc be able to handle fifths, eighths, etc. when a 
cell is formatted to be a number?


More information about the Libreoffice-qa mailing list