<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139890#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - 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" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139890">bug 139890</a> from <a class="email" href="mailto:jim_away@hotmail.com" title="jim_away@hotmail.com">jim_away@hotmail.com</a> <pre>(In reply to Uwe Auer from <a href="show_bug.cgi?id=139890#c1">comment #1</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>