https://bugs.documentfoundation.org/show_bug.cgi?id=155194
--- Comment #5 from ady <[email protected]> --- (In reply to Eike Rathke from comment #4) > (In reply to ady from comment #2) > > Moreover, the cell format is still marked as date, while it behaves as text. > No. The input wasn't recognized/accepted as date hence the cell content is > kept as text. While following the procedure, the cell _is_ first recognized as date when the date is first introduced. "=A1+1" gets a date as result. Only after the "fake" edit, the behavior changes to text. After following the complete procedure as presented in comment 0, the cell shows and behaves as text, while: * the Format code shows the same "DD.MM.YYYY HH:MM:SS" as before; and * the toolbar shows the format as "date". Yes, the format is now "text". We, users, might not be doing the right thing. I'm saying that it is easy for users to be confused by the contradicting information presented versus the behavior after the ("fake") first cell edition: the cell was behaving as "date", showing format as "date", and suddenly it behaves as "text" **while still showing some other info as "date" **. Yes, there is Value Highlighting, and ISTEXT() and similar functions, and yet users get confused. I have no idea whether there is some way to improve this – this is not the first time we've seen this problem. -- You are receiving this mail because: You are the assignee for the bug.
