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