[Libreoffice-bugs] [Bug 52288] [DE] EDITING: Allow truncated date inputs from numeric keyboard

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52288

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--- Comment #3 from Rainer Bielefeld <LibreOffice at 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.