[Libreoffice-qa] bug 72915

Robinson Tryon bishop.robinson at gmail.com
Mon Nov 25 20:07:55 PST 2013

On Mon, Nov 25, 2013 at 10:54 PM, Tim Lloyd <tim.lloyd at gmx.com> 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?


More information about the Libreoffice-qa mailing list