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 (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?

Cheers
_______________________________________________
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/

Reply via email to