https://bugs.documentfoundation.org/show_bug.cgi?id=155194
--- Comment #3 from Serg A <[email protected]> --- If anyone finds similar case, please link, I could not find it. The problem is that if I want to edit the cell, the value is presented in the format that the software is unable to read. This is IMHO a bug. Possible solution would be either - for edit, display the value using the format the software can recognize OR - after edit, recognize using the pattern used for the display. For example, one could use "YYYY-MM-DD HH:MM:SS" for edit as it is recognized always independent from the "Date acceptance patterns" setting. By the way, the Input line is already formatted this way when cell format is "YYYY-MM-DD HH:MM:SS". However, for some reasons, it is changed to "MM/DD/YYYY HH:MM:SS" if I set cell format to "DD.MM.YYYY HH:MM:SS". Why? If the user has set cell format to something different (like "DD.MM.YY HH:MM"), it would be nice to use similar format (in this case "DD.MM.YYYY HH:MM:SS") to display AND to recognize the edited input. -- You are receiving this mail because: You are the assignee for the bug.
