https://bugs.documentfoundation.org/show_bug.cgi?id=155194
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Eike Rathke <[email protected]> --- (In reply to Serg A from comment #3) > 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. You *forced* it to do so, by setting the only date acceptance pattern to D.M.Y but your locale obviously uses something different if ... > 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? What is your locale? Likely en-US or derived (because of the M/D/Y order in the edit date format). An existing date to be edited is presented in the locale's date format unless the display format is an ISO 8601 YYYY-MM-DD format. Please copy-paste the information from the Help -> About dialog. > 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. No, because you can set _arbitrary_ display formats that can't necessarily be parsed or the user wouldn't even know how to enter (e.g. other locales' month names or even calendars). (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. -- You are receiving this mail because: You are the assignee for the bug.
