Input is interpreted by LibreOffice and Calc chooses a format automatically. If, e.g., the user enters "18.03.12" into a cell, Calc will apply the local date-format to that cell and might change it to "03/18/12".
The default formatting should be customizable by the user. In the given example a user might want Calc to apply a "dd.mm.yyyy" formatting, even though the locale setting is "English (USA)".
This applies to all other possible formats in Calc.
The input recognition itself should also be customizable. If the user, e.g., enters "4/5" into a cell, Calc might interpret the input as a date and change it to "04/05/12". But the user might want Calc to recognize "4/5" as text with only "4/5/12" or "4.5.12" being recognized as a date.
Thanks for new idea
Indeed, currently we have only one option inside of Tools->Options->LibreOffice Calc->Defauls: Number of sheets.
In another place we can set default language.
So, not implemented yet, changing status to New
Build ID: c89294233b6a9ffc1bd75e6e9226ad723b7d5538
CPU Threads: 2; OS Version: Linux 3.16; UI Render: default;
Locale: en-US (en_US.UTF-8)
Still a valid enhancement request.
*** This bug has been marked as a duplicate of bug 46448 ***