[Libreoffice-bugs] [Bug 139890] Specific calc entries e.g. 1/4, 1/8 are changed to a date or a fraction (see notes below) whether cell is text or not

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139890

--- Comment #2 from jim_away at hotmail.com ---
(In reply to Uwe Auer from comment #1)
> This is caused by Tools -> AutoCorrect Options...-> Tab: Replace. There are
> entries in the replacement table ":1/2:",":1/3:",":1/4:",":1/8"; and further
> down "1/2","1/4" and "3/4". In addition there are locales having "M/D" or
> "D/M" as a date acceptance pattern in Tools -> Options -> Language Settings
> -> Languages -> Option: Date acceptance pattern. So there are 3 situations:
> 
> 1) Input matches entry in replacement table ->  fraction glyph appears
> 2) Input matches date acceptance pattern -> date is shown
> 3) Input doesn't match any of 1) or 2) -> text is shown
> 
> Solutions:
> 
> 1) Change date acceptance pattern, if regularly using fraction as pure text
> 2) Prepend input with single quotation mark "'" i.e enter '1/9 for text
> 3) Remove entries from replacement table (fixes only situation 1))
> 
> 
> From my perspective not a bug.


The note about the "glyph appears" for the specific instances like 1/4, 1/2 at
my end is true in "ALL" cases to include prepend these specific instances with
the apostrophe, e.g. '1/4 should be the text three characters of a 1 a slash
and a four.  However, that is not what happens.  I get the fraction glyph which
has not be the case prior to the update referenced.  Prior to this update I
could enter 01/4 or 01/8 or 01/2 specifically and get the text not the fraction
glyph.  Now, no matter what I do, I get the glyph 99 44/100% of the time but
not always.  Today I re-attempted to use the '1/4 and got the glyph.  It seems
the apostrophe for text is being ignored which I believe it should not be
ignored hence the bug report.  I did try '01/4 and unfortunately the result was
not consistent but I did get '01/4 NOTE:  the apostrophe remained visible which
I do not think it should.

For the example used above, '1/9 it has always worked infact the apostrophe is
not necessary in a text cell.  '1/4 and 1/2 and 1/8 in a text field even with
the leading apostrophe, e.g., '1/4 produces the glyph fraction and NOT the
desired three characters of one, slash, and four.

Hope this shows why I believe this concern to be a BuG!  Thank you your
interest and the information you provided for me to try different ways to work
with this situation so that I can have the data entry work as desired in the
spread sheet.  I will be giving a go at some of the other possibilities
mentioned to attempt to learn if they will negatively impact our work flow.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210125/8d227a95/attachment-0001.htm>