https://bugs.freedesktop.org/show_bug.cgi?id=51697
matteo sisti sette <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #8 from matteo sisti sette <[email protected]> --- > This behaviour is as I expected it to be. > The locale dictates how entered dates > are handled (in the case of nl-NL, that is dd-mm-yy) > and the cell format dictates how a date value is displayed. Exactly. I thought I had made that pretty clear in the original report two years and a half ago. To me it seem obvious that it is not the right behavior. It is counterintuitive that dates are not displayed the same way as they are entered. I open a spreadsheet, see some dates, and the most obvious thing I expect is to be able to type them in the same format they are displayed, regardless of the locale of the computer where I'm opening the file. I do understand that may be users who would prefer the current behavior. For example, if you happen to often enter data into spreadsheets that are not in your own language, and you want to enter the dates in the way you are accustomed to write them. So in my opinion the best option would be to have a setting to deternine whether input is parsed according to current locale or according to cell format. Until then, it should be done according to cell format. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
