[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 #1 from Uwe Auer <uwe at franke-auer.de> ---
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.

-- 
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/32ea0838/attachment.htm>