[libreoffice-users] Re: Calc cell formats

El 2015-10-03 a las 04:03, Andreas Säger escribió:
> Am 03.10.2015 um 04:23 schrieb Thomas:

> If you want to enter any kind of date on the num pad, the following used
> to work with all types of spreadsheets, including LO 3.5, but LO 3.6
> messed it up.
> 20/ --> this month's 20th day
> 20/7 --> this year's 20th of July
> 7/20 --> same in US context
> The appearance of that entry is completely unrelevant as long as you
> entered the correct value which is 42205 in case of 20 July 2015. You
> can format that value any way you want but it has to be the correct
> number. LO introduced that idiotic "date recognition pattern" in the
> language options which may make everything more complicated than the
> above simple entry pattern.


I disagree with that opinion.  It is a great thing that the user can 
adjust the pattern of characters of an date.  I prefer to use the
ISO system, but receive dates formated with the american system.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted