Bug 46452

Summary:	Default formatting can not be changed
Product:	LibreOffice	Reporter:	daniel.schaaaf
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	sasha.libreoffice
Version:	3.5.0 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:

Description daniel.schaaaf 2012-02-22 06:09:17 UTC

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.

Comment 1 sasha.libreoffice 2012-05-23 04:43:31 UTC

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.