https://bugs.freedesktop.org/show_bug.cgi?id=46452
Bug #: 46452 Summary: Default formatting can not be changed Classification: Unclassified Product: LibreOffice Version: LibO 3.5.0 Release Platform: All OS/Version: All Status: UNCONFIRMED Severity: major Priority: medium Component: Spreadsheet AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: daniel.ma...@umb.no 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. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs