https://bugs.documentfoundation.org/show_bug.cgi?id=153281
--- Comment #3 from ady <[email protected]> --- (In reply to Eike Rathke from comment #2) > Note that the input of 1/4 getting converted to U+00BC ΒΌ happens already on > editing level, hence the input the cell receives is already text. Thank you for your reply. I still see this default behavior as non-intuitive and goes against other methods we have know for decades (e.g. forcing it as text by means of apostrophe). IOW, 2 inconsistencies, and very subjective default behavior. Users can't force each individual input to be treated as date - or as fraction. But each input can be forced to be treated as text. So choosing to force it to be a text by default reduces the available alternatives for users. It's a simple logical flowchart. When using AutoCorrect to force this input as text, the cell format should be text, not date. If Autocorrect is not enabled to force the input as text, then its OK for the cell format to be a date (and the input to be treated as such too). The current mix doesn't make sense to me, and certainly it is not intuitive or natural. -- You are receiving this mail because: You are the assignee for the bug.
