[Libreoffice-qa] bug 72915

[Robinson Tryon]

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

Cheers,
--R