https://bugs.freedesktop.org/show_bug.cgi?id=52288
Rainer Bielefeld <libreoff...@bielefeldundbuss.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |enhancement --- Comment #3 from Rainer Bielefeld <libreoff...@bielefeldundbuss.de> 2012-07-21 06:16:31 UTC --- IMHO for date formatted cells we should have a very aggressive date recognition, may be to be activated by an extra checkbox. Of course it will not be easy to get a quick solution for all localizations, but IMHO there exit some very plausible assumptions. a) Users who are very interested in this feature are experienced, use well prepared and so well formatted spreadsheet templates b) These templates have well defined cells only used for a particular kind of data. For example a cash account book has a column for - amount of money, only currency inputs - income date, only date values - payed date: only date inputs - subject, only text inputs. c) In these columns it is clear that the only exception for inputs differing from the selected formatting can be a text, no date input makes sense in a currency field and vice versa. Draft: d) so for a date field you can assume: da) A single number always will represent the Day number of the current Month of the current year db) 2 numbers separated by an arbitrary separator always will represent the Day number and the Month of the current year dc) 3 numbers separated by the same arbitrary separator always will represent Day and Month and current year e) in a document related property nearby the "activate aggressive date recognition user has to define whether such inputs have to be uninterpreted as - Y M D (ISO, default) - D M Y - M C Y (I do not believe that other ones are used very often?) f) For all other inputs and for cells not formatted as date the more restrictive date recognition started in LibO 3.6 will be used. -- 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