Comment 34 for bug 391572

@er:

> Please check again. The edit format _does_ follow the
> locale setting, it just does not follow a modified LC_TIME
> or Windows' Regional Setting's date mask, for example.

This sounds like a bug in and of itself -- for aren't LC_TIME and date mask
settings part of the locale settings?

> Also, there are ways to override the locale:

But the locale settings presented in either of the two OOo dialogs mentioned do
not have any ISO listing, nor is there any way of finding the ideal combination
of number, currency, and date formats aside from extensive trial and error.
This is both tedious and onerously inefficient.

> And no, one does not always want to edit the date in the
> same format it is displayed, the ISO 8601 format is an
> exceptional case where that indeed is wanted.

Yet, setting up the default editing behaviour to use a separate unexplained
format from the display format is both poor usability and an invitation to
error. I would argue that the expected behaviour at least 90% of the time is
for the editing and display format to match. Allowing an *option* for editing
and display formats to be separate would be welcome. The current configuration
is confusing and completely unacceptable.

There is a reason other spreadsheet programs do not work this way.