[Libreoffice-qa] bug 72915
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