<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Allow custom locale settings for decimal separator, group separator, default date and time formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=46448#c32">Comment # 32</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Allow custom locale settings for decimal separator, group separator, default date and time formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=46448">bug 46448</a> from <a class="email" href="mailto:daniel.schaaaf@gmail.com" title="daniel.schaaaf@gmail.com">daniel.schaaaf@gmail.com</a> <pre>(In reply to Jonny Grant from <a href="show_bug.cgi?id=46448#c30">comment #30</a>) > in my whole life here, I've never seen anyone type or write a date as > DD/MM/YY I bet you haven't experienced right-hand traffic either ;-) I live in one of the many countries that use dd.mm.yy as the date format. But that's irrelevant. At my workplace, we get data from countries such as England. And in my own country, yyyymmdd is not uncommon either. Take a look at my second comment here. The point of this bug report is that LO interprets numbers a certain way. Once interpreted, the original input is lost. Users can neither change how input is interpreted, or prevent the interpretation in the first place. If any interpretation/conversion of data is being performed, it should be done so according to a user chosen format. In case of Calc, I expect the cell formatting to determine how LO interprets the input. The year is 2020, and I still have to use Notepad++ to tweak data into a format that is "compatible" with Calc.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>