I have a form that is designed so that data can be entered with the numeric keypad -- however this does not work for date fields (locale is de_DE, and there is no dot on the numeric pad, only a comma).
It would be nice to have a defined method for quickly entering dates on the numeric pad, ideally without separators as it is easier to type zeros than dashes or slashes.
Hi Simon, thanks for reporting.
Have you taken a look in?
Menu/Tools/Options/Language settings/Languages - Date acceptance patterns.
I have now. :) Unfortunately, that doesn't work for me.
I've tried adding the formats "D,M" and "D,M,Y" as these would be easy to type, but "1,3,13" gives 1800-01-01. The help mentions ISO dates being acceptable, however neither "13-3-1" nor "2013-3-1" give the desired result (these behave as if nothing was entered, and copy the date from the previous entry).
Sorry Simon, I have just seen your report is about database, if a find some information about it I'll let you know.
In a first try, ISO "2013-3-1" date works for me in a date field directly in the table. Maybe in your language minus "-" it is not a separator for dates.
It isn't, however the help text explicitly states that ISO dates are always accepted regardless of locale.
This is a date entry field in a table in a Form.
Please Simon, take a look to this link, maybe can help.
Can you attach a sample file?
Please reduce data at minimum needed and delete all private information.
Created attachment 83622 [details]
This is a minimal example, containing a table and a form to edit the table data.
In the form, the date column does not accept ISO dates or dates following the configured acceptance pattern -- only dates from the current locale appear to be allowed.
Created attachment 83627 [details]
Screenshot editing the column properties.
I think you need to define properly the date format for the column.
While you edit the form, right-click the date column head, and select Column to edit the their properties.
That does affect display as well, which I'd rather avoid.
There are two issues I can see here:
- the date entry in the form code does not go through the same code path that the normal date entry does, thus ignoring date entry preferences
This I'd think of as a (minor) bug.
- there is no easy format for date entry using the numeric keypad.
This is definitely an enhancement. It would be awesome if I could use "DMY" as a date format so I can use zero-padded dates without separator.
I'm not sure whether this could/should be split.
Well Simon, as I have write in you other bug report, why no trying to get help in Ask or in Mailing List.
Lionel - is there some reason why we couldn't add this functionality? I'm thinking if open standards wouldn't allow it for some strange reason. Don't want to mark as NEW until I have confirmation that it's a valid enhancement request.
Adding self to CC if not already on
Migrating Whiteboard tags to Keywords: (EasyHack SkillCpp)
JanI is default CC for Easy Hacks (Add Jan; remove LibreOffice Dev List from CC)
One of the major reasons I have been unwilling to migrate to LO is it's lack of date handling for those of us who are heavy 10-key users. With OO entering a period in a date field always produced an ISO date. This jewel should not be so deeply hidden: Menu/Tools/Options/Language settings/Languages - Date acceptance patterns!!
A date entered with periods should be a default input pattern!
I also just found the "legacy" selection which gets rid of the stupid marching ants around a selection!! Bravo! The "legacy" selection should be the standard....
Needs code pointer.