<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:kalle@goodtimes.fi" title="ikjt <kalle@goodtimes.fi>"> <span class="fn">ikjt</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - User setting for default date format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=41044">bug 41044</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>kalle@goodtimes.fi
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>WORKSFORME
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - User setting for default date format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=41044#c15">Comment # 15</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - User setting for default date format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=41044">bug 41044</a>
from <span class="vcard"><a class="email" href="mailto:kalle@goodtimes.fi" title="ikjt <kalle@goodtimes.fi>"> <span class="fn">ikjt</span></a>
</span></b>
<pre>Marking as NEW (again).
As I understand it, this bug (as reported) is a request to implement a setting
for a default *display* format for dates. Unless I'm mistaken, such a feature
still does not exist.
<a href="show_bug.cgi?id=41044#c12">Comment 12</a> refers to the date *input* pattern preference, which has nothing do
with the bug at hand. Thus, the bug was incorrectly marked as resolved.
Let me clarify the issue:
Currently, when a date is entered into a cell that doesn't have explicit
formatting applied, the date is formatted according to the current locale.
There are a few problems with this:
(1) There are countless of situations where a locale-dependent customary format
is simply not suitable and a standard format such as ISO 8601 is required. This
is a spreadsheet program after all.
(2) The locale-specific formats always seem to have two-digit years, which is
not what most people want, even if they are happy with the customary format per
se.
(3) Changing the locale affects a host of other things, too, such as the
parameter separators in formulas. For this reason, some users may prefer to
stick with the default locale even if it doesn't reflect their country or
working language.
The obvious way to fix this would be to provide a preference for a default
format string alongside the input acceptance patterns.
The two-digit year issue should be addressed separately. The current default
behavior is not good, regardless of whether there's a setting to override the
default format or not.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>