41463.000 On Mon, Nov 25, 2013 at 10:54 PM, Tim Lloyd <[email protected]> wrote: > Hi, can someone advise pls? > > https://bugs.freedesktop.org/show_bug.cgi?id=72015 > > 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 "1/2" I see "½", which is different. I assume autocorrect is doing replacements on text (which is a little strange for a cell formatted as a number, but..there you go :P) > If I > enter (eg.) 1/5 the cell shows 41395.000. > > If I enter 7/8 the cell shows 41493. If I enter 7/8 I get 41463.000. If I enter =7/8 I get 0.875 (although internally it appears that Calc does save the fact that I entered "=7/8") > 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? I guess it can if we specify the right Unicode chars in autocorrect? Cheers, --R _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: [email protected] Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
